vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   vbulletin error when viewing a thread.. (https://vborg.vbsupport.ru/showthread.php?t=233581)

final kaoss 01-19-2010 11:14 PM
vbulletin error when viewing a thread..
 
Ok so when I goto view a thread it starts giving me this on random threads..

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

                SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid,
                        thread.lastpost, thread.replycount,
                        forum.title AS forumtitle
                        ,post.pagetext AS preview
                       
                       
                FROM thread AS thread
                INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
                LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
               
               
               
                WHERE thread.threadid IN (15168, 4538, 350, 7330, 4068, 3470, 6003, 20954, 2668, ) AND thread.visible = 1
                       
                       
                       
                ORDER BY lastpost DESC;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND thread.visible = 1
                       
                       
                       
                ORDER BY lastpost DESC' at line 13
Error Number  : 1064
Request Date  : Tuesday, January 19th 2010 @ 08:12:13 PM
Error Date    : Tuesday, January 19th 2010 @ 08:12:13 PM
Script        : http://vgchat.info/forum/showthread.php?t=21031
Referrer      : http://vgchat.info/forum/forumdisplay.php?f=6
IP Address    : -----------------------
Username      : ---------------------
Classname    : vB_Database
MySQL Version : 5.0.87-percona-highperf
What does it mean & how do I fix it?

Lynne 01-19-2010 11:45 PM
Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:
define('DISABLE_HOOKS', true); 

final kaoss 01-19-2010 11:50 PM
Yep the error is still there after that. What I believe this error means is that somewhere some entries in a table got corrupted unreadable or whatever. I've checked, repaired, optimized and analyzed every last one of them in phpmyadmin but still some threads choose to do this (not all of them thank god)


All times are GMT. The time now is 06:24 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.01869 seconds
  • Memory Usage 1,714KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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