Hi Sophist ? Finally getting around to addressing this problem. So I enabled Joomla Debugging and also Fabrik Debugging. To refresh, in this example, I am attempting to edit an element in a list record and when I save, I get this error when I first select "View Data" next to the list:
Error
An error has occurred with a eval'd field - please inform the web-site owner.
Debug: Eval exception : publish_status_calculated:
reFormatFormJoins() : : Constant JROUTER_MODE_SEF already defined.
And then when I attempt to save an edit to one of the records in the list, I get this error:
1064 FABRIK ERROR: Incorrect insert for the list "mysite_fabrik_joblistings": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1: UPDATE `mysite_fabrik_joblistings` SET `jobset_publish_status`='1',`jobset_jobclosed`='0',`jobset_closedbyadmin`='0',`console_output`='Mon Jun 18 2018 15:48:56 GMT-0400 (EDT)',`jobdet_position`='Pre-k Group Supervisor',`jobdet_overview`=' Overview text string here. ',`jobdet_publish_date`='2018-05-04 00:00:00',`jobdet_expiration_date`='2018-06-29 00:00:00',`jobdet_responsibilites`='? Job responsibilities list here.',`jobdet_jobtype`='Full-Time',`jobdet_number_jobs_avail`='1',`jobdet_required_studies`='Bachelors Degree',`jobdet_salary_option`='Hourly',`jobdet_required_lang`='English',`jobdet_salary_req`='0.00',`jobdet_pref_start_date`='2018-05-02 04:00:00',`jobdet_benefits`='Job benefits here. ',`jobdet_start_time`='0830',`jobdet_end_time`='0230',`jobdet_expected_startend_time`='8:30 am-2:30 pm',`jobdet_keystone_star_level`='STAR 1',`jobdet_agegroupposition`='Preschool',`jobdet_min_ece_credits_req`='18',`jobdet_min_career_lattice_level`='Level Here',`jobdet_req_experience`='2-5 years',`jobdet_certification`='No',`jobdet_apply_by`='Email',`jobdet_appl_must_include`='Resume',`jobdet_applyto_value`='
user@anydomain.com',`jobdet_otherdocs_req`='',`jobdet_agree_terms`='[\"true\"]',`jobdet_recaptcha`='',`jobdet_agency_name`='Agency Name',`jobdet_agency_type`='0',`jobdet_agencytype_addt_info`='',`agency_details_address`='',`agency_suite_floor`='',`jobdet_region`='Select area/region...',`jobdet_county`='Countyname',`jobdet_city`='CityName',`jobdet_state`='XX',`jobdet_zipcode`='000000',`publish_status_calculated`='',`jobpay_amount`='0',`jobcalc_user`='495',`jobpay_promo_code`='CODE14',`txn_id`='',`ipn_custom`='<br />Promo Code -CODE14 was applied. Amount is now 0',`amt`='0.00',`status`='Completed',`address`='',`subid`='',`jobpay_codevalue`=NULL WHERE
/home/myaccount/domains/mysite.com/subdomains/parent/public_html/components/com_fabrik/models/list.php:7831
Joomla 3.8.8; Fabrik 3.8.1