2016-06-27, 03:05 PM
Hello,
I successfully installed Teamspeak 3 Sync for Mybb, but I get an SQL-Error when I try to add the Servergroup_ID in the groupsettings. Its the same error if I try to change groupoptions. Is there anyway to fix it?
MyBB has experienced an internal SQL error and cannot continue.
[spoiler]
SQL Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'uf.,uf. FROM mybb_userfields as uf JOIN mybb_users as u ON uf.ufid=u.uid WHERE (' at line 1
Query:select uf.ufid,u.username,u.usergroup,u.additionalgroups,uf.,uf.,uf. FROM mybb_userfields as uf JOIN mybb_users as u ON uf.ufid=u.uid WHERE (uf. IS NOT NULL OR uf. IS NOT NULL OR uf. IS NOT NULL) AND (uf. != '' OR uf. != '' OR uf. != '')
[/spoiler]
URL: king-gaming.de
Style: duende
Plugins: Teamspeak 3 Group Sync, PluginLibary (TS3PHPFramework in ROOT-Folder)
MyBB: 1.8.7
PHP: 5.6.22-0+deb8u1
SQL: MySQL 5.5.5
Kind regards,
Rick
I successfully installed Teamspeak 3 Sync for Mybb, but I get an SQL-Error when I try to add the Servergroup_ID in the groupsettings. Its the same error if I try to change groupoptions. Is there anyway to fix it?
MyBB has experienced an internal SQL error and cannot continue.
[spoiler]
SQL Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'uf.,uf. FROM mybb_userfields as uf JOIN mybb_users as u ON uf.ufid=u.uid WHERE (' at line 1
Query:select uf.ufid,u.username,u.usergroup,u.additionalgroups,uf.,uf.,uf. FROM mybb_userfields as uf JOIN mybb_users as u ON uf.ufid=u.uid WHERE (uf. IS NOT NULL OR uf. IS NOT NULL OR uf. IS NOT NULL) AND (uf. != '' OR uf. != '' OR uf. != '')
[/spoiler]
URL: king-gaming.de
Style: duende
Plugins: Teamspeak 3 Group Sync, PluginLibary (TS3PHPFramework in ROOT-Folder)
MyBB: 1.8.7
PHP: 5.6.22-0+deb8u1
SQL: MySQL 5.5.5
Kind regards,
Rick