PHPNuke 6.8 MySQL nuke_contactbook error
This is a discussion on PHPNuke 6.8 MySQL nuke_contactbook error within the PHP Language forums, part of the PHP Programming Forums category; Can anybody shed some light on this error? When I try to create tables for the database for phpnuke using ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
09-10-2003
|
|||
|
|||
PHPNuke 6.8 MySQL nuke_contactbook error
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, Al 
|
|
09-10-2003
|
|||
|
|||
|
Re: PHPNuke 6.8 MySQL nuke_contactbook error
On 10 Sep 2003 11:05:34 -0700, a.fiori@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 (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk) Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
|
|
09-11-2003
|
|||
|
|||
|
Re: PHPNuke 6.8 MySQL nuke_contactbook error
Andy, I am using phpmyadmin 2.5.3 and it's still giving that error.
Any ideas? Anyone? Thx Al Andy Hassall <andy@andyh.co.uk> wrote in message news:<uhuulvcbcv37dp7cg27dtsts13d8gee96s@4ax.com>. .. > On 10 Sep 2003 11:05:34 -0700, a.fiori@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)
|
Linear Mode
