MyBB Community Forums

Enclosed please find the SQL error received when trying to install TSLINK

Help please:
Any ideas if this is a compatibility problem with 1.8.7 or maybe I have missed something. The install instructions are not very clear so I may have made a mistake?

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1366 - Incorrect integer value: '' for column 'tid' at row 1
Query:
INSERT INTO [REMOVED PREFIX]_templates (`tid`,`title`,`template`,`sid`,`version`) VALUES ('','tslink_usercp_menu','\n<tr>\n<td class=\"tcat smalltext\">\n	<div class=\"expcolimage\">\n <img src=\"{$theme[\'imgdir\']}/collapse{$collapsedimg[\'usercptslink\']}.png\" id=\"usercptslink_img\" class=\"expander\" alt=\"[-]\" title=\"[-]\" />\n	</div>\n	<div>\n	<span>\n <strong>{$lang->tslink_menu_title}</strong>\n	</span>\n	</div>\n</td>\n</tr>\n<tbody style=\"{$collapsed[\'usercptslink_e\']}\" id=\"usercptslink_e\">\n	<tr>\n	<td class=\"trow1 smalltext\">\n	<a href=\"usercp.php?action=tslink\" class=\"usercp_nav_item usercp_nav_tslink\">{$lang->tslink_menu_link}</a>\n	</td>\n	</tr>\n</tbody>\n<style type=\"text/css\">\n.usercp_nav_tslink {\n	background: url(\'images/tslink/teamspeak3-icon.png\') no-repeat left center;\n}\n</style>','-2',1)
Please contact the MyBB Group for technical support.

I would assume that this is just totally unsupported as a plugin...

can you ask your web host to disable the strict mode of database server ..

I gave up on the TS Link but did try and resolve the strict mode

Unfortunately this has now caused an even bigger problem. While removing and reinstalling the plugin [ MyBB-Plugin-Teamspeak3-Sync-1.1.3rc1 ] it failed at some point rebooting the server and re-installing myBB does not solve this issue... removing the Teamspeak3.php file from the plugin folder resolves the visible problem... However  I guess the real issue is in the SQL database???

Could you dump your settinggroups table and send it by PM to me?

---

I've digged the MySQL manuals, it seams like "ANSI_MODE" is active?:

Quote:ANSI_QUOTES

Treat “"” as an identifier quote character (like the “” quote character) and not as a string quote character. You can still use “” to quote identifiers with this mode enabled. With ANSI_QUOTES enabled, you cannot use double quotation marks to quote literal strings, because it is interpreted as an identifier.

I'm asking that as the error message is a bit confusing, it seams like MySQL thinks the column name is "opt_teamspeak3" instead of "name".
Anyways, I'm making a modified version of the plugin with a stricter SQL syntax.

---

Please get the 1.1.4rc1 version from GitHub. But you need to manually modify the settingsgroup entry and change the name from "opt_teamspeak3" to "opt_teamspeak" before uploading the plugin.

(2016-06-15, 08:43 PM)Terran_Ulm Wrote: [ -> ]Could you dump your settinggroups table and send it by PM to me?

---

Please get the 1.1.4rc1 version from GitHub. But you need to manually modify the settingsgroup entry and change the name from "opt_teamspeak3" to "opt_teamspeak" before uploading the plugin.

Sorry
Not sure where to access the settingsgroup or to do this but if you can point me in the right direction yes happy to do so...

---

After further investigation the settingsgroup table in SQL does NOT have an entry "opt_teamspeak3" and I think that I have a further problem.

Plugins view does not correctly show plugins
I think that making changes to the SQL strict mode and ANSI has left me with a corrupted teamspeak plugin. Basically without your plugin file on the server the myBB plugin system view is fine but as soon as I upload the teamspeak files to the server the myBB plugin view doesn't load correctly.

Everything after the
"This section allows you to activate, deactivate, and manage the plugins that you have uploaded to your forum's inc/plugins directory. To hide a plugin from view, but not lose any stored information from it, click the Deactivate link."
statement vanishes????

So I don't see the sections Active Plugins or Inactive Plugins

~

Have you tried the updated plugin version?

If there is no entry "opt_teamspeak3" it will be created once you can install & activate the plugin. The updated plugin should be fine with ANSI_QUOTES but I cannot test as it could break my site

What actually happens at your site is that for some reason the plugin fails at a SQL statement due to the ANSI_QUOTES mode so processing of the page output dies and you dont see the plugins. In the 1.1.3rc1 version I had messed up with the " and ' quotes and fixed that in 1.1.4rc1.

But today I've tested it on an new installation and noticed a change in the table structure of the profilefields table in MyBB 1.8.x which I totally missed so far -> 1.1.5rc1 ...

(2016-06-16, 12:41 PM)Terran_Ulm Wrote: [ -> ]Have you tried the updated plugin version?

I am currently unable to successfully load the plugin to my forum. as the forum plugin view corrupts.
Please refer to my private PM, Thanks

---

ok I just re-tried with the version --> 1.1.5rc1 and this prepared the corruption problem...

But I again have the table error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'editable' in 'field list'
Query:
INSERT INTO XX_profilefields (`name`,`description`,`disporder`,`type`,`length`,`maxlength`,`required`,`editable`) VALUES ('TeamspeakID 1','Unique Teamspeak ID, see "Settings->Identities->Default->Unique ID"',7,'text',70,60,0,1)

Currently have ANSI off and I believe that the SQL mode is set to "" but I am not sure how to double check this.

OK, I think there is a flaw in the upgrade process from 1.6.x to 1.8.x (which I did at my forum where I tested the plugin). Seams like there is a column left in the table during the upgrade which isn't present for a new installation.
I'll setup a clean MyBB installation and try it for myself.

Thank you for your help and assistance. I appreciate the support.

I have edited out the line entry as described and the plugin now seems to load successfully

So after that I go and edit the admin details
Server          = 127.0.0.1
Q_port         = 10011
Q_user         = xxxx
Q_pass         = xxxx
Port              = 9987
G_channel   = 8

Assuming these are acceptable I then go and edit Groups
Select first group GUEST
Select the new TS tab
Server Group ID    = 8
**Channel Data     = 8
**Sort Order          = 8
Channel Group ID  = 8

**Not sure on these values


On trying to save the following error is produced

Warning [2] require_once(..//[EDITED PATH DETAILS]/TeamSpeak3/TeamSpeak3.php): failed to open stream: No such file or directory - Line: 329 - File: inc/plugins/teamspeak3.php PHP 5.5.34 (Darwin)

File
Line
Function/inc/plugins/teamspeak3.php
329
errorHandler->error
/inc/plugins/teamspeak3.php
329
teamspeak3_connect
/inc/plugins/teamspeak3.php
299
teamspeak3_connect
/inc/class_plugins.php
139
teamspeak3_admin_user_groups_edit_commit_6
/admin/modules/user/groups.php
952
pluginSystem->run_hooks
/admin/index.php
770
require