View unanswered posts | View active topics |



Print view
Previous topic | Next topic 

Problem with MYSQL

Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
 
Author Message
MG4all
 Post subject: Problem with MYSQL
PostPosted: Mon Oct 03, 2005 7:51 pm 
Uncooked
Not Signed Up For Stats

Joined: Mon Oct 03, 2005 7:28 pm
Posts: 3
I have a problem when i make the tables from the file 'statstables.sql' in MYSQL. The errormessage is :

SQL-Befehl :

create table if not exists scorched3d_eventtypes (
eventtype INTEGER,
name varchar(32),
PRIMARY KEY (eventtype)
)

MySQL meldet:


All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Please HELP !
Top
 Profile  
 
gcamp
 Post subject:
PostPosted: Tue Oct 04, 2005 1:44 pm 
User avatar
Site Admin
Not Signed Up For Stats

Joined: Mon Aug 04, 2003 4:09 pm
Posts: 4771
Location: Scotland
Looks ok to me, what version of mysql are you using?
Top
 Profile  
 
MG4all
 Post subject:
PostPosted: Tue Oct 04, 2005 5:37 pm 
Uncooked
Not Signed Up For Stats

Joined: Mon Oct 03, 2005 7:28 pm
Posts: 3
Im use MYSQL 3.23.36 and WinMySQLadmin 1.3
Top
 Profile  
 
gcamp
 Post subject:
PostPosted: Thu Oct 06, 2005 4:41 pm 
User avatar
Site Admin
Not Signed Up For Stats

Joined: Mon Aug 04, 2003 4:09 pm
Posts: 4771
Location: Scotland
try this

Code:
create table if not exists scorched3d_eventtypes (
eventtype INTEGER not null default 0,
name varchar(32),
PRIMARY KEY (eventtype)
)


Top
 Profile  
 
MG4all
 Post subject:
PostPosted: Sat Oct 08, 2005 6:13 am 
Uncooked
Not Signed Up For Stats

Joined: Mon Oct 03, 2005 7:28 pm
Posts: 3
Thanks thats OK. The tables all createt.
A new problem.
I have edit the server.xml and the mysql.xml but the stats isnt work.
On my computer is the apache server running.
Where is the problem ?
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 

Board index » Help » help and troubleshooting

Who is online

Users browsing this forum: No registered users and 2 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group