|
Author
|
Message
|
|
Daniel Clements
|
Wednesday 10 August 2011 6:32:22 pm
Hi all,I'm new to these forums but have been using EZ Publish to develop sites for around 6 months now.I've just started installing the 2011.7 community version and seem to have a weird problem when trying to delete content objects. This problem only seems to be related to some objects and not others. I have no idea what's going on. :-( I'm getting the following error in EZ 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-bd33fef8bbcb7b0436b2257ef248070b and has been logged.Please include the transaction ID and the current URL when contacting the system administrator.
"
My debug output has the following error:
"
Error: eZMySQLiDB Aug 11 2011 11:20:35Query error (1064): 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 2. Query: SELECT id, contentobject_attribute_id, filepath FROM ezimagefile WHERE contentobject_attribute_id='327' AND filepath IN ( )
"
The log has this output.
"
[ Aug 11 2011 11:20:35 ] [124.169.141.223] Timing Point: Module start 'content'
[ Aug 11 2011 11:20:35 ] [124.169.141.223] eZFileHandler::move:Cannot rename file var/ezflow_site/storage/images/boards-accessories/sup/albatross-touring-board/yellow/327-1-eng-AU/yellow.jpg, it does not exist
[ Aug 11 2011 11:20:35 ] [124.169.141.223] eZMySQLiDB:Query error (1064): 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 2. Query: SELECT id, contentobject_attribute_id, filepath FROM ezimagefile WHERE contentobject_attribute_id='327' AND filepath IN ( )
[ Aug 11 2011 11:20:35 ] [124.169.141.223] eZDBInterface::commit TRANSID-bd33fef8bbcb7b0436b2257ef248070b:Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-bd33fef8bbcb7b0436b2257ef248070b.
"
I am at a complete loss as to why this is happening on individual content objects and not others. Also I can't seem to see what class or file that sql query is coming from so I can't even work out what file there might be an error in.Though removal is working fine on other content objects on the site..... Any help is greatly appreciated!!
Cheers
Dan
|
|
Robin Muilwijk
|
Friday 12 August 2011 12:13:26 pm
Hi, I'm no expert, but I would check two things. Permissions on the var folder where the image yellow.jpg is being moved. And also the existence of that path and same image. Regards Robin
Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.
LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk
|
|
Fou Jino
|
Monday 15 August 2011 11:03:58 pm
Hey, After to pass eZ Publish 2011.7, I have the same problem that Daniel, the same error when I want to remove a specifi datatype, someone has a solution ? Thanks in advance !
Foujino ~ http://www.foujino-blog.be
|
|
Robin Muilwijk
|
Tuesday 16 August 2011 11:17:53 am
"
Hey, After to pass eZ Publish 2011.7, I have the same problem that Daniel, the same error when I want to remove a specifi datatype, someone has a solution ? Thanks in advance !
"
Hi, Which datatype did you try to remove? I'll try and get it confirmed once you let me know, might be a bug we need to add to http://issues.ez.no. -- Robin
Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.
LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk
|
|
Nicolas Pastorino
|
Tuesday 16 August 2011 1:40:28 pm
Hi Daniel, Fou, Are you guys working on brand new installations of eZ Publish Community Project 2011.7, or results of upgrades from previous versions ? Given the log posted, the ezimage datatype could be at the source of these errors. Can you confirm or invalidate that this is happening only with objects containing an attribute of the 'ezimage' datataype ? I just tried locally on a fresh install : all is working correctly. Last check : in case eZ Find is enabled, is the 'ezfind_elevate_configuration' table present ? (the SQL dump can be found in 'extension/ezfind/sql/mysql/mysql.sql' ).
Let us know how things go,
Cheers,
--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board
eZ Publish Community on twitter: http://twitter.com/ezcommunity
t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye
|
|
Fou Jino
|
Tuesday 16 August 2011 11:12:25 pm
Hi Robin, Nicolas, @Robin : it's a custom datatype, a container with per example an attribute image @Nicolas : yes it's the eZ Publish Community Project 2011.7, not a new install, I upgrade the previous version (4.5) and upgrade the database. If I want to delete a another datatype it's works but not for this datatype :s eZ Find is disable, and so I have not the ezfind_elevate_configuration table, I must to enable ?
Foujino ~ http://www.foujino-blog.be
|
|
Fou Jino
|
Tuesday 16 August 2011 11:25:39 pm
@Nicolas, I confirm, this problem happens onyl with a datatype with ezimage attribute :s
Foujino ~ http://www.foujino-blog.be
|
|
Robin Muilwijk
|
Monday 22 August 2011 11:32:51 am
Nicolas, what's your take on this? It's beyond my experience with eZ I'm afraid.
Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.
LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk
|
|
Nicolas Pastorino
|
Thursday 25 August 2011 2:18:29 am
Hi Guys, I think we can call this a bug. @Fou, Daniel : could you guys please report an issue for this, here : http://issues.ez.no/ezpublish . Feel free to link to this forum thread, where some troublehsooting already happened.
Thanks in advance !
Cheers,
--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board
eZ Publish Community on twitter: http://twitter.com/ezcommunity
t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye
|