I'm attempting to run firstpost on a winNT box. When I try to import the firstpost.sql file I get the following errors.
MySQL said: You have an error in your SQL syntax near 'left','right','bottom') DEFAULT 'left' NOT NULL, Title varchar(255) DEFAULT '' at line 1
MySQL said: You have an error in your SQL syntax near '0' NOT NULL, VisibleToAll enum('y','n') DEFAULT 'n' NOT NULL, PRIMARY KEY ' at line 1
MySQL said: You have an error in your SQL syntax near '0' NOT NULL, SectionID int(10) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY ' at line 1
MySQL said: You have an error in your SQL syntax near '0' NOT NULL, ); CREATE TABLE HiddenTopics ( HiddenTopicID int(10) u' at line 1
The list seems to continue. The only table that doesn't have any errors on creation is the articles table. I have been trying to load this using MySQL 3.23.28-gamma and PhpMyAdmin. If there are incompatabilities could you please tell me what version of MySQL I should be using and where to get it if it's nologer available at mysql.com. Thank you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Try, running the queries in parts,.. it works that way,.. i don't know why this happens, but it also happens when you successfully create the database, and then dump it again,.. must be something with phpmyadmin, or mysql
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm attempting to run firstpost on a winNT box. When I try to import the firstpost.sql file I get the following errors.
MySQL said: You have an error in your SQL syntax near 'left','right','bottom') DEFAULT 'left' NOT NULL, Title varchar(255) DEFAULT '' at line 1
MySQL said: You have an error in your SQL syntax near '0' NOT NULL, VisibleToAll enum('y','n') DEFAULT 'n' NOT NULL, PRIMARY KEY ' at line 1
MySQL said: You have an error in your SQL syntax near '0' NOT NULL, SectionID int(10) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY ' at line 1
MySQL said: You have an error in your SQL syntax near '0' NOT NULL, ); CREATE TABLE HiddenTopics ( HiddenTopicID int(10) u' at line 1
The list seems to continue. The only table that doesn't have any errors on creation is the articles table. I have been trying to load this using MySQL 3.23.28-gamma and PhpMyAdmin. If there are incompatabilities could you please tell me what version of MySQL I should be using and where to get it if it's nologer available at mysql.com. Thank you.
Try, running the queries in parts,.. it works that way,.. i don't know why this happens, but it also happens when you successfully create the database, and then dump it again,.. must be something with phpmyadmin, or mysql