vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Wierd Error (https://vborg.vbsupport.ru/showthread.php?t=82006)

Grant Sherwood 05-25-2005 06:27 AM
Wierd Error
 
Well my server went down and then when it came back up the board says this.



Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
  SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , pollvoteid
  FROM vb_thread AS thread
  INNER JOIN vb_poll AS poll USING (pollid)
  LEFT JOIN vb_pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 3)
  LEFT JOIN vb_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
  WHERE open <> 10 AND thread.pollid != 0 AND visible = 1 AND deletionlog.primaryid IS NULL  AND forumid IN(68) ORDER BY poll.pollid DESC
  LIMIT 1
 
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Wednesday 25th of May 2005 02:19:44 AM
Script: http://ntsr.org/forums/portal.php?
Referer:
Username: *****
IP Address: **.**.***.*










Any ideas on whats causing this??

Zero Tolerance 05-25-2005 08:41 AM
Corruption of some form, try repairing the table, if that doesn't work, tell your host :)

- Zero Tolerance

Grant Sherwood 05-25-2005 04:26 PM
Well now that i look my forum is working just my portal home page is the only place showing this error. I had my hoster look at the file limit size to see if anything was full but he said everything is mostly around 50% or less so its not that..any ideas??

BTW- the portal im using is vBa CMPS

in the admin CP when i try and look at the defualt settings it gives me this error:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
                        SELECT adv_setting.*
                        FROM vb_adv_setting AS adv_setting
                        LEFT JOIN vb_adv_settinggroup AS adv_settinggroup USING (grouptitle)
                        WHERE adv_settinggroup.grouptitle LIKE 'adv_portal%'
                        ORDER BY adv_settinggroup.displayorder, adv_setting.displayorder
       
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Wednesday 25th of May 2005 12:24:05 PM
Script: http://www.ntsr.org/forums/admincp/vba_cmps_admin.php?do=modifysettings
Referer: http://www.ntsr.org/forums/admincp/
Username: Fatal
IP Address: 69.69.192.2
i can go to edit modules and ++++ like that. everything seems to be working fine just the portal is giving me these errors.

This also comes up when i try and check my PM's:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
                        SELECT
                        thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
                       
                  ,thread.iconid AS threadiconid, iconpath AS threadiconpath
                  , avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
                 
                 
                        FROM vb_thread AS thread
                        LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
                  LEFT JOIN vb_icon USING (iconid)
                 
                        LEFT JOIN vb_user AS user ON (user.userid = post.userid)
                       
                       
                 
                                LEFT JOIN vb_avatar as avatar ON (avatar.avatarid = user.avatarid)
                                LEFT JOIN vb_customavatar as customavatar ON (customavatar.userid = user.userid)
                       
                 
                        LEFT JOIN vb_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
                        WHERE forumid IN(69) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
                        GROUP BY post.postid
                        ORDER BY  postdateline DESC
                        LIMIT 4
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Wednesday 25th of May 2005 12:21:21 PM
Script: http://ntsr.org/forums/portal.php?
Referer:
Username: Fatal
IP Address: 69.69.192.2

i ran the Repair/Optimize tables thing and everything came back either STATUS: OK or STATUS: Table is already up to date.

if i had 3 wishes onw would definatly be to know everything about computers and this stuff.

Zero Tolerance 05-25-2005 05:00 PM
Well then something is wrong, try to optimize/check/analyze the tables. More information: http://dev.mysql.com/doc/mysql/en/ta...intenance.html

- Zero Tolerance

Corriewf 05-25-2005 05:42 PM
Submit a trouble ticket to vbadvanced at vbadvanced.com ..... He is really prompt and knows his software well.

Marco van Herwaarden 05-25-2005 06:56 PM
Quote:
Originally Posted by corriewf
Submit a trouble ticket to vbadvanced at vbadvanced.com ..... He is really prompt and knows his software well.
Error: 28 means that a directory is full or wrong permissions.

You should immediate stop your database and contact your host about the diskspace problems.

Corriewf 05-25-2005 07:20 PM
Quote:
Originally Posted by MarcoH64
Error: 28 means that a directory is full or wrong permissions.

You should immediate stop your database and contact your host about the diskspace problems.
Yeah, but would that explain why its just the cmps. I ran out of disk space once and kept getting sql errors on the whole site when cron jobs tried to run.

Marco van Herwaarden 05-26-2005 04:54 AM
Yes it could be limited to 1 specific query. If a query is run for which MySQL decides it is better to use a temporary table to use for sorting for example and your tmp-directory don't have enough space to hold all the data for that specific query, then this could happen.

Make sure you have also enough free space in your tmp-directory and run a repair on all tables.

Grant Sherwood 05-26-2005 06:43 AM
well magically it all started work w/o ptoblems................yet.

KevinL 05-26-2005 03:05 PM
I got that first error when there was a backup being made of the entire database (when switching servers). The /tmp folder was full which is what was giving me the error.


All times are GMT. The time now is 01:46 PM.

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.01192 seconds
  • Memory Usage 1,742KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete