PDA

View Full Version : SQL 'usergroupid' error ?

magnus
05-01-2003, 03:00 PM
Database error in vBulletin 2.3.0:

Invalid SQL:
INSERT INTO useractivation
(useractivationid, userid, dateline, activationid, type, usergroupid)
VALUES
(NULL, 42, 1051804230, '43651736', 1, 6)

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

mysql error number: 1054

This happens whenever someone attempts to retrieve their password. (ie. http://sitename/forum/member.php)

Any ideas? Thanks. :)
Xenon
05-01-2003, 03:22 PM
upload an unhacked member.php
magnus
05-01-2003, 04:24 PM
Today at 05:22 PM Xenon said this in Post #2 (https://vborg.vbsupport.ru/showthread.php?postid=389986#post389986)
upload an unhacked member.php

I've already tried that to no avail. :(
Xenon
05-01-2003, 04:50 PM
are you sure you have run upgrade23.php while upgrading?
magnus
05-01-2003, 05:02 PM
Today at 06:50 PM Xenon said this in Post #4 (https://vborg.vbsupport.ru/showthread.php?postid=390038#post390038)
are you sure you have run upgrade23.php while upgrading?

No. This is a fresh install, although I did import JUST the users db. Do I still need to run upgrade23.php?
Xenon
05-01-2003, 05:05 PM
hmm it can't hurt, so just run it ;)
magnus
05-01-2003, 05:15 PM
Today at 07:05 PM Xenon said this in Post #6 (https://vborg.vbsupport.ru/showthread.php?postid=390047#post390047)
hmm it can't hurt, so just run it ;)

That fixed it. :)

Although I am a bit concerned about the, "adding new templates" output.. I'm hoping it didn't overwrite any of my hacks.

Thanks!
Xenon
05-01-2003, 05:25 PM
it will just overwrite original templates, no custom or changed ones :)
magnus
05-01-2003, 05:28 PM
Hmm... it appears to have affected my warning system hack, I think I'll try uninstalling/reinstalling the hack. *shrug* :)