Reputation: 11
I'm trying to run root@ipxmanager:/srv/ixpmanager# php artisan migrate
but I'm getting this error:
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'ixpmanager.customer_to_ixp' (SQL: drop table `customer_to_ixp`)
This is what I executed to create the database:
CREATE DATABASE `ixpmanager` CHARACTER SET = 'utf8mb4' COLLATE = 'utf8mb4_unicode_ci';
CREATE USER `ixpmanager`@`localhost` IDENTIFIED BY 'mypassword';
GRANT SUPER ON *.* TO `ixpmanager`@`localhost`;
GRANT ALL ON `ixpmanager`.* TO `ixpmanager`@`localhost`;
GRANT SUPER ON *.* TO `ixpmanager`@`localhost`;
FLUSH PRIVILEGES;
I've tried the answers of this post: Can't DROP TABLE because unknown table (ERROR 1051)
mysql> DROP VIEW customer_to_ixp;
and mysql> DROP TABLE customer_to_ixp;
getting again ERROR 1051 (42S02): Unknown table 'ixpmanager.customer_to_ixp'
I've also tried deleting and creating the table again.
Am I missing something?
I know this question may have answers already on Stack Overflow, but I have a different issue here.
I'm following the steps of IXP Manager Manual Installation https://docs.ixpmanager.org/latest/install/manually/#database-setup
Upvotes: 0
Views: 36