Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
Reload this Page Help! Weirdest error...
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Help! Weirdest error... Details »»
Help! Weirdest error...
Version: , by Chris M Chris M is offline
Developer Last Online: Feb 2013 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 02-18-2003 Last Update: Never Installs: 0
 
No support by the author.

Code:
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT quote,name FROM quotes ORDER BY rand() LIMIT 1
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Tuesday 18th of February 2003 12:56:23 AM
Script: http://www.darkblazes.com/forums/forums/index.php?
Referer: http://www.darkblazes.com/forums/adm...hp?action=head
I get that when trying to access my forums

Can you help?

Satan

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 02-18-2003, 09:11 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Looks like your quotes table is messed up. Have you tried to repair it?
Reply With Quote
  #3  
Old 02-18-2003, 09:26 AM
Chris M's Avatar
Chris M Chris M is offline
 
Join Date: Dec 2001
Location: Northampton, England
Posts: 6,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
No I havent

Good idea...

Just one problem - I can't access PhpMyAdmin, or my email, so that suggests to me that it isn't a problem with the quotes table itself, but the server...The quotes table just happens to be the first thing it tries to call...

Maybe i'm wrong

Satan
Reply With Quote
  #4  
Old 02-18-2003, 09:31 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by hellsatan
No I haven't

Good idea...

Just one problem - I can't access PhpMyAdmin, or my email, so that suggests to me that it isn't a problem with the quotes table itself, but the server...The quotes table just happens to be the first thing it tries to call...

Maybe i'm wrong

Satan
Can you access FTP though? You can always disable the quotes in index.php and see if that helps at all.
Reply With Quote
  #5  
Old 02-18-2003, 09:32 AM
Chris M's Avatar
Chris M Chris M is offline
 
Join Date: Dec 2001
Location: Northampton, England
Posts: 6,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
As I suspected - All the Tables are reported to be "OK" by the repair.php file...

Satan
Reply With Quote
  #6  
Old 02-18-2003, 09:36 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by hellsatan
As I suspected - All the Tables are reported to be "OK" by the repair.php file...

Satan
Sounds like you hit the nail on the head. Must be server problems then.

By the way, use rand(NOW()) instead of rand() when you get back online. It seeds the randomization better with sql .54 and better.
Reply With Quote
  #7  
Old 02-18-2003, 09:38 AM
Chris M's Avatar
Chris M Chris M is offline
 
Join Date: Dec 2001
Location: Northampton, England
Posts: 6,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
@Boofo - I tried removing the quote stuff from global.php...

I ended up removing the $DB_site error, but I still get:

Code:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/forums/admin/db_mysql.php on line 149
When I goto the Admin CP...

I think there must be a server error

Satan
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 12:00 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.04412 seconds
  • Memory Usage 2,259KB
  • Queries Executed 22 (?)
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
  • (2)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (6)postbit
  • (7)postbit_onlinestatus
  • (7)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete