Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Upgrading from 1.3.x to 1.3.9 / Upgrading database.

Upgrading database.

Locked

Started by jumbobeef on 28 Dec 2010, 1:27 PM · Views: 2,406

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
28 Dec 2010, 1:27 PM
#1
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Upgrading database.

Hello.

I am not very technical so please bear with me.

I installed ZC using fantastico recently. I did a few changes (text and colours etc) but no add-ons. However, the version was out of date (1.3.8 I think).

I have today uploaded 1.3.9h over the top of the original files. All OK now I think, except I get this message on the top of the home page:

Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

Details there tell me:

Zen Cart 1.3.9h
Database Patch Level: 1.3.8
v1.3.8 [2010-10-20 05:52:33] (Fresh Installation)
v1.3.8 [2010-10-20 05:52:33] (Fresh Installation)

Please can someone tell me how to patch/update my database? I have searched through this forum and FAQ but I have been unable to find anything.

Thanks! :smile:

28 Dec 2010, 2:42 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Upgrading database.

Please can someone tell me how to patch/update my database?
The distribution includes a folder "zc_install"

Restore this folder and run /zc_install and select upgrade Database only

Zen-Venom Get Bitten

28 Dec 2010, 4:26 PM
#3
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Re: Upgrading database.

Thanks, but all I get when I go to www.mywebsite/zc_install is the ZC logo, the words ':: Zen Cart™ Setup - Welcome' and the text below:

Welcome to the setup program for Zen Cart™ v1.3.9h release. This setup program will guide you through the necessary steps to ensure Zen Cart™ is properly installed on your system.

but nothing to click on :dontgetit What do I do next please?

When viewed via FTP. all the files seem to be there.

28 Dec 2010, 5:22 PM
#4
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Re: Upgrading database.

OK, I deleted all the zc_install files, and put them back again. YES! I have now buttons to press.

However, it kept telling my that two files were not found:

Your /includes/configure.php and/or /admin/includes/configure.php file contains invalid path information and/or invalid database-connection information.
If you recently edited your configure.php files for any reason, or maybe moved your site to a different folder or different server, then you'll need to review and update all your settings to the correct values for your server.

My admin section is now showing this same message. I had renamed my admin file to something else, is this the problem?

Help!

Thanks.

28 Dec 2010, 5:43 PM
#5
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Re: Upgrading database.

This is driving me nuts.

I believe I have updated the DB as the warning has now gone from the shop home page.

I have deleted the zc_install files.

I have put both /includes/configure.php and/or /admin/includes/configure.php back to read only.

I have renamed the admin files back to 'admin', but I still cannot get into the admin section (I still get the same warning message as above).

Help!

28 Dec 2010, 6:56 PM
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Upgrading database.

I have renamed the admin files back to 'admin', but I still cannot get into the admin section
What does your admin configure.php file say is the admin folder?

Zen-Venom Get Bitten

28 Dec 2010, 7:01 PM
#7
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Re: Upgrading database.

kobra:

What does your admin configure.php file say is the admin folder?

'admin'

28 Dec 2010, 8:04 PM
#8
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Upgrading database.

If the frontend loads, compare like settings in it to your admin configure.php
As it is stating that there are invalid settings

Zen-Venom Get Bitten

29 Dec 2010, 9:29 AM
#9
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Re: Upgrading database.

kobra:

If the frontend loads, compare like settings in it to your admin configure.php

Thanks, but I do not understand what to do.

The shop main page loads, but says along the top 'NOTICE: The website is currently Down For Maintenance to the public'

I cannot access the admin section due to the message I post yesterday. I do not know what to do, or how to do it :dontgetit

All help gratefully received! Please!

29 Dec 2010, 10:01 AM
#10
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Upgrading database.

Thanks, but I do not understand what to do.
Compare like settings in it to your admin configure.php

Zen-Venom Get Bitten

29 Dec 2010, 10:27 AM
#11
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Re: Upgrading database.

Thanks. This is my includes/configure.php

<?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 "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://mywebsite.co.uk'); define('HTTPS_SERVER', 'https://mywebsite.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', '/'); define('DIR_WS_HTTPS_CATALOG', '/'); 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/bswccouk/public_html/mywebsite.co.uk/'); 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'); define('DB_SERVER_USERNAME', 'bswccouk_zc1'); define('DB_SERVER_PASSWORD', 'XXXXXXXXXXXX'); define('DB_DATABASE', 'bswccouk_zc1'); 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/bswccouk/public_html/mywebsite.co.uk/cache'); // EOF

I changed the password to XXXXs in this posting but it does actually have a password in there:

define('DB_SERVER_PASSWORD', 'XXXXXXXXXXXX');

I have also removed my website domain.

This is my admin/includes/configure.php

<?php /** * dist-configure.php * * @package Configuration Settings * @package Admin * @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 * @version $Id: dist-configure.php 6329 2007-05-16 15:36:56Z drbyte $ * @private */ // 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 // HTTP_CATALOG_SERVER is your Main webserver: eg-http://www.yourdomain.com // HTTPS_CATALOG_SERVER is your Secure webserver: eg-https://www.yourdomain.com /* * URL's 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://localhost'); define('HTTPS_SERVER', 'https://localhost'); define('HTTP_CATALOG_SERVER', 'http://localhost'); define('HTTPS_CATALOG_SERVER', 'https://localhost'); // 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', '/admin/'); define('DIR_WS_CATALOG', '/'); define('DIR_WS_HTTPS_ADMIN', '/admin/'); define('DIR_WS_HTTPS_CATALOG', '/'); 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', '/admin/'); define('DIR_FS_CATALOG', '/'); 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', 'zen_'); define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', 'root'); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', ''); define('USE_PCONNECT', 'false'); 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', 'none'); define('DIR_FS_SQL_CACHE', '/enter/your/path/to/public_html_or_htdocs/and/zencart/here/zen/cache'); ?>
29 Dec 2010, 10:41 AM
#12
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Upgrading database.

I meant that you need to compare the entries!!!!

These are some that do not match but you need to check them all

Store = black
admin = green

define('HTTP_SERVER', 'http://scottishphotographs.co.uk');
define('HTTPS_SERVER', 'https://scottishphotographs.co.uk');

define('HTTP_SERVER', 'http://localhost');
define('HTTPS_SERVER', 'https://localhost');

define('DIR_FS_CATALOG', '/home/bswccouk/public_html/scottishphotographs.co.uk/');
define('DIR_FS_CATALOG', '/');

Admin only
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/

define('DIR_FS_ADMIN', '/admin/');
This is not the COMPLETE PATH


define('DB_SERVER_USERNAME', 'bswccouk_zc1');
define('DB_SERVER_USERNAME', 'root');


define('DB_DATABASE', 'bswccouk_zc1');
define('DB_DATABASE', '');


define('SQL_CACHE_METHOD', 'database');
define('SQL_CACHE_METHOD', 'none');


define('DIR_FS_SQL_CACHE', '/home/bswccouk/public_html/scottishphotographs.co.uk/cache');
Missing

Zen-Venom Get Bitten

29 Dec 2010, 10:58 AM
#13
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Re: Upgrading database.

Right, thanks. Will do!

Thanks.

29 Dec 2010, 4:19 PM
#14
jumbobeef avatar

jumbobeef

New Zenner

Join Date:
Dec 2010
Posts:
13
Plugin Contributions:
0

Re: Upgrading database.

kobra:

I meant that you need to compare the entries!!!!

THANK YOU :clap: It works!

I have a few other things to sort but I am happy to get the shop up and running, and to be able to access the admin section.

Thank you again :bigups: