Forums / General Questions / which file is it to fix this?

which file is it to fix this?

Locked

Views: 867

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
4 Nov 2007, 10:14 PM
#1
hellogoodbye avatar

hellogoodbye

New Zenner

Join Date:
Oct 2007
Posts:
8
Plugin Contributions:
0

which file is it to fix this?

I backed up my files and uploaded it to another hosting that I'm trying. I tried to make an account at my store and this comes out. Where am I suppose to fix this?
Thanks.

1146 Table 'username_zc1.zen_subscribers' doesn't exist
in:
[select count(*) as total from zen_subscribers where email_address = '[email protected]' ]

4 Nov 2007, 11:17 PM
#2
poolprorich avatar

poolprorich

Zen Follower

Join Date:
Aug 2007
Location:
Tampa FL.
Posts:
143
Plugin Contributions:
0

Re: which file is it to fix this?

did you also upload the backup of your database and if so did you point bothe configureation files to the new data base,
sounds like you dont have a database conection

/admin/includes/configure.php
/includes/configure.php

5 Nov 2007, 12:50 AM
#3
hellogoodbye avatar

hellogoodbye

New Zenner

Join Date:
Oct 2007
Posts:
8
Plugin Contributions:
0

Re: which file is it to fix this?

hmm after i uploaded /admin/includes/configure.php & /includes/configure.php
I got
Not Found
The requested URL /store/zc_install/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

5 Nov 2007, 2:23 AM
#4
poolprorich avatar

poolprorich

Zen Follower

Join Date:
Aug 2007
Location:
Tampa FL.
Posts:
143
Plugin Contributions:
0

Re: which file is it to fix this?

you can not just upload the files they need to be edited for new path and to point to your database,

new server will have a different path to folder,
in /admin/includes/configure.php

you need to edit the following for your site:
define('HTTP_SERVER', 'http://www.YOUR_SITE.com');
define('HTTPS_SERVER', 'https://www.YOUR_SITE.com');
define('HTTP_CATALOG_SERVER', 'http://www.YOUR_SITE.com');
define('HTTPS_CATALOG_SERVER', 'https://www.YOUR_SITE.com');
edit for directory your zencart's in:
define('DIR_WS_ADMIN', '/shop/admin/');
define('DIR_WS_CATALOG', '/shop/');
define('DIR_WS_HTTPS_ADMIN', '/shop/admin/');
define('DIR_WS_HTTPS_CATALOG', '/shop/');
edit the following to your path:
define('DIR_FS_ADMIN', '/home/public_html/shop/admin/');
define('DIR_FS_CATALOG', '/home/public_html/shop/');
and edit to your database:
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'YOUR_PRIFIX');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'YOUR_USER_NAME');
define('DB_SERVER_PASSWORD', 'YOUR_PASSWORD');
define('DB_DATABASE', 'YOUR_DATABASE_NAME');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db');
Edit all in red.

for your catolog configure.php file
/includes/configure.php

define('HTTP_SERVER', 'http://www.YOUR_SITE.com');
define('HTTPS_SERVER', 'http://www.YOUR_SITE.com');

edit for the directory that your zen cart is located:
define('DIR_WS_CATALOG', '/shop/');
define('DIR_WS_HTTPS_CATALOG', '/shop/');

edit your direct path:

define('DIR_FS_CATALOG', '/home/public_html/shop/');

And your Database:

define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'YOUR_DB_PREFIX);
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', 'YOUR_USER_NAME');
define('DB_SERVER_PASSWORD', 'YOUR_PASSWORD');
define('DB_DATABASE', 'YOUR_DB_NAME);
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db');

Edit all in red