05-15-2013, 01:08 PM
#1
User Info
If you try to search for the word "anna" (without quotes) then the attached MySql error comes out. I think there's a syntax error in the SQL query where it says 'moved|%'' <-- two quotes

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 ') AND t.visible>0 AND t.closed NOT LIKE 'moved|%'' at line 1
Query:
SELECT COUNT(t.tid) AS resultcount FROM mybb_threads t WHERE t.tid IN () AND t.visible>0 AND t.closed NOT LIKE 'moved|%'


Thanks.

0 128
Reply
 05-15-2013, 03:17 PM
#2
User Info
thanks for pointing that out..I'll look into it.

40 5,830
Reply
 05-16-2013, 03:35 AM
#3
User Info
Also getting search issues;

TSN Wrote:MyBB SQL Error

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 ') AND t.visible>0 AND t.closed NOT LIKE 'moved|%'' at line 1
Query:
SELECT COUNT(t.tid) AS resultcount FROM mybb_threads t WHERE t.tid IN () AND t.visible>0 AND t.closed NOT LIKE 'moved|%'

Please contact the MyBB Group for support.

At least the rest of the site work, unlike large parts of the network at work today Tongue

3 3,580
Reply
 05-16-2013, 04:25 PM
#4
User Info
it's a known issue. it can't be fixed until Sunday as I'll be away on vacation until Saturday night and don't want to be using spotty internet when the site is being worked on.

40 5,830
Reply
 05-21-2013, 10:39 AM
#5
User Info
this should be fixed.

40 5,830
Reply
Users browsing this thread: 1 Guest(s)