PDA

View Full Version : One of my many errors - vb2 > vb3



John Diver
Tue 13th Jul '04, 9:47am
Hey,
Attempting to convert vb2 to vb3 but really not going well.
Getting a lot of errors, can't get past this on though:

Database error in vBulletin:ImpEx Target 3.0.1:

Invalid SQL:
UPDATE vb3_forum
SET parentid=, parentlist=',,-1'
WHERE forumid =4
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 ' parentlist=',,-1'
WHERE forumid =4' at line 2

mysql error number: 1064

Getting the same thing for forumid 8
Thanks
John

Steve Machol
Tue 13th Jul '04, 2:56pm
The import script works for vB3-to-vB3, not vB2-to-vB3:

http://www.vbulletin.com/forum/showpost.php?p=676968&postcount=13

John Diver
Tue 13th Jul '04, 3:06pm
How come it has the option vb2 in the drop-down list?
How do I convert to vb3 from vb2 if the script isn't the way to do it?

Thanks
John

Steve Machol
Tue 13th Jul '04, 3:10pm
Ahhh....the vB2 import script is 'released in beta':

http://www.vbulletin.com/forum/showthread.php?t=102412

Perhaps there are still some bugs that need to be worked out.

John Diver
Tue 13th Jul '04, 3:16pm
Cheers Steve,
Can you tell me how I upgrade from vb2 to vb3 please?
I upgraded my other forum from invision straight to vb when I bought the license, but have had a license for www.HostingRefuge.com for a while now, was working with vb3 offline before I was going to upgrade the live forum.

SP upgraded and they don't seem to have any problems, although they are on a beta of 3.0 still.

Steve Machol
Tue 13th Jul '04, 4:24pm
http://www.vbulletin.com/docs/html/upgrade