Log in

View Full Version : Help


Mr.Dosa
01-04-2007, 11:16 PM
this mysql error


Invalid SQL:

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1167958688 AND open <> 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

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 (http://members.vbulletin.com)

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