Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 08-12-2008, 08:51 AM
newmasalaboard's Avatar
newmasalaboard newmasalaboard is offline
 
Join Date: Apr 2008
Location: Raipur [C.G.], INDIA
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error in PM's

Hello,

Actually whenever we open inbox or something related to private messaging the we are facing a DB error.Its says :

Code:
Database error in vBulletin 3.7.0:

Invalid SQL:

            SELECT pm.*, pmtext.*
                , icon.title AS icontitle, icon.iconpath
            FROM pm AS pm
            LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
            LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
            WHERE pm.userid=1 AND pm.folderid=0
            ORDER BY pmtext.dateline DESC
            LIMIT 0, 50;

MySQL Error   : Can't create/write to file '/tmp/#sql_c72_0.MYI' (Errcode: 30)
Error Number  : 1
Request Date  : Tuesday, August 12th 2008 @ 05:20:22 AM
Error Date    : Tuesday, August 12th 2008 @ 05:20:22 AM
Script        : http://www.newmasalaboard.info/private.php
Referrer      : http://www.newmasalaboard.info/private.php
IP Address    : XXXXXXXXX
Username      : XXXXXXXXX
Classname     : vB_Database
MySQL Version : 5.0.51a-community
Please help me to solve the problem !!
Reply With Quote
  #2  
Old 08-12-2008, 08:53 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Most likely your /tmp directory is full. Please contact your host to resolve this problem.

PS Sometimes a reboot of the server will solve this issue.
Reply With Quote
  #3  
Old 08-14-2008, 06:02 AM
newmasalaboard's Avatar
newmasalaboard newmasalaboard is offline
 
Join Date: Apr 2008
Location: Raipur [C.G.], INDIA
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Now the whole forum is giving database errors

Code:
Database error in vBulletin 3.7.0:

Invalid SQL:

        SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1218675414 AND open <> 10, 1, 0)) AS newthread
        
        FROM thread AS thread
        
        
        WHERE forumid = 2
            AND sticky = 0
            
             AND visible IN (0,1,2);

MySQL Error   : Table 'thread' is marked as crashed and should be repaired
Error Number  : 1194
Request Date  : Wednesday, August 13th 2008 @ 10:53:58 PM
Error Date    : Wednesday, August 13th 2008 @ 10:53:58 PM
Script        : http://www.newmasalaboard.info/forumdisplay.php?f=2
Referrer      : 
IP Address    : XXXXXXXXXXX
Username      : XXXXXXXXXX
Classname     : vB_Database
MySQL Version : 5.0.51a-community
Reply With Quote
  #4  
Old 08-14-2008, 06:07 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

AdminCP > Maintenance > Repair/Optimize table. Repair the "thread" table.

If you can't access the AdminCP, you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.
Reply With Quote
  #5  
Old 08-14-2008, 07:52 AM
newmasalaboard's Avatar
newmasalaboard newmasalaboard is offline
 
Join Date: Apr 2008
Location: Raipur [C.G.], INDIA
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I tried to repair but its giving following error even after repeating it couple of times
Attached Images
File Type: jpg error.jpg (56.2 KB, 0 views)
Reply With Quote
  #6  
Old 08-14-2008, 08:01 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please contact your host.
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 03:46 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.03795 seconds
  • Memory Usage 2,222KB
  • 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
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (1)postbit_attachment
  • (6)postbit_onlinestatus
  • (6)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