PDA

View Full Version : MYSQL Database error..


rosebudtr
05-29-2011, 02:28 PM
Database error in vBulletin 4.1.3:

Invalid SQL:
();

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 ')' at line 1
Error Number : 1064
Request Date : Sunday, May 29th 2011 @ 06:29:51 PM
Error Date : Sunday, May 29th 2011 @ 06:29:51 PM
Script : http://www.dizilerimizden.com/usercp.php
Referrer : http://www.dizilerimizden.com/forum.php
IP Address : 88.228.178.164
Username : Seyyid
Classname : vB_Database
MySQL Version : 5.1.52-log

Lynne
05-29-2011, 02:34 PM
Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

rosebudtr
05-29-2011, 04:28 PM
Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
at.contenttypes
FROM attachment AS a
INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.posthash = '58e8667791fe06a8ecfc57a1d6393c26'
AND
a.userid IN (1)
AND
a.contenttypeid =

ORDER BY a.contentid, a.displayorder;

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 'ORDER BY a.contentid, a.displayorder' at line 15
Error Number : 1064
Request Date : Sunday, May 29th 2011 @ 08:36:30 PM
Error Date : Sunday, May 29th 2011 @ 08:36:30 PM
Script : http://dizilerimizden.com/newthread.php?do=newthread&f=228
Referrer : http://dizilerimizden.com/newthread.php?do=newthread&f=228
IP Address : 88.228.178.164
Username : Seyyid
Classname : vB_Database
MySQL Version : 5.1.52-log