weired DB errors.

i get the following error when trying to email a user there activation code:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT user.userid,usergroupid,username,email,password,activationid,dateline FROM user LEFT JOIN useractivation ON (user.userid=useractivation.userid AND type=0) WHERE email='wizkid_817@hotmail.com'
mysql error: Column: 'usergroupid' in field list is ambiguous

mysql error number: 1052

Date: Monday 26th of May 2003 05:39:18 PM
Script: http://www.realmods.net/forum/register.php
Referer: 
Repair Report: This type of error cannot be automatically repaired.

any ideas??

[filburt1]

Two or more of the tables you referenced contain a usergroupid column, so you need to explicitly pick one.

[Jacko]

and how do i do this??

[Jacko]

i deleted "usergroupid," from the register.php

will this be ok??

[filburt1]

It'll stop the error, but that's like:

Patient: It hurts when I do this.
Doctor: Then don't do that.

[Jacko]

we will see than how things run..

p.s could you possibly sign up for my forum filburt and test it all works ok??? as i am not sure it is emailing you the activation code or not?

[Xenon]

seems yor upgrade to vb230 wasn't successful, afaik, there is no usergroupid field in useractivation anymore? (or have they added it?)

[Jacko]

yes it was since i updated it.

i also get this error now:

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO useractivation VALUES (NULL,'200','1054037722','65018822',1)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Tuesday 27th of May 2003 08:15:22 AM
Script: http://www.realmods.net/forum/forum/member.php
Referer: http://www.realmods.net/forum/member.php?action=lostpw
Repair Report: This type of error cannot be automatically repaired.

i have a feeling these are related.

[Xenon]

yes, obviously an error while upgrading.

you should redo the upgrade and be really carefull where you make changes because of hacks