Laravel 8.x 部署至 Heroku，执行数据库数据填充时，报错：Class “Faker\Factory” not found
1、Laravel 8.x 部署至 Heroku，执行数据库数据填充时，报错：Class “Faker\Factory” not found。如图1
图1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | PS E:\wwwroot\weibo> heroku run php artisan migrate:refresh --seed » Warning: heroku update available from 7.53.0 to 7.59.2.Running php artisan migrate:refresh --seed on ⬢ app-wangqiang-weibo... up, run.5843 (Free)*************************************** Application In Production! *************************************** Do you really wish to run this command? (yes/no) [no]:Rolling back: 2021_12_24_062642_add_is_admin_to_users_tableRolled back: 2021_12_24_062642_add_is_admin_to_users_table (18.92ms)Rolling back: 2019_12_14_000001_create_personal_access_tokens_tableRolling back: 2019_08_19_000000_create_failed_jobs_tableRolled back: 2019_08_19_000000_create_failed_jobs_table (25.62ms)Rolling back: 2014_10_12_100000_create_password_resets_tableRolled back: 2014_10_12_100000_create_password_resets_table (10.26ms)Rolling back: 2014_10_12_000000_create_users_tableRolled back: 2014_10_12_000000_create_users_table (26.54ms)Migrating: 2014_10_12_000000_create_users_tableMigrated: 2014_10_12_000000_create_users_table (46.62ms)Migrating: 2014_10_12_100000_create_password_resets_tableMigrated: 2014_10_12_100000_create_password_resets_table (17.96ms)Migrating: 2019_08_19_000000_create_failed_jobs_tableMigrated: 2019_08_19_000000_create_failed_jobs_table (29.18ms)Migrating: 2019_12_14_000001_create_personal_access_tokens_tableMigrated: 2019_12_14_000001_create_personal_access_tokens_table (28.13ms)Migrating: 2021_12_24_062642_add_is_admin_to_users_tableMigrated: 2021_12_24_062642_add_is_admin_to_users_table (7.20ms)Seeding: Database\Seeders\UsersTableSeederIn DatabaseServiceProvider.php line 91: Class "Faker\Factory" not found |
2、编辑 composer.json ，将 “require-dev” 中的 “fakerphp/faker” 复制到 “require” 里面。如图2
图2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | "require": { "php": "^7.3|^8.0", "fruitcake/laravel-cors": "^2.0", "guzzlehttp/guzzle": "^7.0.1", "laravel/framework": "^8.65", "laravel/sanctum": "^2.11", "laravel/tinker": "^2.5", "overtrue/laravel-lang": "~4.0", "fakerphp/faker": "^1.9.1"},"require-dev": { "facade/ignition": "^2.5", "fakerphp/faker": "^1.9.1", "laravel/sail": "^1.0.1", "laravel/ui": "^3.0", "mockery/mockery": "^1.4.4", "nunomaduro/collision": "^5.10", "phpunit/phpunit": "^9.5.10"}, |
3、如果有可能影响到本地环境的程序运行，建议在 Sail 环境中执行相应命令：sail composer update。如图3
图3
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | wangqiang@DESKTOP-QLPK8QM:/mnt/e/wwwroot/weibo$ sail composer updateLoading composer repositories with package informationUpdating dependenciesLock file operations: 0 installs, 3 updates, 0 removals - Upgrading facade/ignition (2.17.2 => 2.17.3) - Upgrading laravel/framework (v8.76.2 => v8.77.1) - Upgrading laravel/ui (v3.4.0 => v3.4.1)Writing lock fileInstalling dependencies from lock file (including require-dev)Package operations: 0 installs, 3 updates, 0 removals - Downloading laravel/framework (v8.77.1) - Downloading facade/ignition (2.17.3) - Downloading laravel/ui (v3.4.1) - Upgrading laravel/framework (v8.76.2 => v8.77.1): Extracting archive - Upgrading facade/ignition (2.17.2 => 2.17.3): Extracting archive - Upgrading laravel/ui (v3.4.0 => v3.4.1): Extracting archivePackage swiftmailer/swiftmailer is abandoned, you should avoid using it. Use symfony/mailer instead.Generating optimized autoload files> Illuminate\Foundation\ComposerScripts::postAutoloadDump> @php artisan package:discover --ansiDiscovered Package: facade/ignitionDiscovered Package: fruitcake/laravel-corsDiscovered Package: laravel/sailDiscovered Package: laravel/sanctumDiscovered Package: laravel/tinkerDiscovered Package: laravel/uiDiscovered Package: nesbot/carbonDiscovered Package: nunomaduro/collisionDiscovered Package: overtrue/laravel-langPackage manifest generated successfully.78 packages you are using are looking for funding.Use the `composer fund` command to find out more!> @php artisan vendor:publish --tag=laravel-assets --ansi --forceNo publishable resources for tag [laravel-assets].Publishing complete.wangqiang@DESKTOP-QLPK8QM:/mnt/e/wwwroot/weibo$ sail composer dump-autoloadGenerating optimized autoload files> Illuminate\Foundation\ComposerScripts::postAutoloadDump> @php artisan package:discover --ansiDiscovered Package: facade/ignitionDiscovered Package: fruitcake/laravel-corsDiscovered Package: laravel/sailDiscovered Package: laravel/sanctumDiscovered Package: laravel/tinkerDiscovered Package: laravel/uiDiscovered Package: nesbot/carbonDiscovered Package: nunomaduro/collisionDiscovered Package: overtrue/laravel-langPackage manifest generated successfully.Generated optimized autoload files containing 5031 classeswangqiang@DESKTOP-QLPK8QM:/mnt/e/wwwroot/weibo$ |
4、再次推送至 Heroku，执行填充，不再报错。如图4
图4
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 | PS E:\wwwroot\weibo> git push heroku mainEnumerating objects: 5, done.Counting objects: 100% (5/5), done.Delta compression using up to 4 threadsCompressing objects: 100% (3/3), done.Writing objects: 100% (3/3), 735 bytes | 735.00 KiB/s, done.Total 3 (delta 2), reused 0 (delta 0), pack-reused 0remote: Compressing source files... done.remote: Building source:remote:remote: -----> Building on the Heroku-20 stackremote: -----> Using buildpack: heroku/phpremote: -----> PHP app detectedremote: -----> Bootstrapping...remote: -----> Installing platform packages...remote: - php (8.1.1)remote: - ext-mbstring (bundled with php)remote: - composer (2.1.14)remote: - apache (2.4.51)remote: - nginx (1.20.2)remote: -----> Installing dependencies...remote: Composer version 2.1.14 2021-11-30 10:51:43remote: Installing dependencies from lock fileremote: Verifying lock file contents can be installed on current platform.remote: Package operations: 73 installs, 0 updates, 0 removalsremote: - Downloading fakerphp/faker (v1.17.0)remote: - Downloading laravel/framework (v8.77.1)remote: - Installing doctrine/inflector (2.0.4): Extracting archiveremote: - Installing doctrine/lexer (1.2.1): Extracting archiveremote: - Installing symfony/polyfill-ctype (v1.23.0): Extracting archiveremote: - Installing webmozart/assert (1.10.0): Extracting archiveremote: - Installing dragonmantank/cron-expression (v3.1.0): Extracting archiveremote: - Installing symfony/deprecation-contracts (v3.0.0): Extracting archiveremote: - Installing psr/container (1.1.2): Extracting archiveremote: - Installing fakerphp/faker (v1.17.0): Extracting archiveremote: - Installing symfony/polyfill-php80 (v1.23.1): Extracting archiveremote: - Installing symfony/polyfill-php73 (v1.23.0): Extracting archiveremote: - Installing symfony/polyfill-mbstring (v1.23.1): Extracting archiveremote: - Installing symfony/http-foundation (v5.4.1): Extracting archiveremote: - Installing psr/event-dispatcher (1.0.0): Extracting archiveremote: - Installing symfony/event-dispatcher-contracts (v3.0.0): Extracting archiveremote: - Installing symfony/event-dispatcher (v6.0.1): Extracting archiveremote: - Installing symfony/var-dumper (v5.4.1): Extracting archiveremote: - Installing psr/log (2.0.0): Extracting archiveremote: - Installing symfony/error-handler (v5.4.1): Extracting archiveremote: - Installing symfony/http-kernel (v5.4.1): Extracting archiveremote: - Installing voku/portable-ascii (1.5.6): Extracting archiveremote: - Installing phpoption/phpoption (1.8.1): Extracting archiveremote: - Installing graham-campbell/result-type (v1.0.4): Extracting archiveremote: - Installing vlucas/phpdotenv (v5.4.1): Extracting archiveremote: - Installing symfony/css-selector (v6.0.1): Extracting archiveremote: - Installing tijsverkoyen/css-to-inline-styles (2.2.4): Extracting archiveremote: - Installing symfony/routing (v5.4.0): Extracting archiveremote: - Installing symfony/process (v5.4.0): Extracting archiveremote: - Installing symfony/polyfill-php72 (v1.23.0): Extracting archiveremote: - Installing symfony/polyfill-intl-normalizer (v1.23.0): Extracting archiveremote: - Installing symfony/polyfill-intl-idn (v1.23.0): Extracting archiveremote: - Installing symfony/mime (v5.4.0): Extracting archiveremote: - Installing symfony/finder (v5.4.0): Extracting archiveremote: - Installing symfony/polyfill-intl-grapheme (v1.23.1): Extracting archiveremote: - Installing symfony/string (v6.0.1): Extracting archiveremote: - Installing symfony/service-contracts (v2.4.1): Extracting archiveremote: - Installing symfony/console (v5.4.1): Extracting archiveremote: - Installing symfony/polyfill-iconv (v1.23.0): Extracting archiveremote: - Installing egulias/email-validator (2.1.25): Extracting archiveremote: - Installing swiftmailer/swiftmailer (v6.3.0): Extracting archiveremote: - Installing symfony/polyfill-php81 (v1.23.0): Extracting archiveremote: - Installing ramsey/collection (1.2.2): Extracting archiveremote: - Installing brick/math (0.9.3): Extracting archiveremote: - Installing ramsey/uuid (4.2.3): Extracting archiveremote: - Installing psr/simple-cache (1.0.1): Extracting archiveremote: - Installing opis/closure (3.6.2): Extracting archiveremote: - Installing symfony/translation-contracts (v3.0.0): Extracting archiveremote: - Installing symfony/translation (v6.0.1): Extracting archiveremote: - Installing nesbot/carbon (2.55.2): Extracting archiveremote: - Installing monolog/monolog (2.3.5): Extracting archiveremote: - Installing league/mime-type-detection (1.9.0): Extracting archiveremote: - Installing league/flysystem (1.1.9): Extracting archiveremote: - Installing nette/utils (v3.2.6): Extracting archiveremote: - Installing nette/schema (v1.2.2): Extracting archiveremote: - Installing dflydev/dot-access-data (v3.0.1): Extracting archiveremote: - Installing league/config (v1.1.1): Extracting archiveremote: - Installing league/commonmark (2.1.0): Extracting archiveremote: - Installing laravel/serializable-closure (v1.0.5): Extracting archiveremote: - Installing laravel/framework (v8.77.1): Extracting archiveremote: - Installing asm89/stack-cors (v2.0.3): Extracting archiveremote: - Installing fruitcake/laravel-cors (v2.0.4): Extracting archiveremote: - Installing psr/http-message (1.0.1): Extracting archiveremote: - Installing psr/http-client (1.0.1): Extracting archiveremote: - Installing ralouphie/getallheaders (3.0.3): Extracting archiveremote: - Installing guzzlehttp/psr7 (2.1.0): Extracting archiveremote: - Installing guzzlehttp/promises (1.5.1): Extracting archiveremote: - Installing guzzlehttp/guzzle (7.4.1): Extracting archiveremote: - Installing laravel/sanctum (v2.13.0): Extracting archiveremote: - Installing nikic/php-parser (v4.13.2): Extracting archiveremote: - Installing psy/psysh (v0.10.12): Extracting archiveremote: - Installing laravel/tinker (v2.6.3): Extracting archiveremote: - Installing laravel-lang/lang (5.0.0): Extracting archiveremote: - Installing overtrue/laravel-lang (4.2.2): Extracting archiveremote: Package swiftmailer/swiftmailer is abandoned, you should avoid using it. Use symfony/mailer instead.remote: Generating optimized autoload filesremote: > Illuminate\Foundation\ComposerScripts::postAutoloadDumpremote: > @php artisan package:discover --ansiremote: Discovered Package: fruitcake/laravel-corsremote: Discovered Package: laravel/sanctumremote: Discovered Package: laravel/tinkerremote: Discovered Package: nesbot/carbonremote: Discovered Package: overtrue/laravel-langremote: Package manifest generated successfully.remote: 50 packages you are using are looking for funding.remote: Use the `composer fund` command to find out more!remote: -----> Preparing runtime environment...remote: -----> Checking for additional extensions to install...remote: -----> Discovering process typesremote: Procfile declares types -> webremote:remote: -----> Compressing...remote: Done: 23.2Mremote: -----> Launching...remote: Released v20remote: https://app-wangqiang-weibo.herokuapp.com/ deployed to Herokuremote:remote: Verifying deploy... done. 626a3e3..f5fb1ef main -> mainPS E:\wwwroot\weibo> heroku run php artisan migrate:refresh --seed » Warning: heroku update available from 7.53.0 to 7.59.2.Running php artisan migrate:refresh --seed on ⬢ app-wangqiang-weibo... up, run.2437 (Free)*************************************** Application In Production! *************************************** Do you really wish to run this command? (yes/no) [no]: > yesRolling back: 2021_12_24_062642_add_is_admin_to_users_tableRolled back: 2021_12_24_062642_add_is_admin_to_users_table (10.82ms)Rolling back: 2019_12_14_000001_create_personal_access_tokens_tableRolled back: 2019_12_14_000001_create_personal_access_tokens_table (15.24ms)Rolling back: 2019_08_19_000000_create_failed_jobs_tableRolled back: 2019_08_19_000000_create_failed_jobs_table (11.88ms)Rolling back: 2014_10_12_100000_create_password_resets_tableRolled back: 2014_10_12_100000_create_password_resets_table (10.93ms)Rolling back: 2014_10_12_000000_create_users_tableRolled back: 2014_10_12_000000_create_users_table (12.13ms)Migrating: 2014_10_12_000000_create_users_tableMigrated: 2014_10_12_000000_create_users_table (32.83ms)Migrating: 2014_10_12_100000_create_password_resets_tableMigrated: 2014_10_12_100000_create_password_resets_table (16.75ms)Migrating: 2019_08_19_000000_create_failed_jobs_tableMigrated: 2019_08_19_000000_create_failed_jobs_table (23.02ms)Migrating: 2019_12_14_000001_create_personal_access_tokens_tableMigrated: 2019_12_14_000001_create_personal_access_tokens_table (24.03ms)Migrating: 2021_12_24_062642_add_is_admin_to_users_tableMigrated: 2021_12_24_062642_add_is_admin_to_users_table (6.28ms)Seeding: Database\Seeders\UsersTableSeederSeeded: Database\Seeders\UsersTableSeeder (827.06ms)Database seeding completed successfully.PS E:\wwwroot\weibo> |
![在 Laravel 9 中使用原生表达查询时，报错：SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;。原因应该与 Hannah O' Conno 有关。其中存在 '](https://www.shuijingwanwq.com/wp-content/uploads/2024/04/1-520x233.png)
近期评论