MyBB Community Forums
MySubscription SQL error - Printable Version

+- MyBB Community Forums (
+-- Forum: Extensions (
+--- Forum: Plugins (
+---- Forum: Plugin Support (
+---- Thread: MySubscription SQL error (/thread-227848.html)

MySubscription SQL error - Elite_x - 2020-05-17

I installed this plugin. it's fine and also installed. Exclamation
but after add subscription i got a SQL error. please help to solve this. Sad Sad

Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 180 - File: BhT2k2oadm1np4n3lUKSTTSAN/modules/user/mysubs.php PHP 7.3.17 (Linux)
File	Line	Function
/BhT2k2oadm1np4n3lUKSTTSAN/modules/user/mysubs.php	180	errorHandler->error
/BhT2k2oadm1np4n3lUKSTTSAN/index.php	821	require

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'order' doesn't have a default value
INSERT INTO mybbbc_mysubs (`name`,`admin_desc`,`description`,`recurring`,`price`,`currency`,`new_group`,`active`,`accepted_gids`,`item_name`,`item_number`) VALUES ('VIP','VIP','VIP',0,'a:1:{i:0;a:3:{s:1:\"c\";s:2:\"20\";s:1:\"l\";s:2:\"12\";s:2:\"lt\";s:1:\"m\";}}','USD',9,1,'all','VIP','sub_{$sid}')
Please contact the MyBB Group for technical support.

RE: MySubscription SQL error - .m. - 2020-05-17

MySubscriptions plugin is not compatible with recent versions of php

for the second error, you can try using below SQL query
ALTER TABLE `mybbbc_mysubs` MODIFY COLUMN `order` int(3) DEFAULT '0'

[SQL queries guidance]

ALSO, your database server is set to strict mode.
that can be problematic while installing / using some plugins.

perhaps it'd be better to request your web host to disable the strict mode.