PDA

View Full Version : vb2 to vb3 error



Gizmo99
Tue 27th Jul '04, 3:46pm
Eho team

Doing this on test box ;)

right run the descriptence test (php thingy) no database or table prob on our vbb2.

Imported users

got upset @ email address like stephen.o'hara@home.com so it dont like ' in email. had 6 user like that

Now it started to do post import and ...

Database error in vBulletin:ImpEx Source 3.0.3:
Invalid SQL: SELECT * FROM thread ORDER BY threadid LIMIT ,2000
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 '2000' at line 1
mysql error number: 1064
Date: Tuesday 27th of July 2004 07:34:53 PM
Script: http://192.168.2.1/rsocbb3/impex/index.php
Referer: http://192.168.2.1/rsocbb3/admincp/index.php?do=nav

Help :cool:

Gizmo99
Tue 27th Jul '04, 11:44pm
Found fix !!! :)

run these queries on your vb2 DB

This one will find and email addresses with ' in

SELECT `attachmentid` , `userid` , `dateline` , `filename` , `filedata` , `visible` , `counter`
FROM `attachment`
WHERE 1 AND `filename`
LIKE '%\'%' LIMIT 0 , 30

This one will check attachment file names, to see if you have ' in those

SELECT `userid` , `usergroupid` , `username` , `password` , `email` , `styleid` , `parentemail` , `coppauser` , `homepage` , `icq` , `aim` , `yahoo` , `signature` , `adminemail` , `showemail` , `invisible` , `usertitle` , `customtitle` , `joindate` , `cookieuser` , `daysprune` , `lastvisit` , `lastactivity` , `lastpost` , `posts` , `timezoneoffset` , `emailnotification` , `buddylist` , `ignorelist` , `pmfolders` , `receivepm` , `emailonpm` , `pmpopup` , `avatarid` , `options` , `birthday` , `maxposts` , `startofweek` , `ipaddress` , `referrerid` , `nosessionhash` , `inforum` , `importuserid` , `isnew` , `chatbox`
FROM `user`
WHERE 1 AND `email`
LIKE '%\'%' LIMIT 0 , 30

This will show filenames with \' in them also. if the filenames have \' that is ok. IF NOT change the file name from ' to \' sorted !!!

as for the users email @ mo just deleted users, as i belive ' in email address is illegal :)

NOW THE IMPORTER WORK LIKE A CHARM :)

Thank chirst for trying this upgrade offline first :)

Time saved loads :)

Giz

Giz