vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   vB database error (https://vborg.vbsupport.ru/showthread.php?t=105185)

sniper0 01-13-2006 12:48 AM
vB database error
 
I've been getting a lot of DB errors on my vB bored in the past day and a half. The last hack I installed was the hide hack, so I think it mgiht be from that, but heres the error. Any help possible to fix it is much appreciated.

Quote:
Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount


,post.pagetext
FROM thread AS thread






WHERE thread.threadid IN (0,1947,1946,1342,1945,1944,1943,951,1230,1896,176 7,1937,1933,1922,1691,1894,1667,1895,1063,1600,175 9,41,1930,750)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Date : Thursday, January 12th 2006 @ 08:05:26 PM
Script : http://www.********.***/forumdisplay.php?f=3
Referrer : http://www.********.***/forumdisplay.php?f=3
IP Address : **.**.**.**
Username : Unregistered
Classname : vb_database

peterska2 01-13-2006 12:54 AM
try uninstalling the hide hack and see what happens. if it clears up then reinstall the hack but be careful about following every step in sequence.


All times are GMT. The time now is 11:45 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.01705 seconds
  • Memory Usage 1,712KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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