Category: Laravel 6
-
Post Views: 18 1. The existing code is implemented as follows 2. The interface response structure is as follows, as shown in Figure 1 3. It is expected to put some fields in the field Theme_Installation into the first level, that is, level with the ID, and finally delete the Theme_Installation. 4. The final implementation code is as follows 5.…
-
Post Views: 24 1. The correlation of the model Theme is as follows 2. The correlation of the model ThemeInstallation is as follows 3. Error when obtaining the associated attribute: sqlstate[42S02]: base table or view not found: 1146 tableObject_wp.wp_theme_installationdoesn’tt exist . as shown in Figure 1 4. The table Theme_Installation does not exist in object_wp.wp_theme_installation, but actually exists in…
-
Post Views: 18 1. In the startup script of the docker container, if you want to force the migration command to run without prompt, use the –force parameter 2. At this stage, there is a module developed based on Laravel Modules, and there are migration files, such as: /modules/themestoredb/database/migrations . as shown in Figure 1 3. In the local development…
-
Post Views: 19 1. When performing database migration, an error is reported: sqlstate[42000]: Syntax Error or Access Violation: 1059 Identifier nametheme_installation_version_preset_theme_store_theme_version_id_indexis too long. as shown in Figure 1 The index length limit of MySQL 5.7 defaults to 64, while the length of the Theme_Installation_Version_Preset_Theme_Store_Theme_Version_ID_Index is 68. as shown in Figure 2 3. In Laravel 6, each indexing method accepts an…
-
Post Views: 18 1. In Laravel 6’s database migration, when adding a foreign key constraint, Illuminate\Database\QueryException : SQLState[HY000]: General error: 1215 Cannot add foreign key constraint. as shown in Figure 1 2. The code is implemented as follows 3. The code is adjusted as follows, and the error is still reported: 4. The field ASSET_ID type of the table Theme_Asset_Version…
-
Post Views: 19 1. Now the field Theme_Asset of the table Theme_Asset is of type VARCHAR(255). The previous migration code is as follows. as shown in Figure 1 2. Now plan to add a new migration file to modify the type of the field Theme_id is: UUID, that is, char(36). 3. Error: Doctrine\DBAL\Exception : Unknown column type “UUID” requested. As…
-
Post Views: 19 1. Now trying to download the remote zip file to the server. Remote file URL:https://www.shuijingwanwq.com/wp-content/uploads/2021/07/两位老人被两只狗给撞了.wmv 2. Reference:https://guzzle-cn.readthedocs.io/zh_CN/latest/request-options.html#sink. Declare the body part where the response will be saved. as shown in Figure 1 3. Reference:https://www.shuijingwanwq.com/2020/11/26/4627/. The resources returned by fopen() will be written to the PHP stream in response 4. Throw an exception: fopen(e:\wwwroot\object\storage/theme_down loads/2022/05/19/1652927525.7561.1655422634.zip): Failed to open…
-
Post Views: 20 1. Use the following Artisan command to generate a new queue task for the specified module. as shown in Figure 1 2. Task distribution, push tasks to the queue 3. Edit /modules/themestoredb/jobs/themeinstallation.php . The processing example in the queue is mainly to change the value of the field step of the table Theme_Installation_Task to 2. 4. Start…
-
Post Views: 22 1. Now for an API, 4 tables need to be inserted. The 1st table is the table in database A, and the other 3 tables are the table in database B, and the primary key of the 1st table will be inserted into the 2nd table. 2 database connections have been configured. are WordPress and DB respectively.…