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?

CommentFileSizeAuthor
#9 emfield-592284.patch8.03 KBjonskulski
#5 snapshot11.png76.94 KBskizzo

Comments

snorkers’s picture

snorkers commented

Quick update the #1... my video nodes still work, however reference to a Video content type in Views is badly broken.

snorkers’s picture

snorkers commented
Status: Active » Closed (fixed)

Sorry my bad

aaron’s picture

aaron commented

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

aaron’s picture

aaron commented
Status: Closed (fixed) » Active

re-opening; i've gotten another report of the errors on update... :(

skizzo’s picture

skizzo commented
Status: Active » Closed (fixed)
StatusFileSize
new snapshot11.png76.94 KB

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.
aaron’s picture

aaron commented
Status: Closed (fixed) » Active
aaron’s picture

aaron commented

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

aaron’s picture

aaron commented
Status: Active » Fixed

OK, this is fixed. will reroll a new release as soon as i look into another problem.

jonskulski’s picture

jonskulski commented
StatusFileSize
new emfield-592284.patch8.03 KB

Here is the patch in question.

quality module, btw. really digging it :)

snorkers’s picture

snorkers commented

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.

aaron’s picture

aaron commented

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...

venusrising’s picture

venusrising commented

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.

venusrising’s picture

venusrising commented
venusrising’s picture

venusrising commented
Status: Fixed » Active

Okay for anyone having this issue I fixed by:
Deleting entire module folder
Un tar 6.x1.10 and updating-voila' no more errors.

alex ua’s picture

alex ua commented
Status: Active » Closed (fixed)

Closing- this has long been fixed.