Zen Cart Logo
Forums / Installing on a Windows Server / Setting up Zen Cart on Windows XP using Xampp - a howto

Setting up Zen Cart on Windows XP using Xampp - a howto

Locked

Views: 48,941

Results 81 to 93 of 93
This thread is locked. New replies are disabled.
7 Nov 2009, 6:09 PM
#81
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Setting up Zen Cart on Windows XP using Xampp - a howto

ckosloff:

tar czvf public_html.tgz public_html
If you are on a Linux server it should be fast and you should be able to see the progress.

Finally got this done....thank you.

I am to the next step with database.
Go your local PHPmyadmin, select your local database and click on Import, navigate to the folder where you saved the sql and select it, click go.

I saved database sql to my local file. I went into local PHPmyadmin. I created a new database. I can not find import. It is not below export like on live PHPmyadmin. Page 39 of book said to create database...I went back thru your directions and do not see create database. Not sure what to do next.
Kim

8 Nov 2009, 3:23 PM
#82
ckosloff avatar

ckosloff

Totally Zenned

Join Date:
Feb 2007
Location:
South Florida, USA
Posts:
1,375
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

kburner:

I went into local PHPmyadmin. I created a new database. I can not find import.
Of course my instructions don't ask to create database.
They say to delete test installation but NOT database, simply because the name of that database is what the config files use to connect.
Read your config files, therein you will find the name of the database, now create a database with exact same name.
Once created, you select it, it should show import as an option in the top bar.
By the way, what version of XAMPP are you using?
If you installed the latest 1.7.2, then you have PHP 5.3, Zen Cart v1.3.8a and older do not work with that one, read the announcements.
You have to install previous one 1.7.1.

8 Nov 2009, 4:36 PM
#83
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

ckosloff:

Of course my instructions don't ask to create database.
They say to delete test installation but NOT database, simply because the name of that database is what the config files use to connect.
Read your config files, therein you will find the name of the database, now create a database with exact same name.
Once created, you select it, it should show import as an option in the top bar.
By the way, what version of XAMPP are you using?
If you installed the latest 1.7.2, then you have PHP 5.3, Zen Cart v1.3.8a and older do not work with that one, read the announcements.
You have to install previous one 1.7.1.

I am using XAMPP for Windows Version 1.4.16. Will this one work?

Kim

8 Nov 2009, 4:49 PM
#84
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

ckosloff:

Of course my instructions don't ask to create database.
They say to delete test installation but NOT database, simply because the name of that database is what the config files use to connect.
Read your config files, therein you will find the name of the database, now create a database with exact same name.
Once created, you select it, it should show import as an option in the top bar.
By the way, what version of XAMPP are you using?
If you installed the latest 1.7.2, then you have PHP 5.3, Zen Cart v1.3.8a and older do not work with that one, read the announcements.
You have to install previous one 1.7.1.

I went to local PHPmyadmin and created database with same name as my live site from config files. Still do not see import as option in top bar....

This is what I see after I select from left side of screen database name. It is on right side.

Server: localhost - Database: mydatabasename_xxxx
StructureStructure SQLSQL SearchSearch QueryQuery ExportExport OperationsOperations DropDrop

No tables found in database.
Create new table on database mydatabasename_xxxx:
Name:
Number of fields:

Kim

8 Nov 2009, 5:01 PM
#85
ckosloff avatar

ckosloff

Totally Zenned

Join Date:
Feb 2007
Location:
South Florida, USA
Posts:
1,375
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

kburner:

I went to local PHPmyadmin and created database with same name as my live site from config files.
You are not understanding.
On your local site you create database with same name as your LOCAL files.
You need two sets of files: one for local and one for live.
I recommended 1.7.1.

8 Nov 2009, 5:12 PM
#86
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

ckosloff:

You are not understanding.
On your local site you create database with same name as your LOCAL files.
You need two sets of files: one for local and one for live.
I recommended 1.7.1.

My local config file does not have a name...
define('DB_DATABASE', '');

Yes, I agree this has been very confusing for me. Kim

8 Nov 2009, 5:25 PM
#87
ckosloff avatar

ckosloff

Totally Zenned

Join Date:
Feb 2007
Location:
South Florida, USA
Posts:
1,375
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

kburner:

My local config file does not have a name...
define('DB_DATABASE', '');
This doesn't make sense.
If you installed Zen Cart in your local XAMPP it forced you to create a database (dafault name: zencart).
How would it install otherwise?
Start over.
Uninstall your version of XAMPP, install 1.7.1.
Create DB in phpmyadmin.
Install Zen Cart pointing to that DB you created.
Once it installs correctly, save both your config files.
Then delete the whole folder, but NOT the DB.
Now you have a DB and good config files pointing to it.
Next uncompress your tar.gz into the htdocs folder in XAMPP.
Replace the config files with the ones you saved.
In phpmyadmin import the sql.gz from live into local.

9 Nov 2009, 4:19 PM
#88
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

ckosloff:

This doesn't make sense.
If you installed Zen Cart in your local XAMPP it forced you to create a database (dafault name: zencart).
How would it install otherwise?
Start over.
Uninstall your version of XAMPP, install 1.7.1.
Create DB in phpmyadmin.
Install Zen Cart pointing to that DB you created.
Once it installs correctly, save both your config files.
Then delete the whole folder, but NOT the DB.
Now you have a DB and good config files pointing to it.
Next uncompress your tar.gz into the htdocs folder in XAMPP.
Replace the config files with the ones you saved.
In phpmyadmin import the sql.gz from live into local.

I started over. Thank you for being patient.

Uninstall your version of XAMPP, install 1.7.1. - DONE
Create DB in phpmyadmin. - Done
Install Zen Cart pointing to that DB you created. - I was able to install copy of live database this time.

