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
Comment #1
LTech commentedI also get this error when trying to upgrade
Comment #2
hypertext200please note that we cannot upgrade from 7.x-1.x version.
Comment #3
dvales commentedTurns 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
Comment #4
hypertext200I do not understand it should work properly for 7.x-2.x version and this upgrade only for 7.x-2.x.
Comment #5
dvales commentedI 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.
Comment #6
LTech commentedI'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?
Comment #7
LTech commentedI'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?
Comment #8
dvales commentedLTech
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.
Comment #9
LTech commentedThanks so much, that was REALLY helpful. The problem is solved.
Comment #10
hypertext200Please let me know more information to reproduce this error. Did you install fresh video module install? or upgrade from 7.x-1.x version?
Comment #11
LTech commentedI upgraded
Comment #12
hypertext200Upgrade from which version?
Comment #13
hypertext200Comment #13.0
hypertext200Notices another error message while editing a video