Solved: 1 Month, 2 Days ago Can't install Default Icon on Posts and Threads plugin
#1
Solved: 1 Month, 2 Days ago
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=''
Reply
#2
Solved: 1 Month, 2 Days ago
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");
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply
#3
Solved: 1 Month, 2 Days ago
(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!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)