DB errors?

[KiLLWiT]

whenever someone tries to view a thread as a guest, it gives a database error. any reasons as to why it does this + if possible, a fix? i've tried reinstalling, removing any mods that might cause it, but no go. thanks.

forgot to mention:
this only happens if you click the thread from forumhome as lastpost, but not if you click it directly (as guest)

[Lynne]

It would help to see the actual database error.

Try disabling your 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); 


[KiLLWiT]

um, it won't let me copy + paste error, freezes computer. edited first post.

[Lynne]

A database error on your server should not freeze your computer. In order to view a database error, you need to view the page source and then copy and paste it - is that when it is freezing? If the page itself is freezing, this sounds more like a browser issue. Try using a different browser.

[KiLLWiT]

I get a few now. I get this one in the admincp:

Database error in vBulletin 3.7.4:

Invalid SQL:


				UPDATE;

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 '' at line 1
Error Number  : 1064
Request Date  : Sunday, December 28th 2008 @ 08:06:13 PM
Error Date    : Sunday, December 28th 2008 @ 08:06:14 PM
Script        : -removed-/user.php?do=update
Referrer      : -removed-/user.php?do=edit&u=1
IP Address    : 78.145.163.44
Username      : n0x
Classname     : vB_Database
MySQL Version : 5.0.51a-community

and users get another one whilst viewing threads when they click on last post

 	Database error   	The EcKO Studios - The return... database has encountered a problem.   	

   	 		Please try the following: 		 			Load the page again by clicking the -removed-/showthread.php?p=118# button in your web browser. 			Open the -removed-/ home page, then try to open another page. 			Click the javascript:history.back(1) button to try another link. 		 	   	The -removed- forum technical staff have been notified of the error, though you may dbmaster@example.com if the problem persists.   	+
We apologise for any inconvenience.

[Lynne]

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.

[Marco van Herwaarden]

Please provide an URL to the board so we can see the problem.

[KiLLWiT]

Originally Posted by Lynne

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:

<!--
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 : 
-->

Originally Posted by Marco van Herwaarden

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.