PHPNuke 6.8 MySQL nuke_contactbook error

[affiori]

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_contactbo ok" table, I get back
this:
=========
Error

SQL-query :

CREATE TABLE nuke_contactboo k(

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

[Andy Hassall]

Re: PHPNuke 6.8 MySQL nuke_contactboo k error

On 10 Sep 2003 11:05:34 -0700, a.fiori@usa.net (affiori) wrote:
[color=blue]
>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_contactbo ok" table, I get back
>this:
>=========
>Error
>
>SQL-query :
>
>CREATE TABLE nuke_contactboo k(
>
>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,[/color]

Works fine here.

mysql> CREATE TABLE nuke_contactboo k(
-> 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_contactboo k;
+-------------+--------------+------+-----+---------+----------------+
| 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)

[affiori]

Re: PHPNuke 6.8 MySQL nuke_contactboo k 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:<uhuulvcbc v37dp7cg27dtsts 13d8gee96s@4ax. com>...[color=blue]
> On 10 Sep 2003 11:05:34 -0700, a.fiori@usa.net (affiori) wrote:
>[color=green]
> >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_contactbo ok" table, I get back
> >this:
> >=========
> >Error
> >
> >SQL-query :
> >
> >CREATE TABLE nuke_contactboo k(
> >
> >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,[/color]
>
> Works fine here.
>
> mysql> CREATE TABLE nuke_contactboo k(
> -> 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_contactboo k;
> +-------------+--------------+------+-----+---------+----------------+
> | 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)[/color]