No announcement yet.

Having a 1064 Error....

  • Filter
  • Time
  • Show
Clear All
new posts

  • Having a 1064 Error....

    Hey all, i have searched the forums and havn't found anyone with my exact problem yet.. so here it goes.....

    i just backed up my old phpbb database from lycos using phpmyadmin (highlighted all the tables, Structure and data backup, checked off "complete inserts", "extended inserts" and saved it as a file.

    i then went to my new server, uploaded the old database, and tried to convert from phpbb to vbulletin with the impex program... i was able to connect and checked the file and everything, and i went to go import users and it keeps giving me this error now

    Database error in vBulletin:ImpEx Source 3.0.1:
    Invalid SQL:
    SELECT * FROM users
    ORDER BY user_id
    LIMIT 0,
    mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
    mysql error number: 1064
    Date: Thursday 17th of June 2004 01:24:21 PM
    Username: XGoDxIcEX
    IP Address:
    can anyone help? ...

    line 3 of the backup of the database is somewhere around here...

    # phpMyAdmin MySQL-Dump
    # version 2.2.1-dev
    # (download page)
    # Host:
    # Generation Time: Jul 17, 2004 at 06:48 PM
    # Server version: 3.23.33
    # PHP Version: 4.3.2
    # Database : `username_uk_db`
    # --------------------------------------------------------
    # Table structure for table `php4u_bookmarks`
    CREATE TABLE php4u_bookmarks (
    id int(10) unsigned NOT NULL auto_increment,
    dbase varchar(128) NOT NULL default '',
    user varchar(128) NOT NULL default '',
    label varchar(128) NOT NULL default '',
    query text NOT NULL,
    PRIMARY KEY (id)
    ) TYPE=MyISAM;
    # Dumping data for table `php4u_bookmarks`
    # --------------------------------------------------------
    Last edited by XGoDxIcEX; Thu 17 Jun '04, 10:34am.

  • #2
    Do you already have vbBulletin installed?


    • #3
      yes, i saw another thread that talked about there being a typo is the ImpExDatabase file, but i checked, and mine doesn't have the typo...


      • #4
        Did you restore the database.sql file from your old host to a fresh database on the new server?


        • #5
          i saved the database.sql file from my old host, and i put it on a fresh database on my new server called phpbb_old


          • #6
            just to let you know i got it... just had to put in the DELETE FROM datastore WHERE title='ImpExSession' query before starting again and also putting in the prefix for the tables


            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.