vb.org Archive - mysql error

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

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

- - mysql error (https://vborg.vbsupport.ru/showthread.php?t=316283)

CarpCharacin

12-29-2014 09:22 AM

mysql error

i tried to access my TOS announcement and it said there was a mysql error. I do not know what to do. Here is a link to it: http://dudetalk.info/announcement.php?f=5

ozzy47

12-29-2014 09:24 AM

You should have got a email with the actual error, we would need that info to see what the issue is.

If not check your server error logs, if you don't know where those are, ask your host.

CarpCharacin

12-29-2014 10:12 AM

Here is what it said: I blocked out my ip address.

Quote:

Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT userid
FROM post
WHERE threadid = AND userid = 1;
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 userid = 1' at line 3
Error Number : 1064
Request Date : Monday, December 29th 2014 @ 06:22:21 AM
Error Date : Monday, December 29th 2014 @ 06:22:22 AM
Script : http://dudetalk.info/announcement.php?f=5
Referrer : https://vborg.vbsupport.ru/showthread.php?p=2529368
IP Address : ***.**.***.***
Username : CarpCharacin
Classname : vB_Database
MySQL Version : 5.5.40-cll

ozzy47

12-29-2014 10:17 AM

Ok lets do this, disable plugins via the includes/config.php file.

To do that open your includes/config.php file and below <?php add the following.

PHP Code:


		
			
define('DISABLE_HOOKS', true);

So it looks like this:

PHP Code:


		
			
<?php
define('DISABLE_HOOKS', true);
/*=================================================  =====================*\
|| ##################################################  ################## ||
|| # vBulletin 4.2.2

Use a editor like notepad++ to edit any files, don't use Notepad or Wordpad.

If that fixes the issue enable plugins again by adding // before the line you added, then navigate to ACP --> Plugins & Products --> Manage Products and disable one mod at a time until you find the one causing the issue.

Once you find the culprit, post in that mods thread what the issue is, and maybe someone in that thread can help. :)

kh99	12-29-2014 10:27 AM

That's the query you were asking about, Ozzy, for your "moderate reported posts" mod, so if that's installed I'd start there.

ozzy47

12-29-2014 10:28 AM

I have a feeling it is that. But I don't know why, all the link is is to the announcement forum. :confused:

CarpCharacin

12-29-2014 11:06 AM

Quote:

Originally Posted by ozzy47 (Post 2529377)

I have a feeling it is that. But I don't know why, all the link is is to the announcement forum. :confused:

It was only showing the error when i clicked on my TOS announcement.

ozzy47

12-29-2014 11:11 AM

Yup, it's sorted now. I replied in the mod's thread. :)

All times are GMT. The time now is 10:05 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02181 seconds Memory Usage 1,730KB 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 (2)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: