MyBB Community Forums

I got this error installing an advertisement plugin & recent thread plugin



What's wrong? How do I fix it?

Not enough information.  What are the plugins, and turn on error handling so you get specific info.

(2020-11-17, 03:52 PM)nixer55 Wrote: [ -> ]Not enough information.  What are the plugins, and turn on error handling so you get specific info.

I'm trying to run these plugins, but the error occurs, on signup, even with all plugins disabled.



& I googled error handling but have no idea what it is

It's in ACP -> Config -> Server and Optimization

It will allow you to display the error so that MyBB will show what the specific issue is. It's very likely related to MySQL running in strict mode (a wild guess), which will cause some older plugins to fail on installation. If this is the culprit, it's very easy to resolve, either with a fix to the plugin (we can help) or by disabling strict mode through your host.

Turn on error handling in your ACP.  This post has more information:

https://community.mybb.com/thread-222957...pid1328626

Let's see what the error actually is.

Edit:  See @Darth Apple has replied.  Familiar with one of the plugins you were trying to install when the issue started, but not the other.  So need to see what the error is trying to tell us.

I turned on log errors but it's still the same error

---

Got the error.

Your copy of MyBB running on Chill Forums has experienced an error. Details of the error include:
---
Type: 20
File:  (Line no. 0)
Message
SQL Error: 1366 - Incorrect integer value: '$sid' for column 'sid' at row 1
Query: 
			INSERT
			INTO mybb_templates (`title`,`template`,`sid`,`version`,`dateline`)
			VALUES ('recentthread','<div class=\"scroll\">\n<div id=\"recentthreads\">\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"6\" class=\"tborder\" style=\"clear: both;max-height:300px\">\n<thead>\n    <tr>\n    <td class=\"thead{$expthead}\" colspan=\"5\" style=\"text-align:left; font-size: 10pt;\"><div class=\"expcolimage\"><img src=\"{$theme[\'imgdir\']}/collapse.png\" id=\"cat_9999_img\" class=\"expander\" alt=\"{$expaltext}\" title=\"{$expaltext}\" /></div>\n<div><b>~ {$lang->recentthreads_recentthreads} ~</b></div>\n</td>\n    </tr>\n</thead>\n<tbody style=\"{$expdisplay}\" id=\"cat_9999_e\">\n    <tr>\n    <td class=\"tcat\" colspan=\"2\"><strong>{$lang->recentthreads_thread} / {$lang->recentthreads_author}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_forum}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_posts}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_last_post}</strong></td>\n    </tr>\n    {$recentth
 reads}\n</tbody>\n    </table>\n</div>\n    </div>','$sid','1800',1606077481)
		
Back Trace: #0  errorHandler->email_error(20, SQL Error: 1366 - Incorrect integer value: '$sid' for column 'sid' at row 1
Query: 
			INSERT
			INTO mybb_templates (`title`,`template`,`sid`,`version`,`dateline`)
			VALUES ('recentthread','<div class=\"scroll\">\n<div id=\"recentthreads\">\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"6\" class=\"tborder\" style=\"clear: both;max-height:300px\">\n<thead>\n    <tr>\n    <td class=\"thead{$expthead}\" colspan=\"5\" style=\"text-align:left; font-size: 10pt;\"><div class=\"expcolimage\"><img src=\"{$theme[\'imgdir\']}/collapse.png\" id=\"cat_9999_img\" class=\"expander\" alt=\"{$expaltext}\" title=\"{$expaltext}\" /></div>\n<div><b>~ {$lang->recentthreads_recentthreads} ~</b></div>\n</td>\n    </tr>\n</thead>\n<tbody style=\"{$expdisplay}\" id=\"cat_9999_e\">\n    <tr>\n    <td class=\"tcat\" colspan=\"2\"><strong>{$lang->recentthreads_thread} / {$lang->recentthreads_author}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_forum}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_posts}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_last_post}</strong></td>\n    </tr>\n    {$recentth
 reads}\n</tbody>\n    </table>\n</div>\n    </div>','$sid','1800',1606077481)
		, , 0) called at [/home/chil17224819/public_html/inc/class_error.php:195]
