Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 21 Oct 2018, 16:01
pallam pallam is offline
 
Join Date: Feb 2017
Database error

Greetings I have this problem and how to fix it please help Thans in advance ..



Database error in vBulletin 4.2.5:

Invalid SQL:

SELECT
thread.forumid as forumid, thread.visible, post.title as title, thread.threadid as threadid, thread.replycount, thread.dateline, post.postid, post.pagetext as pagetext, icon.iconid, post.iconid as iptal, attachment.attachmentid AS attachmentid
FROM prince_thread as thread
LEFT JOIN prince_post as post on (thread.firstpostid = post.postid)
LEFT JOIN prince_forum as forum on (thread.forumid = forum.forumid)
LEFT JOIN prince_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN (prince_attachment AS attachment
INNER JOIN prince_filedata AS filedata ON (attachment.filedataid = filedata.filedataid) ) ON (attachment.contentid = thread.firstpostid AND filedata.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))
WHERE thread.visible = 1 AND thread.dateline > 1534949270 AND thread.forumid IN (0,)
GROUP BY threadid
ORDER BY replycount DESC
LIMIT 0,6;

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 ')
GROUP BY threadid
ORDER BY replycount DESC
LIMIT 0,6' at line 9
Error Number : 1064
Request Date : Sunday, October 21st 2018 @ 02:47:50 PM
Error Date : Sunday, October 21st 2018 @ 02:47:50 PM
Script :
Referrer :
IP Address : *******
Username : Jikuu
Classname : vB_Database_MySQLi
MySQL Version : 5.6.41-84.1
Server : ********
User Agent :
Reply With Quote
  #2  
Old 22 Oct 2018, 15:13
x iJailBreak x's Avatar
x iJailBreak x x iJailBreak x is offline
 
Join Date: Jan 2011
Originally Posted by pallam View Post
Greetings I have this problem and how to fix it please help Thans in advance ..
Have you installed any plugins recently? It looks like something is messing with the forum IDs being retrieved in the query:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

That last comma in the brackets is what's causing your error.
__________________
Professional web developer & sysadmin. Former bad man.
Reply With Quote
  #3  
Old 22 Oct 2018, 16:54
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
 
Join Date: Sep 2008
Real name: Michael Miller Jr
Check for modifications that allow you to list forumid's in the settings, i.e. a plugin that in the settings allows you to specify the forumid #'s of the forums to use it in etc. It appears you left it blank or removed a forumid but also forgot to remove the comma in the list.
__________________
Daddy Does Dios and Figs!
https://www.linkedin.com/in/thelastsuperman
For all your vBulletin and Wordpress custom needs.

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!
Reply With Quote
  #4  
Old 25 Oct 2018, 15:27
pallam pallam is offline
 
Join Date: Feb 2017
Thank you guys for the help problem solved.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 15:54.

Layout Options | Width: Wide Color: