Menu

sql errors when loading firstpost.sql

Help
2001-01-03
2001-05-29
  • William Snyder

    William Snyder - 2001-01-03

    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.

     
    • hafif uyku

      hafif uyku - 2001-05-29

      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

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.