Store row failed on update of record

[maleman]

I am receiving this error when I try to update a record from a form:

Store row failed:
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 SQL=UPDATE `fab_time` SET `date_time`='2011-12-31 01:39:00',`workorder`='23',`start`='2012-05-16 03:14:00',`end`='',`hours`='0.00',`billable`='[\"True\"]',`billed`='No',`core_change`='No',`desc`='Continue working on builder home pages. Testing...
' WHERE

However, if I choose to "Save as a copy" it works fine!

Fabrik 3.0.5.2
Joomla! 2.5.4
PHP 5.2.17
MySQL 5.5.21-55

Thanks in advance for your help!

 

[troester]

The interessing part of the error message is missing (WHERE...)
Save as a copy does an INSERT.
Looking at your column names I can't see an ID.

Did you set a primary key for your list?
If fab_time is a table created by fabrik - did you unpublish or delete the id element?

 

[maleman]

Here are the settings that I currently have for the table. Also, I was able to get more the SQL error.

(see attachments)

Thanks for your help!

 

[troester]

You should never unpublish the id; it's the key to all data handling.

 

[maleman]

That took care of the problem! Thanks bunches!!!