Implementation of yii2-starter-kit and the process of installing yii2-starter-kit under Windows 10 and Nginx 1.10

1. Install yii2-starter-kit under Windows 10 and Nginx 1.10, and run on the command line: php console/yii app/setup, as shown in Figure 1

Install yii2-starter-kit and run on the command line: php console/yii app/setup

2. Error: create unique index IDx_article_slug on {{%article}} (slug) …exception: sqlstate[42000]: Syntax error or access Violation: 1071 specific key was too long; max key length is 767 bytes, as shown in Figure 2
Translation: create unique index idx_article_slug on {{%article}} (slug)…Exception: SQLState[42000]: syntax error or access conflict: the key specified by 1071 is too long; the maximum key length is 767 bytes

Syntax Error or Access Violation: 1071 specific key was too long; max key length is 767 bytes

3. Failed to establish the index IDX_article_slug on the field slug, as shown in Figure 3

SQL: ALTER TABLE `Article ` add UNIQUE index `idx_article_slug` (`slug`)
#1071 – specific key was too long; max key length is 767 bytes

Failed to establish index idx_article_slug on field slug

4. Find the slug fields of the two tables {{%article_category}} and {%article}}, and change the length to 255, because both tables have index-building operations, as shown in Figure 4

Find the slug fields of the two tables {{%article_category}} and {%article}} and change the length to 255

5. Clear the database and run it again on the command line: php console/yii app/setup, the prompt has been successfully migrated, as shown in Figure 5

Clear the database and run it again on the command line: php console/yii app/setup, prompting successfully migrated

6. Open the foreground application and report an error: symlink(): cannot create symlink, error code (1314), as shown in Figure 6

Open the foreground application and report an error: symlink(): cannot create symlink, error code(1314)

7. Since the development environment does not support symlink(), it is decided to setLinkssets=> true, edit the file: .dev, as shown in Figure 7
link_assets=false

Since the development environment does not support symlink(), it is decided to setLinkssets=> true, edit file: .dev

8. The front desk application can be opened normally, as shown in Figure 8

The foreground application can be opened normally

9. Open the page and return to 404, as shown in Figure 9

Open about the page and return to 404

10. The reason for the analysis is that pseudo-static is enabled, but nginx is not supported, edit nginx.conf, as shown in Figure 10
try_files $uri $uri/ /index.php?$args;

The reason for the analysis is that pseudo-static is enabled, but nginx is not supported, edit nginx.conf

11. Open the page again, normal, as shown in Figure 11

Open the page again, it’s normal

12. Open the background application, normal, as shown in Figure 12

Open the background application, it is normal

13. Another solution for point 7, you can run as an administrator, start the console, and you can solve the problem of not supporting symlink(), such as

Figure 13