Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / 1146 Table DB.configuration does not exist

1146 Table DB.configuration does not exist

Locked

Views: 2,523

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
1 Nov 2010, 12:21 AM
#1
pippa_oz avatar

pippa_oz

New Zenner

Join Date:
Oct 2010
Location:
Brisbane, Australia
Posts:
10
Plugin Contributions:
0

1146 Table DB.configuration does not exist

I'm fairly notice at PHP , mysql

testing locally on new install of version 1.3.9h

using DB from online store version 1.3.9g but had upgrade to 1.3.9h

had initial issue with DB and fixed by adding prefix in admin/includes/configure.php

define('DB_PREFIX',' znc_'); which must have been the online install default

can now access admin page , but when I use online catalogue to view the site I get the following error:

1146 Table 'db_name.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

I assume I need to change an additional file somewhere to have the DB prefix defined as I did in
admin/includes/configure ('DB_PREFIX',' znc_');

is there a separate configure file as I can't see anywhere in the admin/includes/configuration .php code where it's clear I might need to change the prefix

1 Nov 2010, 4:49 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 1146 Table DB.configuration does not exist

You have 2 configuration files:
/includes/configure.php
/admin/includes/configure.php

And, to make changes to them, you need to make them writable, since they're normally set to read-only. You can't upload or save changes to a read-only file.

1 Nov 2010, 6:50 AM
#3
pippa_oz avatar

pippa_oz

New Zenner

Join Date:
Oct 2010
Location:
Brisbane, Australia
Posts:
10
Plugin Contributions:
0

Re: 1146 Table DB.configuration does not exist

Thank you so much! so simple and yet it had me dumfounded !