#1  errorHandler->error(20, Array ([error_no] => 1366,[error] => Incorrect integer value: '$sid' for column 'sid' at row 1,[query] => 
			INSERT
			INTO mybb_templates (`title`,`template`,`sid`,`version`,`dateline`)
			VALUES ('recentthread','<div class=\"scroll\">\n<div id=\"recentthreads\">\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"6\" class=\"tborder\" style=\"clear: both;max-height:300px\">\n<thead>\n    <tr>\n    <td class=\"thead{$expthead}\" colspan=\"5\" style=\"text-align:left; font-size: 10pt;\"><div class=\"expcolimage\"><img src=\"{$theme[\'imgdir\']}/collapse.png\" id=\"cat_9999_img\" class=\"expander\" alt=\"{$expaltext}\" title=\"{$expaltext}\" /></div>\n<div><b>~ {$lang->recentthreads_recentthreads} ~</b></div>\n</td>\n    </tr>\n</thead>\n<tbody style=\"{$expdisplay}\" id=\"cat_9999_e\">\n    <tr>\n    <td class=\"tcat\" colspan=\"2\"><strong>{$lang->recentthreads_thread} / {$lang->recentthreads_author}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_forum}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_posts}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_last_post}</strong></td>\n    </tr>\n    {$recentth
 reads}\n</tbody>\n    </table>\n</div>\n    </div>','$sid','1800',1606077481)
		)) called at [/home/chil17224819/public_html/inc/db_mysqli.php:597]
#2  DB_MySQLi->error(
			INSERT
			INTO mybb_templates (`title`,`template`,`sid`,`version`,`dateline`)
			VALUES ('recentthread','<div class=\"scroll\">\n<div id=\"recentthreads\">\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"6\" class=\"tborder\" style=\"clear: both;max-height:300px\">\n<thead>\n    <tr>\n    <td class=\"thead{$expthead}\" colspan=\"5\" style=\"text-align:left; font-size: 10pt;\"><div class=\"expcolimage\"><img src=\"{$theme[\'imgdir\']}/collapse.png\" id=\"cat_9999_img\" class=\"expander\" alt=\"{$expaltext}\" title=\"{$expaltext}\" /></div>\n<div><b>~ {$lang->recentthreads_recentthreads} ~</b></div>\n</td>\n    </tr>\n</thead>\n<tbody style=\"{$expdisplay}\" id=\"cat_9999_e\">\n    <tr>\n    <td class=\"tcat\" colspan=\"2\"><strong>{$lang->recentthreads_thread} / {$lang->recentthreads_author}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_forum}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_posts}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_last_post}</strong></td>\n    </tr>\n    {$recentth
 reads}\n</tbody>\n    </table>\n</div>\n    </div>','$sid','1800',1606077481)
		) called at [/home/chil17224819/public_html/inc/db_mysqli.php:337]
#3  DB_MySQLi->query(
			INSERT
			INTO mybb_templates (`title`,`template`,`sid`,`version`,`dateline`)
			VALUES ('recentthread','<div class=\"scroll\">\n<div id=\"recentthreads\">\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"6\" class=\"tborder\" style=\"clear: both;max-height:300px\">\n<thead>\n    <tr>\n    <td class=\"thead{$expthead}\" colspan=\"5\" style=\"text-align:left; font-size: 10pt;\"><div class=\"expcolimage\"><img src=\"{$theme[\'imgdir\']}/collapse.png\" id=\"cat_9999_img\" class=\"expander\" alt=\"{$expaltext}\" title=\"{$expaltext}\" /></div>\n<div><b>~ {$lang->recentthreads_recentthreads} ~</b></div>\n</td>\n    </tr>\n</thead>\n<tbody style=\"{$expdisplay}\" id=\"cat_9999_e\">\n    <tr>\n    <td class=\"tcat\" colspan=\"2\"><strong>{$lang->recentthreads_thread} / {$lang->recentthreads_author}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_forum}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_posts}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_last_post}</strong></td>\n    </tr>\n    {$recentth
 reads}\n</tbody>\n    </table>\n</div>\n    </div>','$sid','1800',1606077481)
		, 0, 1) called at [/home/chil17224819/public_html/inc/db_mysqli.php:370]
