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

Community Based Support for JROX Affiliate Manager Only
Post Reply
conmaso
Posts: 6
Joined: Tue Jul 17, 2018 4:20 am

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

Post by conmaso » Tue Jul 17, 2018 4:50 am

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

User avatar
forumadmin
Site Admin
Posts: 407
Joined: Fri Nov 07, 2014 4:50 pm

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

Post by forumadmin » Mon Jul 30, 2018 11:12 pm

hello,

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

conmaso
Posts: 6
Joined: Tue Jul 17, 2018 4:20 am

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

Post by conmaso » Wed Aug 29, 2018 1:54 pm

Thanks for support

Post Reply