Chadduck Posted November 6, 2023 Posted November 6, 2023 In an effort to resolve the issues I am experiencing I performed a "Flush cache" Received a "Yii Migration Tool (based on Yii v2.0.48-dev) Total 41 new migrations to be applied: " Then received "Migration failed" What do I need to do? This was the "Flush cache" result printout System cache has been flushed Smarty cache flushed. Debug cache flushed. Image cache flushed Theme cache flushed Opcode cache flushed Hooks cache flushed App Shop Cache flushed Product Stock Cache flushed Cache for count of products in category flushed Yii Migration Tool (based on Yii v2.0.48-dev) Total 41 new migrations to be applied: m230721_163716_groups_sort_order m230724_055917_order_translates m230727_090538_order_translations m230731_142904_product_identifier_flags m230801_091937_add_asian_languages m230801_110343_featured_add_translate m230804_085614_address m230808_103013_order_translate m230809_075221_order_translate m230809_172247_shipping_carrier_pick_remove_old_translation m230810_142224_remove_referfriend_remains m230811_085653_search_settings_update m230811_154825_groups_products_sets_discount m230814_092348_add_dbg_consts m230814_095121_admin_email_login_confirmation_page m230815_084713_order_translate m230815_104408_coupon_updates m230816_132155_search_history m230816_142130_backend_search_settings_update m230816_163826_themes_oscomerce m230818_120111_hide_empty_brands m230820_181852_add_extension_overwrite_config_translate m230821_111027_order_translate m230821_125355_design_changes m230821_182640_themes_changes m230823_143022_acl m230830_232727_search_design m230906_091349_enlarge_values_field_in_orders_products_attributes m230906_115705_contact_us_enquiry_template m230913_081835_translate m230914_093529_main_styles m230915_104027_order_is_dropship m230915_171023_super_login_acl m230921_102015_currency_numeric_code m230921_103117_css_version m230925_104915_add_tax_rates_classes_switch_for_edit_order m231002_080841_translate m231003_101116_change_install_warning m231003_113102_translation_for_categories m231003_174343_translation_for_categories_fix m231010_144919_translate *** applying m230721_163716_groups_sort_order Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups' at line 1 The SQL being executed was: show FIELDS from groups (/apache/vhosts/store2/lib/vendor/yiisoft/yii2/db/Schema.php:676) #0 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/db/Command.php(1307): yii\db\Schema->convertException() #1 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/db/Command.php(1168): yii\db\Command->internalExecute() #2 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/db/Command.php(453): yii\db\Command->queryInternal() #3 /apache/vhosts/store2/lib/common/classes/Migration.php(191): yii\db\Command->queryColumn() #4 /apache/vhosts/store2/lib/console/migrations/m230721_163716_groups_sort_order.php(25): common\classes\Migration->isFieldExists() #5 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/db/Migration.php(114): m230721_163716_groups_sort_order->safeUp() #6 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(758): yii\db\Migration->up() #7 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(216): yii\console\controllers\BaseMigrateController->migrateUp() #8 [internal function]: yii\console\controllers\BaseMigrateController->actionUp() #9 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #10 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams() #11 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/console/Controller.php(180): yii\base\Controller->runAction() #12 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/base/Module.php(552): yii\console\Controller->runAction() #13 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction() #14 /apache/vhosts/store2/lib/backend/controllers/Cache_controlController.php(282): yii\console\Application->runAction() #15 [internal function]: backend\controllers\Cache_controlController->actionFlush() #16 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #17 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams() #18 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction() #19 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction() #20 /apache/vhosts/store2/lib/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest() #21 /apache/vhosts/store2/lib/backend/web/index.php(31): yii\base\Application->run() #22 /apache/vhosts/store2/admin/index.php(25): require('...') #23 {main} *** failed to apply m230721_163716_groups_sort_order (time: 0.007s) 0 from 41 migrations were applied. Migration failed. The rest of the migrations are canceled. Migration failed Quote
Chadduck Posted November 7, 2023 Author Posted November 7, 2023 RESOLVED The resolution - Because I NEVER know what to expect with the installation of any update I capture the screens, from start to finish and any printouts. Doing this saved my bacon on this issue. The pdf I created and then reviewed, revealed that the files shown above under the Yii Migration Tool migrations and not applied were files appearing in the update as having been added. In another topic posting @pandrei unknowingly identified the solution to my situation. That posting was Following the instructions he provided in that topic, RESOLVED my situation for the error of "Migration failed. The rest of the migrations are canceled. Migration failed" Should you be experiencing this or a similar issue CHECK your MySQL version My version of MySQL is 8.0.35-0ubuntu0.22.04.1 - (Ubuntu) BJ Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.