[SOLVED] Contentclass Attributes missing!

[SOLVED] Contentclass Attributes missing!

Tuesday 06 February 2007 7:41:18 pm - 5 replies

Modified on Tuesday 06 February 2007 8:46:46 pm by Nathan Kelly

Author Message

Nathan Kelly

Tuesday 06 February 2007 8:27:53 pm

Solved, The database connection was interrupted when I added my new attributes so only some of the new attributes were added. I had to manually edit the database to reset everything and now it's working fine.

Not fun when the DB connection fails in the middle of a big transaction.

Pardon me while I burst into flames...

Bruce Morrison

Tuesday 06 February 2007 9:29:37 pm

Hiya Nathan

Using the InnoDB storage engine and eZ transaction support should eliminate these issues.

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Nathan Kelly

Tuesday 06 February 2007 10:07:55 pm

Yeh, I don't know what happened but when I looked through the database some users had more values than others, but none of the existing users had all of the new attributes so you could literally see where the transaction stopped.

I have to tell you it had my blood pressure up for a minute, but after some tweaking I managed to resolve it, basically I removed the ghost entries from the contentclass_attributes table and the rest of the database seemed to sort itself out.

I''l keep in mind from now on that if I'm adding a large amount of attributes it might be safer to do so in smaller chunks.

Cheers!

Pardon me while I burst into flames...

SA SQLI

Thursday 08 February 2007 2:31:41 am

Hi,

I have the same problem, my user class has 30 attributes and I have deleted 5 of them.
The update process has crashed in the middle of the execution and now ez has some troubles.

The edit mode of the user class is correct (the 5 deleted attributes does not appear)
The edit mode of the user class is incorrect (the 5 deleted attributes always appear)
When I edit a new user, I always see all attributes including my 5 deleted attributes.
When I look my contentclass attributes, my 5 attributes does not appear in my new version user class.

What is wrong ? some ideas ?
What I have to do to restore my configuration without reload my database ?
What I have to check ?

Thanks for your help.
Johann

Claudia Kosny

Thursday 08 February 2007 3:38:58 am

Hi there

It sounds like Nathan might be able to help you to clean up your database manually.

If you know a bit of PHP and the way eZ works you can also adapt this script:
http://ez.no/community/contribs/hacks/update_class_from_command_line

to suit your needs. I once solved a problem quite similar to yours with it (although I had to fiddle around with a bit as I did not have a temporary class definition).

Good luck

Claudia

You must be logged in to post messages in this topic!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.