Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 06-30-2003, 03:41 AM
NAIF NAIF is offline
 
Join Date: Aug 2002
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default mysql error number : 1054 , I really NeEd Help

Hello ,
since i upgraded my bB forum from vB 2.2.8 to vB2.3.0, i have faced a problem that when i user lose a password and tries to use the lost apssword action, after he insert his email he gets a database error mesage( error is attached) ...I wish you can help me solve this problem>

--------------------------------------------------
Database error in vBulletin 2.3.0:

Invalid SQL:
INSERT INTO useractivation
(useractivationid, userid, dateline, activationid, type, usergroupid)
VALUES
(NULL, 53941377, 1056947111, '97957961', 1, 80)

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

mysql error number: 1054

Date: Monday 30th of June 2003 07:25:11 AM
Script: http://www.abdu.net/vb/vb/member.php
Referer: http://www.abdu.net/vb/member.php?action=lostpw
-----------------------------------------

thank you
Reply With Quote
  #2  
Old 06-30-2003, 03:49 AM
Cloudrunner's Avatar
Cloudrunner Cloudrunner is offline
 
Join Date: May 2003
Location: Butte, MT
Posts: 635
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, it looks as tho during your upgrade you lost the column 'usergroupid' in the table 'useractivation'.

double check for this column in the useractivation table, if it's not there then run this query:

Code:
ALTER TABLE `useractivation` ADD `usergroupid` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
Reply With Quote
  #3  
Old 06-30-2003, 12:47 PM
NAIF NAIF is offline
 
Join Date: Aug 2002
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thank you very very much Cloudrunner
It's Ok now It's working ,,

NAIF
Reply With Quote
  #4  
Old 09-06-2003, 09:50 PM
lasto lasto is offline
 
Join Date: Jan 2002
Posts: 1,514
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i just had this as well

i ran the fix above said sql query ran ok so hopes thats end of matter

Invalid SQL:
INSERT INTO useractivation
(useractivationid, userid, dateline, activationid, type, usergroupid)
VALUES
(NULL, 75, 1062886818, '20948814', 1, 10)

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

mysql error number: 1054
Reply With Quote
  #5  
Old 10-15-2003, 07:43 AM
mariannet's Avatar
mariannet mariannet is offline
 
Join Date: Mar 2003
Location: Denmark
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here we go again!

Having installed a user rating hack I have come across this problem:

*************************************

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1990-10-29',options='15',usergroupid='8',username='xxxx',e mail='xxxx@xxxx.dk',styleid='8',parentemail='',cop pauser=0,homepage='http://www.xxxx.tk',icq='',aim='',yahoo='',signature='Tje ck>>>> www.xxxx.tk

Get hvem der har f?s?dag d 29. oktober...
x055

Msn: xxxx@ofir.dk',adminemail=1,showemail=1,invisible=0,usertitle=' Lovely girl...',customtitle=2,joindate=UNIX_TIMESTAMP('20 03-04-24 19:19:55'),cookieuser=1,nosessionhash=1,daysprune= '1000',lastvisit=UNIX_TIMESTAMP('2003-10-14 20:48:26'),lastactivity=UNIX_TIMESTAMP('2003-10-14 22:25:58'),lastpost=UNIX_TIMESTAMP('2003-10-14 22:16:42'),userrating='',posts='1293',timezoneoffs et='+1',emailnotification=0,receivepm='1',emailonp m='0',ipaddress='80.62.119.214',pmpopup=IF(pmpopup =2 AND 1=1,pmpopup,'1') WHERE userid=358
mysql error: Unknown column 'userrating' in 'field list'

mysql error number: 1054

*************************************

I have a feeling where the problem is.

When I add a new user the field "User Rating" is present on the form, just under "Parent email address". I can add ok.

If I want to change the detailes of someone who is already a member, the field "User Rating" is NOT present on the form and when saving I get the error.

I don't really think that the problem is in mySQL, rather somewhere in the admin files, I just don't know where to start looking?
Attached Images
File Type: gif 01.gif (2.5 KB, 0 views)
File Type: gif 02.gif (2.6 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:30 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03637 seconds
  • Memory Usage 2,216KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (2)postbit_attachment
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete