MySQL syntax error while editing object

Tuesday 04 October 2005 4:33:47 am

I tried to edit an object in my site and got transaction failed error with the following debug info:

Error: eZMySQLDB  	Oct 04 2005 13:24:14

Query error: 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. Query: SELECT * FROM ezurl WHERE id IN (  )

Error: eZDBInterface::commit TRANSID-a8811327e49e04d60d116b3edb0259cc 	Oct 04 2005 13:24:14

Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-a8811327e49e04d60d116b3edb0259cc.

I don't know why is this happening, it started a day ago and it seems that it happens for all objects that have links in XML Fields. I'm using eZ 3.7.0rc1. Also I'm using XMLArea editor for XML Fields. How can I fix this?

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

Tuesday 04 October 2005 5:11:20 am

You could try http://pubsvn.ez.no/community/trunk/extension/xmlarea-for-36/

It worked for me without errors in a short test in 3.6 and 3.7.

Visit http://triligon.org

Thursday 06 October 2005 12:47:57 am

Hi guys,

I replaced the original xmlarea with this one, and the first time I tried to edit an object, I got the same db transaction error. I then disabled the editor, edited the object in "text mode" wheere I removed the links, and then tried again.

This time, I got to editing mode, but I was only able to edit the second of the two WYSIWYG controls for the object. Also, the links created in the editor do not appear on the web site.

In conclusion, it seems like the original xmlarea editor actually works better for me on v. 3.6. Any idea what I could be doing wrong?

Thanks in advance!

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/