vb.org Archive

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

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

- - Help (https://vborg.vbsupport.ru/showthread.php?t=135572)

Mr.Dosa

01-04-2007 11:16 PM

Help

this mysql error

Code:

Invalid SQL:



                SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost &gt; 1167958688 AND open &lt;&gt; 10, 1, 0)) AS newthread

                

                FROM thread AS thread

                

                

                WHERE forumid = 36

                        AND sticky = 0

                         AND visible = 1 

                        AND postuserid NOT IN (213.6.152.159);

what i should do to solve this proplem

Still waiting

Mr.Dosa

01-06-2007 12:36 PM

my board is closed please help me

peterska2

01-06-2007 01:48 PM

This sounds like it is linked to a plugin which you have installed.

Disable the plugin system by editing config.php and adding this line right under <?php

Code:

define('DISABLE_HOOKS', true);

Now, check to see if it is working.

If it is working, disable all plugins and products in the admincp, remove the line from config.php and then enable one product/plugin at a time testing between each one until you find the problem.

If it is not working even when you have added the line into config.php and you have applied any file edits, then you should upload a clean set of files overwriting your current set (if in doubt back up your files from your server and do this anyway).

If all else fails, and plugins are disabled, and no file edits are present, then you will probably be best off submitting a support ticket via your Members Area

Mr.Dosa

01-06-2007 08:20 PM

i do that before write this thread here and the proplem still appeare

Note : when i log in as admin the board work whithout proplems but when members or guests log in this error appeare

i upgrade form 3.5.4 to 3.6.4 to avoid this proplem but nothing happened and the error is still appearing

All times are GMT. The time now is 09:24 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01041 seconds Memory Usage 1,717KB 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_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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: