MyBB Community Forums

MyBB Community Forums > Extensions > Plugins > Plugin Support > Can't install Default Icon on Posts and Threads plugin
Full Version: Can't install Default Icon on Posts and Threads plugin
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

arisudi

2021-05-21, 07:43 AM
Can't install Default Icon on Posts and Threads plugin:
https://community.mybb.com/mods.php?action=view&pid=58

MyBB SQL Error occurs:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1292 - Truncated incorrect DOUBLE value: ''
Query:
    UPDATE mybb_threads set icon='1' where icon=''

Crazycat

2021-05-21, 08:36 AM
Edit the inc/plugins/defaulticon.php file, replace lines 74 and 75 with the following:
	$db->query("UPDATE ".TABLE_PREFIX."threads set icon=1 where icon=0");
	$db->query("UPDATE ".TABLE_PREFIX."posts set icon=1 where icon=0");

arisudi

2021-05-21, 11:30 AM
(2021-05-21, 08:36 AM)Crazycat Wrote: [ -> ]Edit the inc/plugins/defaulticon.php file, replace lines 74 and 75 with the following:
	$db->query("UPDATE ".TABLE_PREFIX."threads set icon=1 where icon=0");
	$db->query("UPDATE ".TABLE_PREFIX."posts set icon=1 where icon=0");

The plugin is installed successfully.

Thank you so much for your help! Good luck!
MyBB Community Forums > Extensions > Plugins > Plugin Support > Can't install Default Icon on Posts and Threads plugin