MyBB Community Forums

My 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 fid NOT IN (1,2,3,10,11,5,8,13,14,15,16,6,7)) AND thread.closed NOT LIKE 'mo' at line 3
Query:
SELECT COUNT(thread.tid) as numrows from rebels_tags tag LEFT JOIN rebels_threads thread on(tag.tid = thread.tid) WHERE tag.hash IN ('ec3781968a859f5a11da097c5a602ac8') And thread.tid > 0 and thread.visible='1' AND thread.fid NOT IN ( AND fid NOT IN (1,2,3,10,11,5,8,13,14,15,16,6,7)) AND thread.closed NOT LIKE 'moved|%' limit 1

MyBB 1.8
Tags 2.0

Am I wrong that the latest version is missing forum assignment?

Got it working with the updated mybb tags, but the option to assign to specific forums is missing from admin.

plugin works, but gives this error mesage host account.


Type: 20
File: (Line no. 0)
Message
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 '' at line 3
Query:
INSERT
INTO mybb_tags (``)
VALUES

Worked for just a little while then started throwing following sql error, when searching tags.

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 fid NOT IN

---

Edited:
Would like the ability to turn off auto tags.

(2015-02-15, 04:37 AM)user25 Wrote: [ -> ]Worked for just a little while then started throwing following sql error, when searching tags.

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 fid NOT IN

---

Edited:
Would like the ability to turn off auto tags.

hi, same error for men, where settings auto tags turn of? my settings none this.

thanks.

I'll fix the issues. thanks for reports.

is it half way functional?

Anyone can share a demo or live forum using this please?

(2015-02-12, 08:09 AM)roy Wrote: [ -> ]plugin works, but gives this error mesage host account.


Type: 20
File: (Line no. 0)
Message
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 '' at line 3
Query:
INSERT
INTO mybb_tags (``)
VALUES

do you see this error in showthread.php? or newthread.php?

i see error log host panel.