Sorry, the problem is that when creating tables for the database for phpnuke using the supplied sql file of which I am troubleshooting. I created all the tables up to the "contactbook" table. When I copied/pasted the table structure, I get back this:
MySQL said:
You have an error in your SQL syntax near 'events text, reminders int(11) default NULL, notes text, PRIMARY KEY (contactid)' at line 1
here is the code:
Table structure for table nuke_contactbook
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;
Dumping data for table nuke_contactbook
SINCE I am just copy/pasteing, I don't understand what the heck is wrong? Another user told me that the syntax looked fine, that maybe I had a version conflict or something, so I started troubleshooting and I found the two different versions of mysql and thought that maybe there was a conflict somewhere. Upon further reading, I read that MySQL really wants its own c:/mysql directory but the phpdev I have puts a mysql directory in c:/phpdev/ (and works fine). So, intrying to not begin the learning curve with any bad habits, I am trying to:
1. have my directory trees configured correctly for ease of use and proper security,
2. get that contactbook table working so that I can implement that functionality in the final content management system product.
Thanks, Richard
