MyBB Community Forums
1064 - You have an error in your SQL syntax - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 Security Management and Support (https://community.mybb.com/forum-153.html)
+------ Thread: 1064 - You have an error in your SQL syntax (/thread-169274.html)



1064 - You have an error in your SQL syntax - sidhartha - 2015-04-04

My site forum.mytabletguru.com is showing 


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1064 - 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 'index' ,'index_whosonline' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ' at line 1QueryConfusedELECT title,template FROM mybb_templates WHERE title IN (' ,'index' ,'index_whosonline' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error' ,'global_boardclosed_warning' ,'global_bannedwarning' ,'error_inline' ,'error_nopermission_loggedin' ,'error_nopermission') AND sid IN ('-2','-1','3') ORDER BY sid ASC




I am able to access the dashboard.



In the "file verification" option two files is shown changed. No changes has been made from our side.



inc/functions.php


inc/class_templates.php

Plz suggest how to fix this.


RE: 1064 - You have an error in your SQL syntax - .m. - 2015-04-04

when does the error appear - is it after logging in ? or is it fixed as there is no such error at present for guests