-
Notifications
You must be signed in to change notification settings - Fork 179
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
step2.php - Base table or view not found #2651
Comments
It is the mysql-ddl.sql file that removes previously existing tables, so it sounds like it is being used but failing to create the new tables. |
Thank you for your fast response. |
Install uses the mysql client program to create the tables, so it might be a problem in your mysql.cnf settings for [client]. |
So that's my mysql.cnf on the server (if that helps). Currently trying older versions of mariadb, maybe it works with them
|
Tried different mariadb versions down to 10.1.23, getting the same errors every time. Tried different docker images users and configs, logging in as root database user, modified privileges... - does not work unfortunately... |
run |
Looks like the installer is broken, i had the same. Checkout commit 0317e5e, install, then update to master. |
@SpookyDex are you saying that is the last working commit you can install from? |
@niel i could be wrong but doesn’t sourceSQL() assume local MySQL database ? |
@Bart39 You're correct, there is no host parameter so the same device would be assumed. I'll update that to use the configured host info. |
Thank you for your suggestions! |
For white screens you'll need to check PHP's error log, you may need to enable it first. |
i had to uncomment the following line in step2.php to get the install to work. been having the same problems as OP //$DbSetup->processSQLFile(); // Setup default schema |
@leukosaima - is your database local or remote ? |
Remote technically. Using docker containers. The mariadb is in its own container on the same host |
Ok, so will benefit from the fix in dev once it’s promoted to master |
Expected behaviour
step2.php should create the tables and the user should be able to precede to the next step.
Actual behaviour
Steps to reproduce the behaviour
Install nzedb following the guides and try to connect to a mariadb database.
Background:
/opt/http
: Permissions were fixed by usingchmod -R 777 /opt
create database nzedb; grant all on nzedb.* to 'nzedb'@'localhost' identified by 'your-password'; grant file on *.* TO 'nzedb'@'localhost'; flush privileges; exit;
andmysql_tzinfo_to_sql /usr/share/zoneinfo | sudo mysql -u root -p mysql
mysql-ddl.sql
andmysql-data.sql
works without problems/opt/http/resources/db/schema/mysql-ddl.sql
- but why?)I am thankful for every idea/solution! Thank you!
The text was updated successfully, but these errors were encountered: