Not sure where to put this...

[Mr_Johnson]

I am getting this error emailed to me when members register they get an error:

Database error in vBulletin 2.2.9:

Invalid SQL:
INSERT INTO useractivation
(useractivationid, userid, dateline, activationid, type, usergroupid)
VALUES
(NULL, 206, 1054027775, '87506585', 1, 3)

mysql error: Unknown column 'usergroupid' in 'field list'

mysql error number: 1054

Date: Tuesday 27th of May 2003 03:29:35 AM
Script: http://www.sjiradio.com/forum//forum/member.php
Referer: http://www.sjiradio.com/forum/member.php?s=&action=lostpw


I installed a few mods and didn't notice it until after, any ideas?

[Xenon]

looks like a bad upgrade.

upgrade your board to vb2.3.0 and be sure you don't override new code in register.php

[Mr_Johnson]

Now I moved the forum from where it was originally installed when I upgraded (moved from forum.sjiradio.com to sjiradio.com/forum), not sure if that changes anything. The database was still at the same location. Will upgrading over write more mods? :(

[Sebastian]

unfortunately yes,.. overwrite all the mods you installed by replacing all the files with new fresh un-hacked files.. then run the upgrade 2.3.0 script.

[Mr_Johnson]

:(Thats going to be a PITA, I guess I have a new project for this weekend :-/

[Xenon]

you know TECK's thread about 30 minutes upgrades without losing hacks in hacking hints and tips ;)

have a succesful weekend :)