MyBB Community Forums

Hello, I've recently installed MySubscriptions plugin, however, I've gotten this error and cannot add subscriptions. This type of error has also occurred on other of plugins I've installed.

are you referring to this MySubscriptions plugin ?
which other plugins are activated on your forum ?

such errors appear due to strict mode of your database server.
contact your web host support and ask whether they can disable the strict mode ..

Yes that is the correct plugin. The other plugins were ProfileDesign and another one related to design but I cannot remember.

open the plugin file using editor like notepad++
find code like below (around line 73 [GitHub link])

`log` TEXT NOT NULL,

change to

`log` TEXT NOT NULL default '',

save the file, re-upload it & reinstall the plugin. check if it helps ..

Value changed, new error when I try to create a subscription

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'order' doesn't have a default value
Query:
INSERT INTO *****_mysubs (name,admin_desc,description,recurring,price,currency,new_group,active,accepted_gids,item_name,item_number) VALUES ('Prime','','Upgrade to Prime Membership.',0,'N;','USD',9,1,'all','Prime','sub_{$sid}')

in the plugin file, find below code [(line 55) GitHub link]

`order` INT( 3 ) NOT NULL ,

try changing to :

`order` INT( 3 ) NOT NULL default '0',

Value changed, however still says 'order' doesn't have a default value.

---

I got it do add subscriptions now, however, when clicking on order/purchase after selecting the length/amount it redirects to the PayPal page but PayPal shows an error page stating

"Things don't appear to be working at the moment. Please try again later."

---

I got everything working now. Thank you for your assistance much appreciated.

(2020-02-17, 03:09 PM)verstra Wrote: [ -> ]Value changed, however still says 'order' doesn't have a default value.

---

I got it do add subscriptions now, however, when clicking on order/purchase after selecting the length/amount it redirects to the PayPal page but PayPal shows an error page stating

"Things don't appear to be working at the moment. Please try again later."

---

I got everything working now. Thank you for your assistance much appreciated.

Sorry going off topic may I know what you did to fix this error?