Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 04-24-2003, 03:52 PM
Jacko's Avatar
Jacko Jacko is offline
 
Join Date: Mar 2002
Location: UK
Posts: 173
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default mysql errors..?!

i get this on any page:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/realmods/public_html/forum/admin/db_mysql.php on line 86


=+=+=+=+=+=+=+=+

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Thursday 24th of April 2003 12:48:40 PM
Script: http://www.realmods.net/forum/forum/
Referer:

=+=+=+=+=+=+=+=+

havnt changed anything for about 24 hours and its been working all day??

any ideas??

i have checked my Db and all seems fine and file permissions are ok.
Reply With Quote
  #2  
Old 04-25-2003, 07:18 AM
Jacko's Avatar
Jacko Jacko is offline
 
Join Date: Mar 2002
Location: UK
Posts: 173
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

anyone?? i dont want to resort to a backup as i havnt done one for about 2/3 weeks.
Reply With Quote
  #3  
Old 04-25-2003, 07:19 AM
Jacko's Avatar
Jacko Jacko is offline
 
Join Date: Mar 2002
Location: UK
Posts: 173
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

now i just get:

There seems to have been a slight problem with the RealMods.net database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
Reply With Quote
  #4  
Old 04-25-2003, 07:23 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your user table is corrupted. Repair it via phpmyadmin or upload repair.php from the uploads directory of the vB zip file, and run it.
Reply With Quote
  #5  
Old 04-25-2003, 07:24 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Also, in future, backup at least daily.
Reply With Quote
  #6  
Old 04-25-2003, 07:35 AM
Jacko's Avatar
Jacko Jacko is offline
 
Join Date: Mar 2002
Location: UK
Posts: 173
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i noticed the user tabe said:

user l Browse l Select l Insert l Properties l Drop l Empty l in use

thought in use doesnt sound right.!

whats the best way to backup the db??

and where does the repair.php file get uploaded to??
Reply With Quote
  #7  
Old 04-25-2003, 07:49 AM
Jacko's Avatar
Jacko Jacko is offline
 
Join Date: Mar 2002
Location: UK
Posts: 173
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

everytime i try to run the repair script it gives me:

There seems to have been a slight problem with the RealMods.net database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

this is from both forum directory and admin folder.?!
Reply With Quote
  #8  
Old 04-25-2003, 07:53 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Run this query:

REPAIR TABLE user;
Reply With Quote
  #9  
Old 04-25-2003, 07:59 AM
Jacko's Avatar
Jacko Jacko is offline
 
Join Date: Mar 2002
Location: UK
Posts: 173
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Erwin you da man

what could of caused this error and whats the easiest way to backup my DB??
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:18 PM.


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.04116 seconds
  • Memory Usage 2,234KB
  • 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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)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