DB prefix problem

[chrifus1982]

Hi,
I have two Zen Cart installations but only one database.
So I added a prefix "p1_" to "configure.php" and copied the tables with the prefix.
But I have this error message :

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p1_configuration' at line 2
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from p1_configuration]

What is the problem

[canopy]

Double check whether your database tables are indeed prefixed with 'p1_'. For example, a database table 'p1_configuration' exists in the database you are trying to connect to.

Do check that both your admin and store configure.php files have the following line as well. And check that you are indeed connecting to the right database.

define('DB_PREFIX', 'p1_');