I am at this point.
Once it installs correctly, save both your config files. Where do I find these files now? database? This part is confusing because I have not installed uncompress tar.gz into htdocs folder which houses these documents.
Then delete the whole folder, but NOT the DB. - ?

Now you have a DB and good config files pointing to it.
Next uncompress your tar.gz into the htdocs folder in XAMPP.
Replace the config files with the ones you saved.
In phpmyadmin import the sql.gz from live into local.[/QUOTE]

10 Nov 2009, 2:28 AM
#89
ckosloff avatar

ckosloff

Totally Zenned

Join Date:
Feb 2007
Location:
South Florida, USA
Posts:
1,375
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

kburner:

Install Zen Cart pointing to that DB you created. - I was able to install copy of live database this time.
Still not understanding.
You have to install a fresh copy of Zen Cart, forget about your live site for the moment.
Create database first, install ZC pointing to that database, all this is in the manual.
Once ZC installs, save /includes/configure.php and /admin/includes/configure.php, anywhere you like.
Then you delete the installation, uncompress tar.gz, replace config files, import sql.gz

10 Nov 2009, 5:21 PM
#90
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

ckosloff:

Still not understanding.
You have to install a fresh copy of Zen Cart, forget about your live site for the moment.
Create database first, install ZC pointing to that database, all this is in the manual.
Once ZC installs, save /includes/configure.php and /admin/includes/configure.php, anywhere you like.
Then you delete the installation, uncompress tar.gz, replace config files, import sql.gz

Hi ckosloff,

I followed your directions and finally seems to work. I did all you directed above. I went back through book to make sure I was not leaving any open places for potential hackers. I changed curl file like book says on page 40. When I did zc-install (page 46-47) I get error of:

CURL problems detected: 28 => connect() timed out! more info...

CURL problems detected: 28 => connect() timed out! more info...

CURL requires SSL support. Please notify webmaster or hosting company. 28 => connect() timed out!

Since, this is for local do I need to contact my host....I really hope I am still not messing this up. I thought I was finally getting it with last message. Kim

11 Nov 2009, 12:20 AM
#91
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

kburner:

Hi ckosloff,

I followed your directions and finally seems to work. I did all you directed above. I went back through book to make sure I was not leaving any open places for potential hackers. I changed curl file like book says on page 40. When I did zc-install (page 46-47) I get error of:

CURL problems detected: 28 => connect() timed out! more info...

CURL problems detected: 28 => connect() timed out! more info...

CURL requires SSL support. Please notify webmaster or hosting company. 28 => connect() timed out!

Since, this is for local do I need to contact my host....I really hope I am still not messing this up. I thought I was finally getting it with last message. Kim

I have been looking for hours and found thread with curl information to just ignore. I am ok with that since not live. But other problem is I changed admin file and made sure changes made in admin/includes/config and includes/config. But, getting error of no file found with admin/includes/config when I zc-install. I went back and triple checked file and everything is correct.

Admin/includes (admin has been changed.)

<?php /** * @package Configuration Settings circa 1.3.8 * @copyright Copyright 2003-2007 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://www.your_domain.com - // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com // HTTP_CATALOG_SERVER is your Main webserver: eg-http://www.your_domain.com // HTTPS_CATALOG_SERVER is your Secure webserver: eg-https://www.your_domain.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 * * If you desire your *entire* admin to be SSL-protected, make sure you use a "https:" URL for all 4 of the following: */ define('HTTP_SERVER', 'http://www.example.com'); define('HTTPS_SERVER', 'https://www.example.com'); define('HTTP_CATALOG_SERVER', 'http://www.example.com'); define('HTTPS_CATALOG_SERVER', 'https://www.example.com'); // 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', '/shop/xxxx/'); define('DIR_WS_CATALOG', '/shop/'); define('DIR_WS_HTTPS_ADMIN', '/shop/xxxx/'); define('DIR_WS_HTTPS_CATALOG', '/shop/'); 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', 'C:/xx/xxxx/xxxxx/xampp/htdocs/shop/xxxx/'); define('DIR_FS_CATALOG', 'C:/xx/xxxx/xxxxx/xampp/htdocs/shop/'); 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', 'localhost'); define('DB_SERVER_USERNAME', 'xxxxx'); define('DB_SERVER_PASSWORD', 'xxxx'); define('DB_DATABASE', 'xxxxx'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'db'); // for STORE_SESSIONS, 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', 'none'); define('DIR_FS_SQL_CACHE', 'C:/Users/Kim/server/xampp/htdocs/shop/cache'); // EOF I have been trying to locate thread on this one too. If anyone knows please provide link. Thanks, Kim
11 Nov 2009, 2:34 AM
#92
ckosloff avatar

ckosloff

Totally Zenned

Join Date:
Feb 2007
Location:
South Florida, USA
Posts:
1,375
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

kburner:

I have been looking for hours and found thread with curl information to just ignore.
Really, I don't know what more to tell you.
In fresh unzipped ZC the config files are sometimes named dist-configure.php, you can rename and remove the dist.
Regarding curl you can remove semicolon (uncomment) in php.ini.
This is of course in the manual.

2 Dec 2009, 3:56 AM
#93
ckosloff avatar

ckosloff

Totally Zenned

Join Date:
Feb 2007
Location:
South Florida, USA
Posts:
1,375
Plugin Contributions:
0

Re: Setting up Zen Cart on Windows XP using Xampp - a howto

Couple things here.
XAMPP recommends to install server at root, like so:
C:/xampp/
Regarding SSL support, xampp has an SSL cert which you can use, so you can use https for your admin.
Of course, Firefox will complain that cert is not valid, just add an exception and you will be good to go.
Now that ZC 1.3.8 has a patch for PHP 5.3 you can even install latest version of xampp and it will work.