vb.org Archive

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.

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.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