Hi All,
I have a website using Fabrik 4.0 Zeta. In one of my lists that fetches data from different tables, I have an update option. However, when updating data, I receive the following error message:
Store row failed: UPDATE `love_requests` SET `lastname`='Test', `firstname`='Test', `mobile`='1234567890', `address1`='address1', `address2`='', `city`='city', `state`='state', `zip`='12345', `requestdate`='2024-10-17 07:24:40', `email`='test123@gmail.com', `status`='new', `priority`='1', `matchdate`=NULL, `approvedate`=NULL, `scheduledate`=NULL, `matchmama`='1', `adults`='6', `kids`='0', `restrictions`='No', `vegetarian`='No', `vegan`='No', `glutenfree`='No', `dairyfree`='No', `nutallergy`='No', `otherallergy`='No', `mamanotes`='', `allergyinfo`='', `deliverydate`=NULL, `CO`='USA' WHERE id='710205'. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE' at line 1; Please inform your website owner.
When I check the list again, the data has been updated correctly, but I would like to resolve this error message.
Can anyone help me with this? Thanks in advance!
I have a website using Fabrik 4.0 Zeta. In one of my lists that fetches data from different tables, I have an update option. However, when updating data, I receive the following error message:
Store row failed: UPDATE `love_requests` SET `lastname`='Test', `firstname`='Test', `mobile`='1234567890', `address1`='address1', `address2`='', `city`='city', `state`='state', `zip`='12345', `requestdate`='2024-10-17 07:24:40', `email`='test123@gmail.com', `status`='new', `priority`='1', `matchdate`=NULL, `approvedate`=NULL, `scheduledate`=NULL, `matchmama`='1', `adults`='6', `kids`='0', `restrictions`='No', `vegetarian`='No', `vegan`='No', `glutenfree`='No', `dairyfree`='No', `nutallergy`='No', `otherallergy`='No', `mamanotes`='', `allergyinfo`='', `deliverydate`=NULL, `CO`='USA' WHERE id='710205'. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE' at line 1; Please inform your website owner.
When I check the list again, the data has been updated correctly, but I would like to resolve this error message.
Can anyone help me with this? Thanks in advance!