Can't find prefix database tables

when i reinstall and choose the right database and prefix i get te following error during pre-install validation:

Database could not be selected!
Please check the database permissions for the specified user and try again.

Checking table prefix `reyndesign_`: FAILED! - Table prefix does not exist in this database!

Setup couldn’t install into the selected database, as it does not contain existing tables with the prefix you specified to be upgraded. Please choose an existing table prefix, and run Setup again.

But the prefix is right. Does anyone have an idea of what it may be?

This means you are trying to run an upgrade, but the database does not contain your existing MODx tables.

But the prefix is correct. It is from an earlier install.

Quote from: rolo at Jun 01, 2010, 03:28 AM

But the prefix is correct. It is from an earlier install.

The installer begs to differ. Are you sure your connection details are correct and you can see the database tables when you connect to that database through phpMyAdmin or some other admin interface?

Yes I can see the tables, and when I put in the database information it says that it can connect, it just can’t find the prefix. Strange no?

Quote from: rolo at Jun 02, 2010, 08:54 AM

Yes I can see the tables, and when I put in the database information it says that it can connect, it just can’t find the prefix. Strange no?

Are you sure it’s not a user permission issue with the database user you are using in setup? Is this the same user you can see the tables with in phpMyAdmin?

I’m running into this too... just trying to duplicate a modx site. I’m attempting to do an advanced upgrade and have tried using the same user that PHPAdmin uses to see the tables without luck.

It connects correctly...

Connecting to database server: Success!

- Checking MySQL server version: OK! Running: 5.0.91-community-log
- Checking MySQL client version: OK! Running: 5.0.91

But no luck with selecting..

Checking database: Table prefix does not exist in this database!

All tables are prefix’d with "modx_" (e.g. modx_content, modx_messages, etc..)

Modx Revo 2.1.1
Linux kernel version: 2.6.18-338.9.1.el5.lve0.8.32
Apache version: 2.2.17
Perl version: 5.8.8
PHP version: PHP/5.2.17, also available 4.4.9

Duplicate a MODX site using what steps? Did you duplicate the database and use the new database name when doing the advanced upgrade? The database would have to exist with the duplicated tables in it for this to work.

Thanks for your reply OpenGeek.

The steps I took were as follows:

1. Create tarball of public_html directory via SSH
2. Dump of database tables via phpMyAdmin
3. Extract tarball onto new site via SSH
4. Create database of same name on new site
5. Create login credentials and set all privileges for newly created database
6. Import tables to newly created database via phpMyAdmin
7. Run advanced upgrade inputting the new database information and login info

I can replicate this issue as much as need be but although the tables exist and contain the appropriate prefix the installer doesn’t like it. Perhaps this is a bug because I came up with a way to work around the issue.

The work around simply involves going in and manually editing "core/config/config.inc.php" with the new info and doing a standard upgrade (haven’t tried with an advanced upgrade). I’m not sure why this would make a difference as most of the information that I swapped out is the info that the advanced upgrade allows you to put in. The only thing that the advanced upgrade doesn’t give you an option to input is the home directory path.

Anyhow...technically this is resolved for me, but it seems as though some kind of bug does exist. If I can offer any information to help identifying the issue let me know!

Thanks!
-Jared

For me, I was given this error because I had no imported the SQL data in the database yet.

Once I imported the SQL, I didn't receive this error.