Forums / Templates, Stylesheets, Page Layout / DB prefix problem

DB prefix problem

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

26 Oct 2008, 5:40 PM

chrifus1982

New Zenner

Join Date:: Oct 2008
Posts:: 5
Plugin Contributions:: 0

DB prefix problem

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:huh:

27 Oct 2008, 5:02 AM

canopy

Totally Zenned

Join Date:: Oct 2006
Posts:: 625
Plugin Contributions:: 0

Re: DB prefix problem

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_');