Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySubscription SQL error
#1
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
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.
Reply
#2
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)