Getting test environment working with MySQL database

[lateral]

Hi Guys,

 

I have my production version of Prestashop in a folder called "presta1606". It is running 1.6.0.6 of Prestashop. It is connected to a database called "presta_1"

 

I want to upgrade to version 1.6.0.9.

 

So far this is what I have done:

 

1. Copied the "prest1606" folder and subfolders to a folder called "prestanew".

 

2. Export all ofthe records from "presta_1".

 

3. I created a new empty database called "presta_2"

 

4. I imported all of the tables into "presta_2". I did note that the "presta_1" had 284 tables and 22515 rows and "presta_2" only had 236 tables and 19103 rows)...any idea why the difference?

 

5. I edited the config/settings.inc.php file (see the following):

 

<?php
define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', 'greghanl_presta2');
define('_DB_USER_', 'greghanl_presta2');
define('_DB_PASSWD_', 'H6[P4.BsS6');
define('_DB_PREFIX_', 'ps_');
define('_MYSQL_ENGINE_', 'InnoDB');
define('_PS_CACHING_SYSTEM_', 'CacheMemcache');
define('_PS_CACHE_ENABLED_', '0');
define('_MEDIA_SERVER_1_', '');
define('_MEDIA_SERVER_2_', '');
define('_MEDIA_SERVER_3_', '');
define('_COOKIE_KEY_', 'zrgrwsaorscmrjs0qwdb8bk0u56pom43yimeonmzr68ykcrbquesu7i2');
define('_COOKIE_IV_', 'nigmtcot');
define('_PS_CREATION_DATE_', '2014-09-01');
define('_PS_VERSION_', '1.6.0.6');
define('_RIJNDAEL_KEY_', 'VdTdit6WBv2RJniHCaup3jYkqRTWKMT1');
define('_RIJNDAEL_IV_', 'I67uLal6gvEMqdl9eAn2Hg==');

 

But what do I put in the "define('_DB_PASSWD_', 'H6[P4.BsS6');" setting?????? It looks like the password is encrypted...

 

 

[El Patron]

Hi, first thank you for putting in the correct effort to upgrade, i.e. creating a test base.

 

you db password is whatever password you assign when you create the actual db user for the db you create, it can be whatever you want.  typically auto generated 'look' encrypted, but in fact they are not.  thanks for following correct path to upgrade by doing this important work, so many times we don't see this..you rock

 

here is good blog

http://www.prestashop.com/blog/en/set-up-a-test-server-for-your-online-store/

[lateral]

Thanks El Patron

 

The password (H6[P4.BsS6) in the config file is definitely not what I created. It is definitely encrypted somehow.

 

There has to be a solution to this issue.

[lateral]

Hi Guys

 

Ok, here is the update on the upgrade from 1.6.0.6 to 1.6.0.9.

 

All went well except for the following.

 

I have a 3rd Party Theme that needs a minor adjustment that I am having trouble figuring how to do it.

 

Can somebody please look at the attached screen shot and tell me what to do?

 

Basically, the upgrade has added a list of Category's down the bottom of the page....

 

If I disable the Categories Block module I loose both the Left Column one that I want and the bottom of the page that I want to get rid of....

[lateral]

I just had another think and figured out that all I needed to do was to "unhook" it from the "Display Footer"!

 

yeah!