moving products to a new zen cart

can anyone help. i am now on my last strand of hair and my head is getting cold.

anyway - i am in the process of setting up a new website (new dmain name and all) and wish to transfer my existing zen cart to my new site and server.

i gather that i have to install a new cart etc but is there a way that the products and catagories can be moved over. 1200 + products and dont want to start from scratch.

also if anyone knows how to upload products and catagories from either an rss feed or an xml catalogue this would do too

please help i am going insaine

You don't need to set up a new Zen Cart, just copy all the files (including your images) to your new location and then edit the includes/configure.php file and the admin/includes/configure.php file to reflect the new database name and location.

Then you backup your existing database, which will include your product information and restore it to the new database.

There's a FAQ Entry here that details a slightly longer but easier approach (i.e. gets around having to edit the configure file).

Hi Thanks for the reply

i have tried this and i now get an error message about a missing autoload_func.php in my admin / inlcudes files. i have just checked my working cart and this does not have one either. (but still works fine) what am i doing wrong ???

:frusty:

You're not giving me much to go on here.

Did you use the method in the FAQ or the quicker method where you edit the configure.php files your self? If it was the latter, I would double check that you have returned them to the right locations, that they uploaded properly (often the write protection gets in the way) and that you have made all the changes needed to both files and don't have any typos like the one in your post above.

Also, it would be helpful to see the full text of the error message, as the vital clue is often in the details.

Hi there sorry

it is by amending the configure.php files the error get is
Warning: main(/home/strato/www/ki/www.kinkydreams.co.uk/adults4fun/adminincludes/autoload_func.php) [function.main]: failed to open stream: No such file or directory in /mnt/web5/52/98/51651098/htdocs/adults4fun/admin/includes/application_top.php on line 149

Fatal error: main() [function.require]: Failed opening required '/home/strato/www/ki/www.kinkydreams.co.uk/adults4fun/adminincludes/autoload_func.php' (include_path='.:/opt/RZphp4/includes') in /mnt/web5/52/98/51651098/htdocs/adults4fun/admin/includes/application_top.php on line 149

on admin and:


Parse error: syntax error, unexpected T_STRING in /mnt/web5/52/98/51651098/htdocs/adults4fun/includes/configure.php on line 44

on the zen cart location.

i manually transfered all files ensuring the the location mached :oops:

All is becoming clear. There are errors in your configure files. The first is in your admin configure where the define statement for DIR_FS_CATALOG seems to have acquired a reference to "admin". This should be pointing to the root folder in your catalog. If ypu're not sure what I mean post lines 66-69 and I'll unravel them.

The problem in your catalog configure is more difficult to work out from the error, but sounds like a typo. If it's not obvious, could you post lines 39-47 of that file.

Whatever you post, please make sure that don't post any database details, user names or password.

thanks for admin it is

define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');


and for catalog is

