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

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2011, 12:33 PM
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 syntaxcheck 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, 04: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, 09: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_datelinefd.filesize, IF(fd.thumbnail_filesize 010) AS hasthumbnailfd.thumbnail_filesize,
                    
a.datelinea.statea.attachmentida.countera.contentida.filenamea.userida.settingsa.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.contentida.displayorder;

MySQL Error   You have an error in your SQL syntaxcheck 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  
TuesdaySeptember 20th 2011 05:10:14 PM
Error Date    
TuesdaySeptember 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, 11: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, 01: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:24 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.11195 seconds
  • Memory Usage 2,224KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (5)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete