Users browsing this thread: 1 Guest(s)
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

AdminSQL Error: 1366 Settings for the plugin.','1','no' mybb

#1
This is an error we receive when trying to install a mybb plugin. The good news is YES we have a permanent fix!

SQL Error:
1366 - Incorrect integer value: 'NULL' for column 'sid' at row 1
Query:
INSERT INTO mybb_settinggroups 

Now open MyBB-->inc-->plugins-->plugin-name.php (open file with notepad++)



Search for Null

'sid'           => 'NULL',

Replace 'Null' with 0 

'sid'           => '0',


Search for isdefault 

'isdefault'     => 'no',

Replace 'no' with 0

'isdefault'     => '0',


Now you should be able to reinstall your plugin with no errors

Have a nice day  Heart
**=================================**
Thanks everyone for contributing to CanadaCommunity.org!
Regards,
The CanadaCommunity Group
**=================================**

Reply
Thanks given by:


Who read this thread?
1 User(s) read this thread:
Admin (05-13-2019, 05:42 PM)

Possibly Related Threads...
Thread Author Replies Views Last Post
  Last Post less characters mybb - Less characters in last post thread Admin 0 33 05-16-2019, 03:04 AM
Last Post: Admin
  HTTPS mybb - MyBB HTTPS - Setting up HTTPS on MyBB Admin 0 42 05-14-2019, 06:52 PM
Last Post: Admin
  Google SEO MyBB - MyBB SEO Google -MyBB friendly URLs Admin 0 61 05-14-2019, 05:24 PM
Last Post: Admin
  mybb plugins - mybb mods - extend mybb with features and functionalities Admin 0 53 05-13-2019, 11:46 PM
Last Post: Admin
  IP Ghost Plugin Fatal Error MyBB Admin 0 51 05-12-2019, 06:09 PM
Last Post: Admin
  characters increase count signature mybb Admin 0 44 05-12-2019, 04:16 PM
Last Post: Admin
  MyBB Version 1.8.20 center alignment does not work Admin 0 34 05-12-2019, 03:51 PM
Last Post: Admin
  Default Thread Subscription Mode: mybb Admin 0 26 05-08-2019, 03:19 PM
Last Post: Admin
  Color user title MyBB Admin 0 107 04-16-2019, 12:18 PM
Last Post: Admin
  Color Postbit MyBB Admin 0 74 04-16-2019, 02:39 AM
Last Post: Admin