paco
paco

Reputation: 11

SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'ixpmanager.customer_to_ixp' (SQL: drop table `customer_to_ixp`)

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

Answers (0)

Related Questions