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
separate database - tables without prefix not allowed? #9815
Comments
What are you expecting? In some cases it should be possible to reuse the existing tables. |
Hi Stefan, There was no option to continue, I was required to have a prefix for the tables (understandable for those who haven't full root control over their mysql). Thanks for reading. |
It will only offer to reuse existing tables (in this case the tables without prefix) if there were at least 12 Piwik tables found (not counting any In this case it did find at least 12 tables. However, I presume there was no user or no site found. Possibly you already tried to install Piwik once without a prefix and didn't finish it. To fix it you can either delete all Piwik tables without prefix (if you are sure they contain no data etc) or to create a user and a site. Then it should offer to reuse the table. Ideally, the installer would have offered it to you in the first place and continued where needed but this part of the installation is a bit limited currently. |
If you have time, perhaps you could repeat the action on an empty VM to Here were my exact steps (I checked my bash_history to verify): The zip was downloaded and unzipped into the webserver path, with user@db:/var/www/ssl/phpmyadmin$ cat ~/.mysql_history returned to the Piwik installation web page, input the DB name, DB On 02/22/2016 05:00 PM, Thomas Steur wrote:
|
I tried to reproduce using the same steps. Once I let the installation process create the database and once I created the DB myself like you did. In both cases it worked fine without using a table prefix. I'll close it for now. Maybe you can try to reproduce with a fresh installation of Piwik and a new database? |
I created a separate database and removed the prefix - when creating the tables, I received this with no way to continue. Can you fix this case?
Thanks
----installation webpage shows:
Creating the Tables
Some tables in your database have the same names as the tables Piwik is trying to create
The following tables have been found in the database:
user, access, site, site_setting, site_url, goal, logger_message, log_action, log_visit, log_conversion_item, log_conversion, log_link_visit_action, log_profiling, option, session, sequence
« Go back and define a Prefix for the Piwik Tables
Delete the detected tables »
The text was updated successfully, but these errors were encountered: