MySQL cannot create a innodb table

MySQL 5.5.38 does not table create a InnoDB table. There's no foreign key problem.

1. Error hints



2, some configuration

Reply to discussion (solution)

You've created MyISAM's shopnc_activity.
Of course, you can't create InnoDB's shopnc_activity anymore.

You've created MyISAM's shopnc_activity.
Of course, you can't create InnoDB's shopnc_activity anymore.

No, I've removed the Mysiam.

General MySQL Error 1005 is said to be a foreign key type errors.

You can put all the SQL you've built on the table and look at it.

General MySQL Error 1005 is said to be a foreign key type errors.

You can put all the SQL you've built on the table and look at it.

There's no foreign key.

In addition, it has been resolved
Server technician Toss it, and then you can.
Probably so, the original is the tool created by the host, and later created with phpMyAdmin import can, do not know why

