Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
uc_shipping module
Update #7000
Failed: DatabaseSchemaObjectDoesNotExistException: Cannot add field uc_packages.label_image_id: table doesn't exist. in DatabaseSchema_mysql->addField() (line 325 of / . . . /includes/database/mysql/schema.inc).
What is the SQL Query to create the table manually ??? This can be fixed through PhPMyAdmin
Comments
Comment #1
TR CreditAttribution: TR commentedThe table schema is in the .install file, but you should probably figure out what went wrong rather than just manually creating the table. If the uc_packages table isn't found in the upgrade, that implies you didn't have the table on your D6 site. Which implies the uc_shipping module wasn't installed on your D6 site, which means that no update functions should have run on your D7 site. But if you did have uc_shipping installed on D6 and didn't have the uc_packages table, then your D6 install was corrupt. Regardless, make sure you always upgrade to the latest D6 -dev version on your D6 site before you try to upgrade to D7.
Comment #2
bobburns CreditAttribution: bobburns commentedFIXED
Yes I know that is where the uc_shipping install schema is located, and i know all of what you said - except some modules files were NOT the dev versions. I did not see that in the upgrade D6 to D7 notes on Drupal.org
Before I went hacking around trying to create my own SQL query to create the table and maybe made things worse - I figured it best to ask
I had the uc_shipping and uc_packages installed on D6 - they worked and if corrupted I do not know; the update.php dependency check reported all the latest files were installed and that the D6 version was current - and now the D6 installation is GONE and water over the dam so to speak - so I must move forward and I am here now and the only way I see to fix this is to manually create the table
This is a popular error problem it seems
I found your fix from https://www.drupal.org/node/1437368
I had to then also UNINSTALL two other modules,(mp-quote and package tracking - and the Fed Ex module it depends on) but update.php then worked to complete the D7 codebase upgrade
FIXED
Comment #3
TR CreditAttribution: TR commentedThanks for the follow-up, hope that helps someone else in a similar situation.