On 10 Sep 2003 11:05:34 -0700,
a.*****@usa.net (affiori) wrote:
Can anybody shed some light on this error?
When I try to create tables for the database for phpnuke using the
supplied sql file when i get toe "nuke_contactbook" table, I get back
this:
=========
Error
SQL-query :
CREATE TABLE nuke_contactbook(
uid int( 11 ) NOT NULL default '0',
contactid int( 11 ) NOT NULL AUTO_INCREMENT ,
firstname varchar( 50 ) default NULL ,
lastname varchar( 50 ) default NULL ,
email varchar( 255 ) default NULL ,
company varchar( 255 ) default NULL ,
homeaddress varchar( 255 ) default NULL ,
city varchar( 80 ) default NULL ,
homephone varchar( 255 ) default NULL ,
workphone varchar( 255 ) default NULL ,
homepage varchar( 255 ) default NULL ,
IM varchar( 255 ) default NULL ,
EVENTS text,
reminders int( 11 ) default NULL ,
notes text,
PRIMARY KEY ( contactid ) ,
KEY uid( uid ) ,
KEY contactid( contactid )
) TYPE = MYISAM
MySQL said:
#1064 - You have an error in your SQL syntax near 'EVENTS text,
reminders int( 11 ) default NULL ,
notes text,
PRIMARY KEY ( con' at line 13
=========
Many thanks,
Works fine here.
mysql> CREATE TABLE nuke_contactbook(
-> uid int( 11 ) NOT NULL default '0',
-> contactid int( 11 ) NOT NULL AUTO_INCREMENT ,
-> firstname varchar( 50 ) default NULL ,
-> lastname varchar( 50 ) default NULL ,
-> email varchar( 255 ) default NULL ,
-> company varchar( 255 ) default NULL ,
-> homeaddress varchar( 255 ) default NULL ,
-> city varchar( 80 ) default NULL ,
-> homephone varchar( 255 ) default NULL ,
-> workphone varchar( 255 ) default NULL ,
-> homepage varchar( 255 ) default NULL ,
-> IM varchar( 255 ) default NULL ,
-> EVENTS text,
-> reminders int( 11 ) default NULL ,
-> notes text,
-> PRIMARY KEY ( contactid ) ,
-> KEY uid( uid ) ,
-> KEY contactid( contactid )
-> ) TYPE = MYISAM;
Query OK, 0 rows affected (0.01 sec)
mysql> desc nuke_contactbook;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| uid | int(11) | | MUL | 0 | |
| contactid | int(11) | | PRI | NULL | auto_increment |
| firstname | varchar(50) | YES | | NULL | |
| lastname | varchar(50) | YES | | NULL | |
| email | varchar(255) | YES | | NULL | |
| company | varchar(255) | YES | | NULL | |
| homeaddress | varchar(255) | YES | | NULL | |
| city | varchar(80) | YES | | NULL | |
| homephone | varchar(255) | YES | | NULL | |
| workphone | varchar(255) | YES | | NULL | |
| homepage | varchar(255) | YES | | NULL | |
| IM | varchar(255) | YES | | NULL | |
| EVENTS | text | YES | | NULL | |
| reminders | int(11) | YES | | NULL | |
| notes | text | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
15 rows in set (0.01 sec)
--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (
http://www.andyh.co.uk)
Space: disk usage analysis tool (
http://www.andyhsoftware.co.uk/space)