Import Usergroup Error

[Gray Matter]

I get this error when I run the "Import usergroup" module. I am importing from 3.5.2 (vBulletin) to 3.5.2 (vBulletin).


ImpEx Database errormysql error: 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',
'725007',
'0',
'49',
'0',
'0',
'50331715',
'8',
'0',
'0',
'0',
'2000',
'100',
'100',
'100000'
)

mysql error: Unknown column 'pmforwardmax' in 'field list'
mysql error number: 1054
Date: Thursday 15th of December 2005 05:20:39 PM

Can anyone help? Thanks. :)

[Steve Machol]

Are either one of these dbs using a table prefix? If not you are missing a key field that should be present in vB 3.5.2.

[Gray Matter]

No, none of them have table prefixes.

If there is a crucial field missing, how do I fix it?

Edited: Actually, it says that the error is because of a "pmforwardmax" option or something, and I think that was a vB2 feature or hack. I ugpraded the board (the source board) to vB 3.5 before I tried to import. How can I safely remove all vB2 tables from the database?

[Steve Machol]

It sounds like a bad upgrade. Try running this query to add that field:

ALTER TABLE usergroup ADD pmforwardmax SMALLINT UNSIGNED NOT NULL DEFAULT '5'

[Gray Matter]

I still get the same error. I think the problem is that the field is there and it's not supposed to be. Because, in vB3, the field is "pm send max" not "pm forward max."

[Steve Machol]

Yes, that field is supposed to be there. I checked first prior to providing that query.

[Gray Matter]

Hm... well the query didn't help anything. What should I do?

I ran it through the "Run SQL Query" feature from the Admin CP. Should I try to run it manually with PhpMyAdmin, or does that make no difference?

[Steve Machol]

Are you getting the exact same error? If so, this means you did not run this query correctly.

[Gray Matter]

I'm pretty sure I did it right the first time. :(

This is the error I get when I try to run the query again:


An error occurred while attempting to execute your query. The following information was returned.
error number: 1060
error desc: Duplicate column name 'pmforwardmax'

[Steve Machol]

Then you should no longer get the exact same error you were getting before.

[Gray Matter]

Here is the exact error I just got when I tried to run the usergroup module:


ImpEx Database errormysql error: 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',
'5',
'',
'',
'0',
'0',
'725007',
'0',
'49',
'0',
'0',
'50331715',
'8',
'0',
'0',
'0',
'2000',
'100',
'100',
'100000'
)

mysql error: Unknown column 'pmforwardmax' in 'field list'
mysql error number: 1054
Date: Saturday 17th of December 2005 10:07:16 AM

[Steve Machol]

To troubleshoot this, remove any hacks and disable your plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

If you still have this problem after that, fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.