MyBB Community Forums

I installed this plugin. it's fine and also installed. Exclamation

plugin - https://community.mybb.com/mods.php?action=view&pid=458

but after add subscription i got a SQL error. please help to solve this. 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
Query:
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.

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.

Elite_x

.m.