#4  DB_MySQLi->write_query(
			INSERT
			INTO mybb_templates (`title`,`template`,`sid`,`version`,`dateline`)
			VALUES ('recentthread','<div class=\"scroll\">\n<div id=\"recentthreads\">\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"6\" class=\"tborder\" style=\"clear: both;max-height:300px\">\n<thead>\n    <tr>\n    <td class=\"thead{$expthead}\" colspan=\"5\" style=\"text-align:left; font-size: 10pt;\"><div class=\"expcolimage\"><img src=\"{$theme[\'imgdir\']}/collapse.png\" id=\"cat_9999_img\" class=\"expander\" alt=\"{$expaltext}\" title=\"{$expaltext}\" /></div>\n<div><b>~ {$lang->recentthreads_recentthreads} ~</b></div>\n</td>\n    </tr>\n</thead>\n<tbody style=\"{$expdisplay}\" id=\"cat_9999_e\">\n    <tr>\n    <td class=\"tcat\" colspan=\"2\"><strong>{$lang->recentthreads_thread} / {$lang->recentthreads_author}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_forum}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_posts}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_last_post}</strong></td>\n    </tr>\n    {$recentth
 reads}\n</tbody>\n    </table>\n</div>\n    </div>','$sid','1800',1606077481)
		) called at [/home/chil17224819/public_html/inc/db_mysqli.php:830]
#5  DB_MySQLi->insert_query(templates, Array ([title] => 'recentthread',[template] => '<div class=\"scroll\">\n<div id=\"recentthreads\">\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"6\" class=\"tborder\" style=\"clear: both;max-height:300px\">\n<thead>\n    <tr>\n    <td class=\"thead{$expthead}\" colspan=\"5\" style=\"text-align:left; font-size: 10pt;\"><div class=\"expcolimage\"><img src=\"{$theme[\'imgdir\']}/collapse.png\" id=\"cat_9999_img\" class=\"expander\" alt=\"{$expaltext}\" title=\"{$expaltext}\" /></div>\n<div><b>~ {$lang->recentthreads_recentthreads} ~</b></div>\n</td>\n    </tr>\n</thead>\n<tbody style=\"{$expdisplay}\" id=\"cat_9999_e\">\n    <tr>\n    <td class=\"tcat\" colspan=\"2\"><strong>{$lang->recentthreads_thread} / {$lang->recentthreads_author}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_forum}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recentthreads_posts}</strong></td>\n    <td class=\"tcat\"><strong>{$lang->recen
 tthreads_last_post}</strong></td>\n    </tr>\n    {$recentthreads}\n</tbody>\n    </table>\n</div>\n    </div>',[sid] => '$sid',[version] => '1800',[dateline] => 1606077481)) called at [/home/chil17224819/public_html/inc/plugins/recentthread.php:264]
#6  recentthread_activate() called at [/home/chil17224819/public_html/admin/modules/config/plugins.php:433]
#7  require(/home/chil17224819/public_html/admin/modules/config/plugins.php) called at [/home/chil17224819/public_html/admin/index.php:824]

trying to solve now

Didn't read the whole thing, but pretty sure @Darth Apple hit the nail on the head.  I'd ask host support to remove strict mode on the mysql instance, but takes a restart to make any config changes permanent.

If you have command line access, could make the change temporarily with "set global sql_mode=' ';"

(2020-11-23, 12:01 AM)nixer55 Wrote: [ -> ]Didn't read the whole thing, but pretty sure @Darth Apple hit the nail on the head.  I'd ask host support to remove strict mode on the mysql instance, but takes a restart to make any config changes permanent.

If you have command line access, could make the change temporarily with "set global sql_mode=' ';"

Alright I sent them an email and will update this thread

Not sure it will work: '$sid' makes trying to insert the litteral string $sid and not the value of $sid.
I think that correct the plugin is better than change the server parameters, not everybody have the avaibility to change the configuration.

This is what my hosting company said:

Hi,

no, we need strict mode for security reasons, 
Mysql server shared for all users.

What kind of function you need to remove from sctrict deny list?

Can you please clarify?


NameSilo Support Team

What do I do next??

Crazycat
Not sure it will work: '$sid' makes trying to insert the litteral string $sid and not the value of $sid.
I think that correct the plugin is better than change the server parameters, not everybody have the avaibility to change the configuration.

Not sure what exactly I'm supposed to do with this