vb.org Archive - weired DB errors.

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - weired DB errors. (https://vborg.vbsupport.ru/showthread.php?t=53418)

Jacko

05-26-2003 08:39 PM

weired DB errors.

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

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

05-26-2003 10:27 PM

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

Jacko

05-26-2003 10:43 PM

and how do i do this??

Jacko

05-26-2003 10:55 PM

i deleted "usergroupid," from the register.php

will this be ok??

filburt1

05-26-2003 10:58 PM

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

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

Jacko

05-27-2003 06:04 AM

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

05-27-2003 09:50 AM

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

Jacko

05-27-2003 05:41 PM

yes it was since i updated it.

i also get this error now:

Quote:

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

05-27-2003 06:44 PM

yes, obviously an error while upgrading.

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

All times are GMT. The time now is 06:37 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01137 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: