Help! Error:1364 - Field 'sort_order' doesn't have a default value

Recommended Posts

After install Jrox on my VPS, when i create new Affiliate Program, it's appeare Error:

How can i fix it?

Thanks

-------------------

A Database Error Occurred

Error Number: 1364

Field 'sort_order' doesn't have a default value

INSERT INTO `jam_programs` (`program_status`, `program_name`, `signup_link`, `url_redirect`, `hidden_program`, `group_id`, `commission_levels`, `enable_pay_per_action`, `enable_pay_per_click`, `ppc_interval`, `enable_cpm`, `cpm_unique_ip`, `commission_frequency`, `restrict_recur_commissions`, `new_commission_option`, `auto_approve_commissions`, `program_description`, `privacy_policy`, `terms_of_service`, `modified_by`, `last_modified`, `program_cookie_name`) VALUES ('0', 'Heo phát lộc', 'heophat', 'http://heophat.com', '0', '1', '1', '1', '0', '', '0', '0', '', '', 'no_pending', '', '', '', '', 'kiendk', 1531774097, 'jamcom2')

Filename: models/Programs_model.php

Line Number: 149

Share on other sites
• 2 weeks later...

hello,

this usually means you have Mysql STRICT_MODE enabled. Please disable that and it should fix the default values error.

Share on other sites
• 5 weeks later...

Thanks for support

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.