Having a 1064 Error....

[XGoDxIcEX]

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

[XGoDxIcEX]

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

[Zachery]

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

[XGoDxIcEX]

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...

[Zachery]

Do you already have vbBulletin installed?

[XGoDxIcEX]

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
Script: http://24.131.150.254/board/impex/index.php
Referer: http://24.131.150.254/board/admincp/index.php?do=nav
Username: XGoDxIcEX
IP Address: 192.168.1.1

can anyone help? ...

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

# phpMyAdmin MySQL-Dump
# version 2.2.1-dev
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: members-free-php11.uk.db.lyceu.net:3309
# 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`
#
# --------------------------------------------------------