I was getting array_flip warnings and decided to update from 7.x-2.1-alpha2 to 7.x-2.1-alpha3 and it failed during the database update, I get the following error. I also updated the video_embeded module it had no errors

video module
Update #7202

Failed: DatabaseSchemaObjectDoesNotExistException: Cannot add field video_queue.duration: table doesn't exist. in DatabaseSchema_mysql->addField() (line 321 of /home/content/36/7573736/html/drupal/includes/database/mysql/schema.inc).

Now when I open video nodes I no longer see the array_flip warnings but I see (notice the vidoe as opposed to video)

Notice: Undefined property: stdClass::$field_vidoe_upload_thumbnail in field_sql_storage_field_storage_load() (line 337 of /home/content/36/7573736/html/drupal/modules/field/modules/field_sql_storage/field_sql_storage.module).

I tried searching for the term vidoe in the some of the video module files but I did not find it.

Also when I edit a video I get the following (again vidoe in several places)

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_vidoe_upload_thumbnail' in 'field list': INSERT INTO {field_data_field_vidoe_upload} (entity_type, entity_id, revision_id, bundle, delta, language, field_vidoe_upload_fid, field_vidoe_upload_thumbnail) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 29 [:db_insert_placeholder_2] => 29 [:db_insert_placeholder_3] => fitness_video [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => en [:db_insert_placeholder_6] => 13 [:db_insert_placeholder_7] => 21 ) in field_sql_storage_field_storage_write() (line 425 of /home/content/36/7573736/html/drupal/modules/field/modules/field_sql_storage/field_sql_storage.module).

Comments

LTech’s picture

I also get this error when trying to upgrade

hypertext200’s picture

please note that we cannot upgrade from 7.x-1.x version.

dvales’s picture

Turns out the "vidoe" mispeilling is my own field in a custom content type (amazing how a little sleep clears your head). To get around this I manually created the video_queue table, using the information in video_install. I then went back in and editted the content type and the field in question, I did not change anything just saved both the field and the content type. I no longer get the PDOException and I can now view videos and best of all my original array_flip issues are also gone

SPoke to soon the error is back must of been a fluke that it did not display previously. Luckly the site is not live and I can delete the existing videos and add them back in to see if that works, I'll try that tonight

hypertext200’s picture

I do not understand it should work properly for 7.x-2.x version and this upgrade only for 7.x-2.x.

dvales’s picture

I deleted the videos and added them back in and I know longer get the PDOException, Now I just need to fix the treancode issue. Thanks
This can be closed as a user error. I did not install the original video module. There may have been undelying issues.

LTech’s picture

I'm trying to update from 7.x-2.1-alpha2 and when I run update.php it says 'pending update' 1 PENDING UPDATE
video module
7202 - Alter video_queue table to add video duration.
I click 'apply pending update' and I get the error:
The following updates returned messages

video module

Update #7202
Failed: DatabaseSchemaObjectDoesNotExistException: Cannot add field video_queue.duration: table doesn't exist. in DatabaseSchema_mysql->addField() (line 320 of /home/jspcaorg/public_html/includes/database/mysql/schema.inc).
There is no spelling error so it may be a different issue then in #5. Should I open a new issue?
Any idea why I get this error?

LTech’s picture

I'm trying to delete a node that has a video and I get the error:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '_drp.video_queue' doesn't exist: DELETE FROM {video_queue} WHERE (fid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 25 ) in video_file_delete() (line 176 of /home/public_html/sites/all/modules/video/video.module).
It seems there is something wrong with my database? What is going on?

dvales’s picture

LTech

You have the same problem I had you are missing the video_queue table.
I can't speak to why you don't have the table but I was able to get around these errors by manually creating the missing video_queue table, the table's structure can be found in the video.install file in the video module's directory. You can use straight sql "create table.." or tools like phpmyadmin. I'm new to Drupal so I don't kinow if there is a simple way to force the execution of the install procedures. Off the top of my head theres is probably a way to call the modules install function (hook?) from within a php block. After creating the table you will still see errors on deletion since the table will not have entries for existing videos, but the videos will be deleted.

LTech’s picture

Thanks so much, that was REALLY helpful. The problem is solved.

hypertext200’s picture

Please let me know more information to reproduce this error. Did you install fresh video module install? or upgrade from 7.x-1.x version?

LTech’s picture

I upgraded

hypertext200’s picture

Upgrade from which version?

hypertext200’s picture

Status: Active » Closed (works as designed)
hypertext200’s picture

Issue summary: View changes

Notices another error message while editing a video