View Full Version : Can't post new thread in forum
doileloi
09-20-2011, 12:33 PM
Database error in vBulletin 4.1.5:
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
Classname : vB_Database
MySQL Version : 5.0.91
I try post newthread in forum get this error anyone know what wrong ? please help Thank you
Lynne
09-20-2011, 04:36 PM
What is the full error?
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);
doileloi
09-20-2011, 09:12 PM
Database error in vBulletin 4.1.5:
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 = 'f2e7d73e6c0f97d07b99e127b15f6e1f'
AND
a.userid IN (102)
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 : Tuesday, September 20th 2011 @ 05:10:14 PM
Error Date : Tuesday, September 20th 2011 @ 05:10:14 PM
Script : http://www.vf247.net/forum/newthread.php?do=newthread&f=802
Referrer : http://www.vf247.net/forum/forumdisplay.php?802-Phim-online
IP Address : 119.246.145.114
Username : doileloi
Classname : vB_Database
MySQL Version : 5.0.91
Here full error ! i did try disable the plugin system, edit includes/config.php and add this line right under <?php won't work . please help
Thank you admin for help
Reycer
09-20-2011, 11:02 PM
admincp-->maintenance--->Repair/Optimize Tables
Click on Check All and then on continue at the bottom of the page. I'm guessing you just upgraded your PHP version...right? Doin this should fix the problem:
https://www.vbulletin.com/forum/archive/index.php/t-358696.html
doileloi
09-21-2011, 01:34 PM
admincp-->maintenance--->Repair/Optimize Tables
I did but get same problem . any idea how to fix this thanks
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.