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
can anyone help? ...
line 3 of the backup of the database is somewhere around here...
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
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
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`
#
# --------------------------------------------------------
# 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`
#
# --------------------------------------------------------
Comment