Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved MySubscription SQL error
Not Solved Exclamation 
This user has been denied support. This user has been denied support.
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.
Not Solved
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.

Forum Jump:

Users browsing this thread: 1 Guest(s)