Page 1 of 1

Upgrade from 2.1.6 to 2.2 fails

Posted: Tue Jul 11, 2017 5:15 pm
by asdf
I have a site which does not use table prefix and upgrading from 2.1.6 fails, running on MySQL. The prefix was not needed for 1.x and so far upgrades have worked fine. But "Step 4 - Basic Configuration Information" on 2.2 requires prefix be filled, it fails with error

Code: Select all

Please enter a valid prefix for database tables
The config.php sets it to blank correctly

Code: Select all

$config['db_prefix'] = '';
What to do, other than rename all tables?

Re: Upgrade from 2.1.6 to 2.2 fails

Posted: Wed Jul 12, 2017 1:02 am
by Jos
I ran into the same problem and chose to edit the table names, but also the names of all the indexes. Some indexes seem to be explicitly called in some scripts, and if you forget to prefix them too, you will only see the active page in the frontend menu.

Re: Upgrade from 2.1.6 to 2.2 fails

Posted: Thu Jul 13, 2017 3:03 pm
by asdf
Thanks for the index tip! As there was no other solution i had to rename tables and indexes.