vb.org Archive - DB errors?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - DB errors? (https://vborg.vbsupport.ru/showthread.php?t=199716)

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)

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);

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

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.

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

Code:

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

Code:

         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.

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.

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

Quote:

Originally Posted by Lynne (Post 1695909)

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 (Post 1696240)

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.

X vBulletin 3.8.12 by vBS Debug 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 (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01107 seconds Memory Usage 1,737KB 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 (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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
Messages: