Posted by snorkers on September 30, 2009 at 5:37pm
6 followers
| Project: | Embedded Media Field |
| Version: | 6.x-1.8 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Getting dizzy keeping up with the emfield updates in past week! Good to know you're on top of things, but during the update from 1.7 to 1.8 got the following errors:
* user warning: Unknown column 'field_res_extvid_duration' in 'where clause' query: SELECT COUNT(*) FROM content_field_res_extvid WHERE field_res_extvid_duration = 0 in \sites\all\modules\emfield\contrib\emvideo\emvideo.install on line 395.
* user warning: Unknown column 'field_res_extvid_duration' in 'where clause' query: SELECT * FROM content_field_res_extvid WHERE vid > 0 AND field_res_extvid_duration = 0 ORDER BY nid ASC LIMIT 0, 50 in \sites\all\modules\emfield\contrib\emvideo\emvideo.install on line 402.
* user warning: Unknown column 'field_video_link_duration' in 'where clause' query: SELECT COUNT(*) FROM content_type_video WHERE field_video_link_duration = 0 in \sites\all\modules\emfield\contrib\emvideo\emvideo.install on line 395.
* user warning: Unknown column 'field_video_link_duration' in 'where clause' query: SELECT * FROM content_type_video WHERE vid > 0 AND field_video_link_duration = 0 ORDER BY nid ASC LIMIT 0, 50 in \sites\all\modules\emfield\contrib\emvideo\emvideo.install on line 402.
* user warning: Unknown column 'field_video_third_duration' in 'where clause' query: SELECT COUNT(*) FROM content_type_video WHERE field_video_third_duration = 0 in \sites\all\modules\emfield\contrib\emvideo\emvideo.install on line 395.
* user warning: Unknown column 'field_video_third_duration' in 'where clause' query: SELECT * FROM content_type_video WHERE vid > 0 AND field_video_third_duration = 0 ORDER BY nid ASC LIMIT 0, 50 in \sites\all\modules\emfield\contrib\emvideo\emvideo.install on line 402.Not quite sure what these queries are doing, as the the other DELETE/UPDATE operations seem to be fine during update. However, it looks as though the new columns are not being inserted into the emvideo tables during the update. So I went back and reran update 6011 separately in case that was the problem: the tables are still not being updated and I get the same error...
Should I just manually insert these columns into MySQL, or is the failure indicative of another error somewhere?
Any thoughts, or is this just me?
Comments
#1
Quick update the #1... my video nodes still work, however reference to a Video content type in Views is badly broken.
#2
Sorry my bad
#3
sorry about all the updates. i wouldn't have created one, except there was a problem affecting a lot of folks w/ shadowbox in 1.6.
how was the problem your bad? i want to make sure folks aren't having this problem, and need to see if there was a problem in the update.
thanks,
aaron
#4
re-opening; i've gotten another report of the errors on update... :(
#5
I stepped into update problems too(6.x.1.7 to 6.x.1.8). Drush update hanged
Unknown column 'field_emb_videofield_00_duration' in 'where clause' query: SELECT COUNT(*) FROM content_field_emb_videofield_00 WHERE field_emb_videofield_00_duration = 0 in /var/www/drupal/sites/all/modules/emfield/contrib/emvideo/emvideo.install on line 395.
Unknown column 'field_emb_videofield_00_duration' in 'where clause' query: SELECT * FROM content_field_emb_videofield_00 WHERE vid > 0 AND field_emb_videofield_00_duration = 0 ORDER BY nid ASC LIMIT 0, 50 in /var/www/drupal/sites/all/modules/emfield/contrib/emvideo/emvideo.install on line 402.
Unknown column 'field_emb_videofield_01_version' in 'field list' query: UPDATE content_type_video_item SET field_emb_videofield_01_version = 3 WHERE vid = 4495 in /var/www/drupal/sites/all/modules/emfield/emfield.install on line 179.
#6
#7
notes while i sort this out:
that particular update is trying to add a new column to a cck field, and then populating the item. i'm creating the column by defining it in the module, then calling content_clear_type_cache(TRUE); and content_associate_fields('emvideo'); but it doesn't seem to take before the batch run to populate the new column
#8
OK, this is fixed. will reroll a new release as soon as i look into another problem.
#9
Here is the patch in question.
quality module, btw. really digging it :)
#10
Sorry - I'd closed the issue as I'd realised the CCK type was at fault too (kinda unrelated) and thought it was my error, so wanted to check things out a little more thoroughly before putting other users and the maintainers into a flatspin... however *relieved* it wasn't what I'd thought it was.
Loving the emfield rollercoaster this week. Frequent updates are a good thing - shows the module's being used, is growing and being looked after well.
#11
thanks for the kind words and optimistic outlook. :D and i'm glad folks are looking over my shoulder -- i think it wasn't 30 minutes after i rolled the bad update before i had 3 notifications about it... it ran fine on my original installation because i got lazy and forgot to restore my db and try it again. that'll teach me...
#12
User Warning on Upgrades
* user warning: Unknown column 'field_video_duration' in 'where clause' query: SELECT COUNT(*) FROM content_type_xxx WHERE field_video_duration = 0 in /home/xxxxxx/html/sites/all/modules/emfield/contrib/emvideo/emvideo.install on line 395.
* user warning: Unknown column 'field_video_duration' in 'where clause' query: SELECT * FROM content_type_wack WHERE vid > 0 AND field_video_duration = 0 ORDER BY nid ASC LIMIT 0, 50 in /home/xxxxx/html/sites/all/modules/emfield/contrib/emvideo/emvideo.install on line 402.
#13
#14
Okay for anyone having this issue I fixed by:
Deleting entire module folder
Un tar 6.x1.10 and updating-voila' no more errors.
#15
Closing- this has long been fixed.