PDA

View Full Version : Help | Error Number : 1064


mtirca
09-05-2013, 06:05 PM
Hello,
Today I deleted a number of topics from the database through the forum of course and I suddenly felt Error
http://puu.sh/4jQr9.png


Database Error Database error
The Onone.co.il database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.xdx.co.il home page, then try to open another page.
Click the Back button to try another link.
The www.onone.co.il forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 4.2.1:

Invalid SQL:
SELECT COUNT(DISTINCT post.userid) as count FROM post AS post WHERE post.threadid = AND post.visible = 1 AND post.userid !=;

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 post.visible = 1 AND post.userid !=' at line 1
Error Number : 1064
Request Date : Thursday, September 5th 2013 @ 07:05:25 PM
Error Date : Thursday, September 5th 2013 @ 07:05:25 PM
Script : http://www.xdx.co.il/
Referrer :
IP Address : XXXX
Username : XDX
Classname : vB_Database
MySQL Version : 5.5.31



What do you do in this situation? How to fix it is very urgent for me Member No. 1 and is my user
Quick reply'd love huge thank helpers

Upgrade and it still did not help, what to do?!
Version is: 4.2.1

kh99
09-05-2013, 06:33 PM
Try temporarily disabling plugins by editing your config.php file and adding this:
define('DISABLE_HOOKS', true);

At the top just under the <?php line. Or you could try disabling mods one at a time to see if one is causing the error.

mtirca
09-05-2013, 06:48 PM
thx my brother !!!!!!!!!! <3 you!

--------------- Added 1378411438 at 1378411438 ---------------

Hey,
You told me to add the following code, and will get the error:
define ('DISABLE_HOOKS', true);

This fixed the error, but it neutralized thank me two important
There is an alternative code that would ruin my darlings??? I will be happy to answer,
Thank you!

Lynne
09-05-2013, 07:25 PM
You need to now disable all your products and plugins (Manage Products page AND Plugin Manager page) and then remove that line that Kevin had you add. Now turn your products back on one-by-one to see which one is causing the error.

mtirca
09-05-2013, 07:27 PM
Hello,
These products do not cause or caused the error, the error created forum topics once I deleted it so I made ​​an error on my user only, regardless of the syllabus, admit Husfko to work as soon as I put the code that: kh99 brought me,
Heiit happy to get a different answer on the error,

Thank you. Thanks for the quick response

--------------- Added 1378413219 at 1378413219 ---------------

You're right man,
Maude was a very specific warnings about any topic or anything that react on this my warning and that's what knocked me everything