MyBB Community Forums

Full Version: MySubscription SQL error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.
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.