modify item

[runza]

hie
i have no probem to add from the frontend a record to my list
http://association-pour-tous.fr/gerontologie/index.php/liste-site-amies

but i am unable to modify one of them , i try from the frontend and from the backend with the message folowing

• 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 `site_amis` SET `nom`='CODERPA 74',`lien`='{\"label\":\"\",\"link\":\"http://www.coderpa74.net//\"}',`image`='/siteamie/0.20529200_1308039018.jpg' WHER

on my local fabrik database it work fine , i wonder which option
select on my fabrik server database to arrive to the same result
and allow to the user to modify an item

best regard

philippe

 

[cheesegrits]

Can you paste the entire error message?

Are you sure you have a primary key (PK) selected on the List settings for that form, and that you haven't un-published or modified that PK element?

-- hugh

 

[runza]

yes it was the problem , i published now the primary key and it work fine

best regard
philippe