Hi folks,
I'm currently attempting to merge an old db with my testvb copy of my live board. The old board was running vB2.x so I upgraded to vB3.0.1 with only 1 glitch (the settings had a problem but as far as I'm aware they're not important when I'm only interested in members, threads and forums).
Upon importing the newly updated old db I reached the user group stage and was hit with this error:
So I find myself editting ImpExDatabase.php to change "pmforwardmax" to "maxforwardpm" and match my testvb database.
Another thing I've noticed (after I updated the counters, didn't check this before hand) is that the attachment thumbnails aren't appearing for the old posts. Any idea why this might be?
Also, the associated members lost their current avatars and their join dates were left with the more recent values, is there any way I can have them keep their more recent avatars but use their join date from the old database?
Any help would be greatly appreciated.
Cheers,
Robert
I'm currently attempting to merge an old db with my testvb copy of my live board. The old board was running vB2.x so I upgraded to vB3.0.1 with only 1 glitch (the settings had a problem but as far as I'm aware they're not important when I'm only interested in members, threads and forums).
Upon importing the newly updated old db I reached the user group stage and was hit with this error:
Code:
Database error in vBulletin:ImpEx Target 3.0.1: Invalid SQL: INSERT INTO usergroup ( importusergroupid, title, description, usertitle, passwordexpires, passwordhistory, pmquota, pmsendmax, pmforwardmax, opentag, closetag, canoverride, ispublicgroup, forumpermissions, pmpermissions, calendarpermissions, wolpermissions, adminpermissions, genericpermissions, genericoptions, attachlimit, avatarmaxwidth, avatarmaxheight, avatarmaxsize, profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize ) VALUES ( '1', 'Unregistered / Not Logged In', '', 'Guest', '0', '0', '0', '0', '', '', '', '0', '0', '3', '0', '17', '0', '0', '64', '8', '0', '75', '75', '6000', '100', '100', '100000' ) mysql error: Unknown column 'pmforwardmax' in 'field list' mysql error number: 1054 Date: Saturday 29th of May 2004 03:01:03 PM Script: [url="http://www.domain.com/testvb/impex/index.php"]http://www.domain.com/testvb/impex/index.php[/url] Referer: [url="http://www.domain.com/testvb/admincp/index.php?do=nav"]http://www.domain.com/testvb/admincp/index.php?do=nav[/url] Username: 662C IP Address: x.x.x.x
Another thing I've noticed (after I updated the counters, didn't check this before hand) is that the attachment thumbnails aren't appearing for the old posts. Any idea why this might be?
Also, the associated members lost their current avatars and their join dates were left with the more recent values, is there any way I can have them keep their more recent avatars but use their join date from the old database?
Any help would be greatly appreciated.
Cheers,
Robert
Comment