modules disabled after update from 0.28 to 0.29
I had to manually enable modules like "Throttle" and "Calendar" etc. after the recent update and was kind of surprised by this since this has not been the case with other updates before - unless this has slipped my mind. I also had to rebuild rights after the update. Did anyone experience the same or did I screw something up here?
Cheers
xtian
When configuring fields for stories I keep getting the following warnings:
- user warning: 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 'WHERE key_name = 'field_source_nid'' at line 1 query: SHOW INDEX FROM content_field_source WHERE key_name = 'field_source_nid' in /home/grafkobv/www.xy.com/profiles/prosepoint/modules/cck/content.module on line 2069.
- user warning: Duplicate key name 'field_source_nid' query: ALTER TABLE content_field_source ADD INDEX field_source_nid (field_source_nid) in /home/grafkobv/www.xy.com/includes/database.mysql-common.inc on line 434.
What can I do about this? Thanks for any help.
xtian
Strange, and a bit worrying. That affected module wasn't changed between 0.28 and 0.29.
Do you have a backup of your site before the upgrade? If so, a rollback might be the safest path.
But I'd like to ask a few things first ...
Did you run update.php at the end of your upgrade?
Does this seem to affect any other part of your site besides configuring fields for the story content type? Or is your site otherwise working okay?
Do you remember what you tried to change when configuring story fields?
At worst case, if you don't have a backup, I may have to look at the database in detail to be able to say any more.
Hi beng,
Thanks for your quick reply. To get started, yes, there is a backup (files and database).
Regarding the upgrade: I did run update.php and went through the different steps as usual. Everything looked perfectly alright then. In the meantime I have made another backup and ran through the database update process again after manually upgrading extra modules (except CCK and views according to your warning!)
The image field seems to be affected, too. There are problems including images in stories. The upload does look alright in the first place with the thumbnail in the first pop-up but the pic shows up neither in the second ("Edit inserted image node") pop-up window nor in the story. After saving the story you have to run through the process of including the image again ("Start over") to successfully include the picture.
Subtitle, "by", and "from" fields in new stories show in the preview but do not seem to be saved. When opening the story in edit mode after saving, these fields are empty. Filling them out and saving them for a second time seems to work fine though. The system seems to run fine otherwise.
Configuring story fields (/admin/content/node-type/story/display): I think I changed the teaser settings from "inline" to "on top" but the warnings are given out with any change in settings here.
I would be glad to provide database access as a rollback would mean loss of all data since the backup.
Thanks for your help
Regards
xtian
Hi,
How certain are you that these problems did not exist before your upgrade to 0.29? The reason I ask is that 0.28 and 0.29 differ by very little, and my initial suspicion is that something else is the issue (or perhaps a slightly botched upgrade may have caused it).
Hmmm ... if I'm going to have a close look at your site, I'm going to have to find time to do it :(
Hello,
In the meantime I had to roll back the production site to the 0.28 backup version. Here the problems dewcribed do not exist. Several attempts to come to grips with the upgraded version had failed. For example I set up a brand new 0.29 version with a copy of the database - without success.
B.t.w.: I still have the 0.29 version with the problems on a different domain so if you want to take a closer look at it, I will be happy to provide FTP and database access. It would of course be more than interesting to figure out the problems.
Best regards
xtian

Hmmm... I'm tempted to say it slipped your mind, because 0.28 and 0.29 are very similar enough that there are no special instructions in this upgrade that would enable or disable any modules. Still, if other people also report this, I'd be very surprised, and also very curious.