Not Solved SQL Error with plugin activation
#3
Not Solved
I can obtain this :
SQL Error:
    1366 - Incorrect integer value: '' for column `bddname`.`mybb_settings`.`sid` at row 1
Query:
    INSERT INTO mybb_settings (`sid`,`name`,`title`,`description`,`optionscode`,`value`,`disporder`,`gid`) VALUES ('','htmlposts_groups','Allowed Groups','Enter the group IDs that can use HTML in posts. (separated by a comma, can be blank to allow all)','text','4',1,34) 
And contrary to the table "mybb_settinggroups", nothing is created in "mybb_settings".

Edit :
I have seen in my database that the column "sid" is on "Null" -> "No" and "Extra" -> "AUTO_INCREMENT".
I have deleted the following lines in the php plugin file :
"sid"			=> NULL,
I suppose that the sid column will be automatically incremented by one with the creation of the line.

It works.

Is it a misconfiguration of my database or the plugin should accept this ?

Edit2 :
I also have an SQL error with this plugin ( Lock - Sell content in hide tags for newpoints ) : https://community.mybb.com/mods.php?action=view&pid=591

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1364 - Field 'description' doesn't have a default value
Query:
    INSERT INTO mybb_settinggroups (`name`,`title`,`disporder`,`isdefault`) VALUES ('lock','Lock Settings',1,0) 
I think for this one I should go with this : https://community.mybb.com/mods.php?acti...w&pid=1374 (equivalent plugin, needs database values transfer).
Reply


Messages In This Thread
SQL Error with plugin activation - by OldDuck - 2020-11-19, 06:36 PM
RE: SQL Error with plugin activation - by Ben - 2020-11-19, 06:52 PM
RE: SQL Error with plugin activation - by OldDuck - 2020-11-19, 07:00 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)