+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Extensions (https://community.mybb.com/forum-201.html)
+--- Forum: Plugins (https://community.mybb.com/forum-73.html)
+---- Forum: Plugin Support (https://community.mybb.com/forum-72.html)
+---- Thread: 1366 - Incorrect integer value: 'no' for column 'isdefault' at row 1 (/thread-212400.html)
1366 - Incorrect integer value: 'no' for column 'isdefault' at row 1 - M0rph - 2017-08-16
Hello,
My mybb version is the latest, 1.8.12
I have an SQL error when i try to install plugin "Subforumsincolumns":
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1366 - Incorrect integer value: 'no' for column 'isdefault' at row 1Query:INSERT INTO mybb_settinggroups (
gid,name,title,description,disporder,isdefault) VALUES ('0','subincol','Subforums In Columns','Show subforums in columns.','0','no')Thank you
(2017-08-16, 02:11 AM)M0rph Wrote: Hello,
My mybb version is the latest, 1.8.12
I have an SQL error when i try to install plugin "Subforumsincolumns":
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1366 - Incorrect integer value: 'no' for column 'isdefault' at row 1Query:INSERT INTO mybb_settinggroups (gid,name,title,description,disporder,isdefault) VALUES ('0','subincol','Subforums In Columns','Show subforums in columns.','0','no')
Thank you
First an error was for value 'NULL' for column 'gid' at row 1 and I replaced 'NULL' by '0'
Second an error was for value 'no' for column 'isdefault' at row 1 and I replaced 'no' by '0'
Third an error was for value 'NULL' for column 'sid' at row 1 and I replaced 'NULL' by '0'
Now it works, i think, in any case it is installed!
Thank you
RE: 1366 - Incorrect integer value: 'no' for column 'isdefault' at row 1 - fizz - 2017-08-18
(2017-08-16, 02:11 AM)M0rph Wrote: Hello,
My mybb version is the latest, 1.8.12
I have an SQL error when i try to install plugin "Subforumsincolumns":
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1366 - Incorrect integer value: 'no' for column 'isdefault' at row 1Query:INSERT INTO mybb_settinggroups (gid,name,title,description,disporder,isdefault) VALUES ('0','subincol','Subforums In Columns','Show subforums in columns.','0','no')
Thank you
(2017-08-16, 02:11 AM)M0rph Wrote: Hello,
My mybb version is the latest, 1.8.12
I have an SQL error when i try to install plugin "Subforumsincolumns":
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1366 - Incorrect integer value: 'no' for column 'isdefault' at row 1Query:INSERT INTO mybb_settinggroups (gid,name,title,description,disporder,isdefault) VALUES ('0','subincol','Subforums In Columns','Show subforums in columns.','0','no')
Thank you
First an error was for value 'NULL' for column 'gid' at row 1 and I replaced 'NULL' by '0'
Second an error was for value 'no' for column 'isdefault' at row 1 and I replaced 'no' by '0'
Third an error was for value 'NULL' for column 'sid' at row 1 and I replaced 'NULL' by '0'
Now it works, i think, in any case it is installed!
Thank you
GID auto increments for settinggroups and shouldn't be 0, that's going to likely cause problems down the road. Your other two changes are fine.