Thread Rating:
  • 10 Vote(s) - 2.7 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[For 1.8] MySubscriptions - Paid Usergroup Subscriptions (Paypal IPN)
#81
(2017-03-16, 05:14 PM)Skullgraver Wrote: MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'order' doesn't have a default value
Query:
INSERT INTO mybbrm_mysubs (name,admin_desc,description,recurring,price,currency,new_group,active,accepted_gids,item_name,item_number) VALUES ('Loyalist','Loyalist','Loyalist',0,'N;','EUR',8,1,'all','Loyalist','sub_{$sid}')
Please contact the MyBB Group for technical support.

how to fix?

Ask your host to disable strict mode for MySQL. An alternative solution is to alter the table so the column order has a default value which can be done in PHPMyAdmin
Reply


Messages In This Thread
RE: MySubscriptions - Paypal IPN Plugin - by Zueq - 2012-07-31, 08:47 PM
RE: MySubscriptions - Paypal IPN Plugin - by JimR - 2014-02-22, 04:10 PM
RE: MySubscriptions - Paypal IPN Plugin - by ytt - 2014-10-03, 06:49 PM
RE: MySubscriptions - Paid Usergroup Subscriptions (Paypal IPN) - by dragonexpert - 2017-03-23, 01:38 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)