Thread: DB errors?
View Single Post
  #8  
Old 12-29-2008, 01:18 PM
KiLLWiT KiLLWiT is offline
 
Join Date: May 2008
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
I would guess this is from a modification since default vbulletin doesn't have a sql query that simply says "update". Try disabling your plugins as I suggested above and see if the error goes away.

As for the second one you posted, when you see that page, you need to then view the page source and near the bottom of the page source will be something that looks like your first snippet of code in the post above - that is the mysql error. See if it is different than the one you posted.
I tried disabling the plugins, but the sometimes I get an Internal Server error.
For the second error, this is the code in between comments:
Code:
<!--
Database error in vBulletin 3.7.4:

Invalid SQL:

			SELECT post.postid
			FROM post AS post
			
			WHERE post.threadid = 32
				AND post.visible = 1
				
				
			ORDER BY post.dateline 
			LIMIT -0, 10;

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 '-0, 10' at line 9
Error Number  : 1064
Request Date  : Monday, December 29th 2008 @ 10:14:41 AM
Error Date    : Monday, December 29th 2008 @ 10:14:41 AM
Script        : -removed-/showthread.php?p=123
Referrer      : -removed-/index.php
IP Address    : -removed-
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 
-->
Quote:
Originally Posted by Marco van Herwaarden View Post
Please provide an URL to the board so we can see the problem.
I will. I am not on for long, so the next time I login, I will provide the URL. sorry.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03601 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete