WAVE 1.0.2 install/migration error
I get the following error while installing and migration of WAVE:
In Connection.php line 671:
SQLSTATE[HY000]: General error: 1553 Cannot drop index 'voyager_theme_options_voyager_theme_id_index': needed in a foreign key constraint (SQL: ALTER TABLE theme_options CHANGE voyager_theme_id theme_id INT UNSIGNED NOT NULL)
In PDOStatement.php line 129:
SQLSTATE[HY000]: General error: 1553 Cannot drop index 'voyager_theme_options_voyager_theme_id_index': needed in a foreign key constraint
In PDOStatement.php line 127:
SQLSTATE[HY000]: General error: 1553 Cannot drop index 'voyager_theme_options_voyager_theme_id_index': needed in a foreign key constraint
Any help?
Hi there,
I tried to recreate this problem at my end but it seems to be working as expected.
Are you using an existing database? If this is a new installation, I would recommend using a plain new database and as stated in the documentation just running:
composer install
php artisan migrate
php artisan db:seed
Also what is the exact command that you are running?
I've had the same issue. Using Mariadb. The solution is simply to remove the index manually (unless you want to edit the migration files).
mysql -u root -p
use [database];
ALTER TABLE theme_options DROP FOREIGN KEY voyager_theme_options_voyager_theme_id_foreign;
exit
and then run the migrations again and then the seeds.
1
