473,327 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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
Jul 16 '05 #1
2 2078
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)
Jul 16 '05 #2
Andy, I am using phpmyadmin 2.5.3 and it's still giving that error.
Any ideas? Anyone?

Thx

Al

Andy Hassall <an**@andyh.co.uk> wrote in message news:<uh********************************@4ax.com>. ..
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)

Jul 16 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: John Beardsworth | last post by:
Hi I'm customising phpNuke as an intranet application. The client would like the option of letting users post news stories without administrators' approval, so I've added a function to the...
0
by: Keegan Alex | last post by:
Hi folks... I just installed phpnuke, and it's a great program. One problem is the Splatt forum really stinks. I'd LOVE to replace it with phpBB, but I'm not sure how. Can someone tell me if...
2
by: Keegan Alex | last post by:
Hi folks, I downloaded PHP-Nuke 6.7, and after reading the INSTALL file, it looks very simple... but either i'm reading them wrong or they're very flawed. First, it says: Untar the package...
0
by: Mark Boyden | last post by:
There have been several messages on newsgroups about problems with phpNUKE related to a post-installation error of: Fatal error: Call to undefined function: message_die() in...
0
by: cjescudero | last post by:
Hello: I am going to develop a web site to manage a conference, i.e.: - Submission of presentations - Registration of assistants - Hotel booking - … I have experience in programming...
9
by: Market Mutant | last post by:
PhpNuke is the worse written PHP script as I heared then what does not suck? I need a fast, simple, CMS. I don't need that many hacks. No MySQL is the best. CMS is about news, and forum. I found...
3
by: Jerry | last post by:
Hi Does anybody have some experience with PHPNuke, the php/MySQL based cms ? I seem to be unable to figure out how the the topbar navigation can be changed. There is no reference to it in the...
1
by: Leave Me Alone | last post by:
Hey folks... I have a standalone phpBB forums and just recently installed PHPNuke on my website. I know phpnuke comes with it's own version of phpBB. How can I make it possible for members who...
2
by: anon | last post by:
I copied over the phpnuke html files (latest version from sourceforge), created a mysql DB, added the settinsg to the config file. Anything else I need to do? When I run admin.php, I get a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.