Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
Register FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2011, 11:33 AM
doileloi's Avatar
doileloi doileloi is offline
 
Join Date: Oct 2007
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Can't post new thread in forum

Database error in vBulletin 4.1.5:

PHP Code:
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 
PHP Code:
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
Reply With Quote
  #2  
Old 09-20-2011, 03:36 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

PHP Code:
define('DISABLE_HOOKS', true); 
Reply With Quote
  #3  
Old 09-20-2011, 08:12 PM
doileloi's Avatar
doileloi doileloi is offline
 
Join Date: Oct 2007
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
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
Reply With Quote
  #4  
Old 09-20-2011, 10:02 PM
Reycer Reycer is offline
 
Join Date: Jul 2008
Location: Lebanon, MO (USA)
Posts: 747
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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/arch.../t-358696.html
Reply With Quote
  #5  
Old 09-21-2011, 12:34 PM
doileloi's Avatar
doileloi doileloi is offline
 
Join Date: Oct 2007
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
admincp-->maintenance--->Repair/Optimize Tables 
I did but get same problem . any idea how to fix this thanks
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:39 PM.


Powered by vBulletin® Version 3.9.0
Copyright ©2000 - 2017, vBulletin Solutions Inc.