Forums / Developer / MySQL syntax error while editing object

MySQL syntax error while editing object

Author Message

Marko Žmak

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

Marko Žmak

Tuesday 04 October 2005 4:39:34 am

I've just discovered that the problem disappears when I disable XMLArea editor. Is there way to solve this problem so that I can use XMLArea?

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

Hubert Farnsworth

Gabriel Ambuehl

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

Olivier Pierret

Wednesday 05 October 2005 8:58:13 am

This xmlarea-for-36 version did not work for me - failed with the following error:

Fatal error: A database transaction in eZ publish failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-0fea1f36031226b3e45a4a440f6df8a3 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

Did someone succesfully test xmlarea with eZ publish (Version: 3.6.0 (3.6.0) Révision SVN: 11973)
?
many thanks

Olivier

Eirik Alfstad Johansen

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/

Marko Žmak

Saturday 08 October 2005 10:42:58 am

I think that the source of this problem is the new way of handling links in XML fields in eZ.

Could someone from eZ crew, or the creator of XMLArea contribution confirm this, and/or suggest a fix?

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

Hubert Farnsworth