// * 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_ADMIN', '/adults4fun/admin/');
define('DIR_WS_CATALOG', '/adults4fun/');
define('DIR_WS_HTTPS_ADMIN', '/adults4fun/admin/');
define('DIR_WS_HTTPS_CATALOG', '/adults4fun/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

Both of these come from the admin configure files. Neither correspond to the lines that I was hoping to see.

That they both come from admin is certainly a problem. That the lines don't match up could be a problem (corrupted files) or could simply mean that you're using an older version of Zen Cart. What version are you using?

Unless that gives you a big enough clue to solve these problems, can you now post the whole files, but again with the request that you obscure your db name, user name and password.

HI i am using version 1.3.7

the admin is

<?php
//
/**
*
* @package Configuration Settings
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


/*************** NOTE: This file is similar, but DIFFERENT from the "store" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/

// Define the webserver and path parameters
// Main webserver: eg, http://localhost - should not be empty for productive servers
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
// HTTP_CATALOG_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg, https://www.yourdomain.com
/*
* URLs for your site will be built via:
* HTTP_SERVER plus DIR_WS_ADMIN or
* HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or
* HTTP_SERVER plus DIR_WS_CATALOG or
* HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
* ...depending on your system configuration settings
*/
define('HTTP_SERVER', 'http://www........co.uk');
define('HTTPS_SERVER', 'https://www..........co.uk');
define('HTTP_CATALOG_SERVER', 'http://www..........co.uk');
define('HTTPS_CATALOG_SERVER', 'https://www..........co.uk');

// Use secure webserver for catalog module and/or admin areas?
define('ENABLE_SSL_CATALOG', 'false');
define('ENABLE_SSL_ADMIN', '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_ADMIN', '/adults4fun/admin/');
define('DIR_WS_CATALOG', '/adults4fun/');
define('DIR_WS_HTTPS_ADMIN', '/adults4fun/admin/');
define('DIR_WS_HTTPS_CATALOG', '/adults4fun/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
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_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * 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_ADMIN', '/home/strato/www/ki/www..........co.uk/adults4fun/admin/');
define('DIR_FS_CATALOG', '/home/strato/www/ki/www.........co.uk/adults4fun/admin');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'rdbms..........de');
define('DB_SERVER_USERNAME', '........');
define('DB_SERVER_PASSWORD', '........');
define('DB_DATABASE', '........');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

// 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/strato/www/ki/www..........co.uk/adults4fun/cache');

for the catalog it is:

oh thanks for helping

<?php
/**
*
* @package Configuration Settings
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/

// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
define('HTTP_SERVER', 'http://www...............co.uk');
define('HTTPS_SERVER', 'https://www...........co.uk');

// Use 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', '/adults4fun/');
define('DIR_WS_HTTPS_CATALOG', '/adults4fun/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
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_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/strato/www/ki/www.........co.uk/htdocs/);

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', '');
define('DB_SERVER', 'rdbms........de');
define('DB_SERVER_USERNAME', '.......');
define('DB_SERVER_PASSWORD', '.......');
define('DB_DATABASE', '.......');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

// 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/strato/www/ki/www........ .co.uk/htdocs/cache')');

?>

Got them both:

In the admin, this line has extras (in red) that need deleting

Quote:

---

define('DIR_FS_CATALOG', '/home/strato/www/ki/www.........co.uk/adults4fun/admin');

---

In the catalog, this line has a missing single quote from just inside the bracket at the end

Quote:

---

define('DIR_FS_CATALOG', '/home/strato/www/ki/www.........co.uk/htdocs/);

---

hi there well the error has changed to

catalog

Warning: main(includes/auto_loaders/config.core.php) [function.main]: failed to open stream: No such file or directory in /mnt/web5/52/98/51651098/htdocs/adults4fun/includes/application_top.php on line 91

Warning: main() [function.include]: Failed opening 'includes/auto_loaders/config.core.php' for inclusion (include_path='.:/opt/RZphp4/includes') in /mnt/web5/52/98/51651098/htdocs/adults4fun/includes/application_top.php on line 91

Warning: Cannot modify header information - headers already sent by (output started at /mnt/web5/52/98/51651098/htdocs/adults4fun/includes/application_top.php:91) in /mnt/web5/52/98/51651098/htdocs/adults4fun/includes/application_top.php on line 114


and admin

Warning: main(/home/strato/www/ki/www.kinkydreams.co.uk/adults4fun/includes/autoload_func.php) [function.main]: failed to open stream: No such file or directory in /mnt/web5/52/98/51651098/htdocs/adults4fun/admin/includes/application_top.php on line 149

Fatal error: main() [function.require]: Failed opening required '/home/strato/www/ki/www.kinkydreams.co.uk/adults4fun/includes/autoload_func.php' (include_path='.:/opt/RZphp4/includes') in /mnt/web5/52/98/51651098/htdocs/adults4fun/admin/includes/application_top.php on line 149

sorry i know our thinking :censored: and :frusty:

Seems to me that there's some confusion here about the file system path on your server.

In your catalog configure you have defined it as

Quote:

---

/home/strato/www/ki/www.........co.uk/htdocs/

---

but in your admin congigure you have defined it as

Quote:

---

/home/strato/www/ki/www.........co.uk/adults4fun/

---

, and it seems from the warning messages as though your server is expecting

Quote:

---

/mnt/web5/52/98/51651098/htdocs/adults4fun/

---

Is it possible that you are using variants of the file system from your hosting account on your new one?

Hi Kuroi

not that i am aware of - how would i tell. ??? shlould i give up?? :no:

Hi I have been working through the error messages and i am stuck with this one, can you advise what this points to as i believe i am missing the application_top.php file within the includes file which is there and i am a little cofused

Warning: main(/home/strato/www/ki/www.kinkydreams.co.uk/adults4fun/includes/autoload_func.php) [function.main]: failed to open stream: No such file or directory in /mnt/web5/52/98/51651098/htdocs/adults4fun/admin/includes/application_top.php on line 149

Fatal error: main() [function.require]: Failed opening required '/home/strato/www/ki/www.kinkydreams.co.uk/adults4fun/includes/autoload_func.php' (include_path='.:/opt/RZphp4/includes') in /mnt/web5/52/98/51651098/htdocs/adults4fun/admin/includes/application_top.php on line 149

Quote:

---

Originally Posted by 1just4help

Hi Kuroi

not that i am aware of - how would i tell. ??? shlould i give up?? :no:

---

Give up and you won't learn anything. I recommend replacing the FS paths that you have, at least one of which must be wrong, with what your server is expecting.

The problems that you are having are almost certainly not because you don't have the files you need but because your sending your Zen Cart to a location that it can't find to get them.

But don't give up, because I think you're really rather close to getting it to work.

sorry i am still quite new to all this. the paths i have been working through has now led me to install and upgrade. this is as i have had mising files or moved files. can you advise what the fs path is as this is still jargon to me. sorry i think i need to be spoken to as php for dummies

I'm suggesting changing this in your admin/includes/configure.php file

Quote:

---

define('DIR_FS_ADMIN', '/home/strato/www/ki/www.kinkydreams.co.uk/adults4fun/admin/');
define('DIR_FS_CATALOG', '/home/strato/www/ki/www.kinkydreams.co.uk/adults4fun/');

---

to read this instead

Quote:

---

define('DIR_FS_ADMIN', '/mnt/web5/52/98/51651098/htdocs/adults4fun/admin/');
define('DIR_FS_CATALOG', '/mnt/web5/52/98/51651098/htdocs/adults4fun/');

---

and making a similar change in your includes/configure.php file (just one line to change there).

Hi thanks for the help, the shopping cart is installed but none of the catagories or products transfered - any ideas with this

Quote:

---

Originally Posted by kuroi

Then you backup your existing database, which will include your product information and restore it to the new database.

---

Quote:

---

Originally Posted by 1just4help

Hi thanks for the help, the shopping cart is installed but none of the catagories or products transfered - any ideas with this

---

What method did you use to move your old database into the new location?

Hi kuroi, i have done a back up of the old mysql as advised, when i attempt to import files i have this error

SQL query:

CREATE TABLE `zen_address_book` (

`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL default '0',
`entry_gender` char( 1 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_company` varchar( 32 ) COLLATE latin1_general_ci default NULL ,
`entry_firstname` varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_lastname` varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_street_address` varchar( 64 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_suburb` varchar( 32 ) COLLATE latin1_general_ci default NULL ,
`entry_postcode` varchar( 10 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_city` varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_state` varchar( 32 ) COLLATE latin1_general_ci default NULL ,
`entry_country_id` int( 11 ) NOT NULL default '0',
`entry_zone_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id_zen` ( `customers_id` )
) ENGINE = MYISAM AUTO_INCREMENT =2DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci
MySQL said:

#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 'collate latin1_general_ci NOT NULL default '',
`entry_company