Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page execute SQL bug?
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 1 of 3 1 23
 
Thread Tools Display Modes
  #1  
Old 02-22-2009, 03:15 PM
fodboldforumdk fodboldforumdk is offline
 
Join Date: Mar 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default execute SQL bug?
Hi,
I have a problem when i try to "Execute SQL Query"

Its for my "vbookie" mod were i need to reset the cash for my users.

I enter: UPDATE user SET vbookie_cash=500 and press excecute

The outcome says:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'fodboldforum_dk.user' doesn't exist
I really dont know how to fix this or even understand what it mean.

Anyone ?
Reply With Quote
  #2  
Old 02-22-2009, 03:40 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
You probably have a table prefix and you need to add that in front of "user" in the query.

You should be asking questions regarding modifications in the modification thread.
Reply With Quote
  #3  
Old 02-22-2009, 04:29 PM
fodboldforumdk fodboldforumdk is offline
 
Join Date: Mar 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
yes, i tried to vb3_user
And the outcome was: Affected Rows: 16 (0.0263s)

So i guess the excetuting was done right?
Reply With Quote
  #4  
Old 02-22-2009, 05:04 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I would guess so, if there were affected rows. If you are able to view the database, you could always check. Or, you'll find out when you try to use the mod whether or not you did it correctly.
Reply With Quote
  #5  
Old 02-23-2009, 04:48 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by fodboldforumdk View Post
So i guess the excetuting was done right?
If the affected rows count is more than 0, then it should be OK. You can verify this by looking at the table through phpMyAdmin, etc.
Reply With Quote
  #6  
Old 02-23-2009, 12:49 PM
fodboldforumdk fodboldforumdk is offline
 
Join Date: Mar 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
16 rows was affected i think it said... but now i got problems with the DB.. but it dont say what type of errors.. just "Database error" 2 out of 3 trys to enter site i get that anoying error.

Are there a way i can do something about this? - can i re-update the software VB ?
Reply With Quote
  #7  
Old 02-23-2009, 12:59 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
View the page source to get the full SQL error.
Reply With Quote
  #8  
Old 02-23-2009, 01:38 PM
fodboldforumdk fodboldforumdk is offline
 
Join Date: Mar 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
how can i do this?
Reply With Quote
  #9  
Old 02-23-2009, 01:43 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Rogt click on the error page and select View Source.
Reply With Quote
  #10  
Old 02-23-2009, 02:50 PM
fodboldforumdk fodboldforumdk is offline
 
Join Date: Mar 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
okay,
here is the error.. can anyone se whats wrong?

Quote:
Database error in vBulletin :

mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: User fodboldforum_dk already has more than 'max_user_connections' active connections
/customers/fodboldforum.dk/fodboldforum.dk/httpd.www/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Monday, February 23rd 2009 @ 05:49:15 PM
Error Date : Monday, February 23rd 2009 @ 05:49:15 PM
Script : http://www.fodboldforum.dk/forumdisplay.php?f=0
Referrer : http://www.fodboldforum.dk/
IP Address : 79.138.255.77
Username :
Classname : vb_database
MySQL Version :
Reply With Quote
Reply
Page 1 of 3 1 23

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

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 09:29 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04422 seconds
  • Memory Usage 2,241KB
  • Queries Executed 13 (?)
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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete