If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Linux/Unix Server / Moved Zencart Not Working

Moved Zencart Not Working

Locked

Started by karyn on 13 May 2006, 4:06 PM · Views: 6,513

Results 1 to 11 of 11
This thread is locked. New replies are disabled.
13 May 2006, 4:06 PM
#1
karyn avatar

karyn

New Zenner

Join Date:
Jan 2006
Location:
Hooterville, Connecticut
Posts:
10
Plugin Contributions:
0

Moved Zencart Not Working

Hi,

I moved my zencart from one server to another. I did a fresh install of zencart on the new server. All went well... let all my files with the exception of the admin/includes/config and includes/config overwrite the files on the server.. everything at that point was still ok..
Went in and droped all the tables in the new database.. then imported my database into it.. All the info is showing up in the database.. but when I try to log-in to the admin .. I am getting basically a blank page.. with this error..

1146 Table 'kreative_zc1.configuration' doesn't exist

HELP!! I have been reading through the posts.. but haven't found anything like this.
I wasn't sure where to post this question, hope I have the right place.

Karyn

13 May 2006, 4:08 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Moved Zencart Not Working

If your Catalog works but your Admin does not ...

Check the /includes/configure.php and look down at the bottom for the database settings ...

Then check the /admin/includes/configure.php and look down at the bottom for the database settings ...

Are both using the same database?

Look at the top of the two files ...

Are both using the same URLs and path settings?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 May 2006, 4:22 PM
#3
karyn avatar

karyn

New Zenner

Join Date:
Jan 2006
Location:
Hooterville, Connecticut
Posts:
10
Plugin Contributions:
0

Re: Moved Zencart Not Working

Since I imported the database, neither the catalog or the admin works.. I am getting the same error.. when trying to log in to the admin.. or view the catalog. Both were working before I imported the database.

Karyn

yes, they are both using the same database

13 May 2006, 4:25 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Moved Zencart Not Working

So you loaded a clean v1.3.0.1 on your new site and created a new database ... and all was good ...

Then ... you overwrote all of the v1.3.0.1 code with your v1.2.7 code and dropped the database tables in your v1.3.0.1 database and loaded your v1.2.7 database and structure ... and all is broken ...

Is this correct?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 May 2006, 4:30 PM
#5
karyn avatar

karyn

New Zenner

Join Date:
Jan 2006
Location:
Hooterville, Connecticut
Posts:
10
Plugin Contributions:
0

Re: Moved Zencart Not Working

No.. I loaded a fresh 1.26 version ( which is the same version that I had) and then overwrote the files ( that were the same version) on the new server. I figured I would upgrade AFTER i had everything moved and working.

Everything was working in the store and admin.. until I imported the database. But zencart was the same version that I had.

13 May 2006, 5:01 PM
#6
ajeh avatar

ajeh

Oba-san

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

Re: Moved Zencart Not Working

Did your old site use database prefixes and your new site not use them?

Look in the configure.php files to see if you have a prefix set ... then look via phpMyAdmin at your database tables and see if it is or isn't using those based on what is set in the configure.php files ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 May 2006, 5:29 PM
#7
karyn avatar

karyn

New Zenner

Join Date:
Jan 2006
Location:
Hooterville, Connecticut
Posts:
10
Plugin Contributions:
0

Re: Moved Zencart Not Working

No, they both use them.

This is the error

1146 Table 'kreative_zc1.kreative_project_version' doesn't exist

that table is not in my database, could be why it can't find it! LOL
But I can't find that reference to that table in any of the config files.. I am totally lost.

13 May 2006, 5:38 PM
#8
ajeh avatar

ajeh

Oba-san

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

Re: Moved Zencart Not Working

You said you had the error referencing:

1146 Table 'kreative_zc1.configuration' doesn't exist

But now you have an error referencing:

1146 Table 'kreative_zc1.kreative_project_version' doesn't exist

That would mean half your code is calling the database tables with the prefix:
kreative_

And half the code is calling the database tables with no prefix ...

This makes no sense ...:blink:

Your old site works correct?

Do both sites have different user names?

Are they with different hosts? Or just different domain names?

Could you post the /includes/configure.php from the server for your old site ... without your username and password ...

Then, could you post the /includes/configure.php from the server for your new site ... without your username and password ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 May 2006, 6:08 PM
#9
karyn avatar

karyn

New Zenner

Join Date:
Jan 2006
Location:
Hooterville, Connecticut
Posts:
10
Plugin Contributions:
0

Re: Moved Zencart Not Working

The top error is what I am getting when trying to access the admin..

the second error is what I am getting when trying to access the store.

The domain name is the same.. the hosts are different. User names are different.

The old site ( on my old host) is not up anymore.. :( But yes, it was working perfect.

After 4 days of trying to get this to work.. I am at my wits end.. I wiped out what I had.. and started over.. I can now get into the admin, and the catalog.. but I have not imported my database yet. I am thinking of starting over from scratch. I can always add my customer base back in manually.. . And my products again also.. The database is what is messing things up.

This is the file from my old server: ( was the one that worked)

// Define the webserver and path parameters
// Main webserver: eg, http://localhost - should not be empty for productive servers
define('HTTP_SERVER', 'http://karyntaglia.com');
// Secure webserver: eg, https://localhost - should not be empty for productive servers
define('HTTPS_SERVER', 'https://karyntaglia.com');
// secure webserver for checkout procedure?
define('ENABLE_SSL', 'false');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_CATALOG', '/zencart1/');
define('DIR_WS_HTTPS_CATALOG', '/zencart1/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_BLOCKS', DIR_WS_INCLUDES . 'blocks/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/home/karynta/public_html/zencart1/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '
*');
define('DB_DATABASE', 'karynta_zc1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'database');
define('DIR_FS_SQL_CACHE', '/home/karynta/public_html/zencart1/cache');

?>

Will post the other file in a minute.

13 May 2006, 6:19 PM
#10
karyn avatar

karyn

New Zenner

Join Date:
Jan 2006
Location:
Hooterville, Connecticut
Posts:
10
Plugin Contributions:
0

Re: Moved Zencart Not Working

I think I found the problem.. I named the new database with a prefix.. so it would be the same as the database I had, that is what is showing up in when I look in the hosting control panel.. BUT the actual database name on the new server is a different name, withouth a prefix, I didn't catch that before.

Now the question is.. how to fix that or can't I? I really would just love to get my address book and customers back in. Is there a way to do that?

Thank you for your help.

13 May 2006, 6:21 PM
#11
ajeh avatar

ajeh

Oba-san

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

Re: Moved Zencart Not Working

Seeing your /includes/configure.php from the server on the new site would help ... :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!