Re24: netccommons2からの移行
2022年1月20日 08時57分 [千寿福祉会]お世話になります。
早速git pullしました。
[connect-cms]$ git pull
remote: Enumerating objects: 17, done.
remote: Counting objects: 100% (17/17), done.
remote: Compressing objects: 100% (12/12), done.
remote: Total 17 (delta 6), reused 11 (delta 5), pack-reused 0
Unpacking objects: 100% (17/17), done.
From https://github.com/opensource-workshop/connect-cms
d6a4caf..a22557a master -> origin/master
* [new branch] fix_migration_view_count -> origin/fix_migration_view_count
Updating d6a4caf..a22557a
Fast-forward
.github/PULL_REQUEST_TEMPLATE.md | 1 +
app/Traits/Migration/MigrationTrait.php | 31 +++++++++++++++++++++----------
2 files changed, 22 insertions(+), 10 deletions(-)
[connect-cms]$ php -d allow_url_fopen=1 composer.phar install --no-dev
Installing dependencies from lock file
Verifying lock file contents can be installed on current platform.
Nothing to install, update or remove
Package swiftmailer/swiftmailer is abandoned, you should avoid using it. Use symfony/mailer instead.
Package sebastian/resource-operations is abandoned, you should avoid using it. No replacement was suggested.
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover --ansi
Discovered Package: fideloper/proxy
Discovered Package: intervention/image
Discovered Package: kalnoy/nestedset
Discovered Package: laravel/tinker
Discovered Package: laravelcollective/html
Discovered Package: nesbot/carbon
Package manifest generated successfully.
48 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
[connect-cms]$ php -d memory_limit=512M artisan command:ExportNc2 all redo
page_id,block_id,category,message
,,Start exportNc2.,
,,Start this->nc2ExportBasic.,
,,Start this->nc2ExportUploads.,
,,Start nc2ExportUsers.,
,,Start nc2ExportRooms.,
,,Start nc2ExportJournal.,
,,Start nc2ExportBbs.,
,,Start nc2ExportMultidatabase.,
,,Start nc2ExportRegistration.,
,,Start nc2ExportLinklist.,
,,Start nc2ExportWhatsnew.,
page_id,block_id,category,message
,,新着：未対応プラグイン,action_names = cabinet
,,新着：未対応プラグイン,action_names = multidatabase
,,新着：未対応プラグイン,action_names = cabinet
,,新着：未対応プラグイン,action_names = multidatabase
,,Start nc2ExportCabinet.,
,,Start nc2ExportCounter.,
,,Start nc2ExportCalendar.,
,,Start nc2ExportAbbreviateUrl.,
,,Page,page_id = 15
,,Page,page_id = 16
,,Page,page_id = 59
,,Page,page_id = 60
,,Page,page_id = 61
,,Page,page_id = 62
,,Page,page_id = 63
,,Page,page_id = 64
,,Page,page_id = 65
,,Page,page_id = 66
,,Page,page_id = 67
,,Page,page_id = 51
,,Page,page_id = 52
,,Page,page_id = 53
,,Page,page_id = 54
,,Page,page_id = 55
,,Page,page_id = 56
,,Page,page_id = 94
,,Page,page_id = 57
,,Page,page_id = 17
17,17,no migrate module,モジュール = iframe
,,Page,page_id = 18
,,Page,page_id = 93
,,Page,page_id = 20
,,Page,page_id = 21
,,Page,page_id = 22
,,Page,page_id = 95
,,データベースのソートが未対応順（カスタマイズ順）,nc2_multidatabase_block = 201
,,データベースのソートが未対応順（カスタマイズ順）,nc2_multidatabase_block = 178
,,Page,page_id = 23
,,Page,page_id = 82
,,Page,page_id = 96
,,Page,page_id = 97
,,Page,page_id = 98
,,Page,page_id = 83
,,Page,page_id = 91
,,Page,page_id = 99
,,Page,page_id = 100
,,Page,page_id = 81
81,124,no migrate module,モジュール = circular
,,Page,page_id = 90
90,182,no migrate module,モジュール = questionnaire
90,160,no migrate module,モジュール = photoalbum
[uguisuen@sv538 connect-cms]$ php artisan command:ImportSite all redo
page_id,block_id,category,message
,,importSite() Start.,
,,Basic import Start.,
,,uploads import Start.,
,,Users import Start.,
,,Blogs import Start.,
In Connection.php line 669:
SQLSTATE[HY000]: General error: 1364 Field 'view_count' doesn't have a defa
ult value (SQL: insert into `blogs` (`bucket_id`, `blog_name`, `use_like`,
`updated_at`, `created_at`) values (1, 法人からのお知らせ, 0, 2022-01-20 08
:48:34, 2022-01-20 08:48:34))
In Exception.php line 18:
SQLSTATE[HY000]: General error: 1364 Field 'view_count' doesn't have a defa
ult value
In PDOStatement.php line 117:
SQLSTATE[HY000]: General error: 1364 Field 'view_count' doesn't have a defa
ult value
[connect-cms]$
更新されましたが、同じでした。