Trying to update from prestashop 1.5.3.1 to prestashop 1.6

[sabin]

OK, so here is my problem:

 

The site domain is http://www.alternative-naturiste.ro

I am trying to update my store.

I have made a sub-domain http://www.upgrade.alternative-naturiste.ro

I have archived the site from production and his database.

After I have unarchived  the site in the directory /public_html/prestashop-upgrade/

I duplicated the database and rename it from 'brumihar_prestashop' to 'brumihar_prestashop_upgrade'

I edited settings.inc.php from the new created folder and changed define('_DB_NAME_', 'brumihar_prestashop'); to define('_DB_NAME_', 'brumihar_prestashop_upgrade');

and define('_PS_DIRECTORY_', '/'); to define('_PS_DIRECTORY_', '/prestashop-upgrade/');

I have left everything else from settings.inc.php as it was.

 

Now i am trying to connect to my admin panel in the backend section of the new site http://www.upgrade.alternative-naturiste.ro and it returns:

There is 1 error

1. Employee does not exist or password is incorrect.

I am certain that I am entering the correct username and password

 

What am I missing or doing wrong since I'm not able to login to backend section?

 

 

[El Patron]

curious as to why you changed from / root to /folder/ in copy shop, best to keep root like produciton in your subdomain.  this will ease issues of images...

 

as for login, uhm...try this: in subdomain, delete the .htaccess file

 

re-test

 

also in 1.5.3.1 where you state you changed from root / to /folder/  I do not see this in a native 1.5.3.1. settings.inc.php  This is typicall changed 1) from admin seo& urls or 2) using phpmyadmin and modify ps_shop_url

[sabin]

curious as to why you changed from / root to /folder/ in copy shop, best to keep root like produciton in your subdomain.  this will ease issues of images...

 

as for login, uhm...try this: in subdomain, delete the .htaccess file

 

re-test

 

also in 1.5.3.1 where you state you changed from root / to /folder/  I do not see this in a native 1.5.3.1. settings.inc.php  This is typicall changed 1) from admin seo& urls or 2) using phpmyadmin and modify ps_shop_url

 

 

I have deleted the .htaccess file and changed back to root / but still no luck

My settings.inc.php is looking like this:

 

<?php

define('_DB_SERVER_', 'localhost');

define('_DB_NAME_', 'brumihar_prestashop_upgrade');

define('_DB_USER_', 'usename here');

define('_DB_PASSWD_', passroed here');

define('_DB_PREFIX_', 'ps_');

define('_MYSQL_ENGINE_', 'InnoDB');

define('_PS_CACHING_SYSTEM_', 'MCached');

define('_PS_CACHE_ENABLED_', '0');

define('_MEDIA_SERVER_1_', '');

define('_MEDIA_SERVER_2_', '');

define('_MEDIA_SERVER_3_', '');

define('_COOKIE_KEY_', 'ZqWMCR61ZLghzFfHO9hCXNEfxO0r2HzR208CMuVhtt9262WG7G5jIqbE');

define('_COOKIE_IV_', 'tRmUEWAi');

define('_PS_CREATION_DATE_', '2012-11-23');

define('_PS_VERSION_', '1.5.3.1');

define('_RIJNDAEL_KEY_', 'ZBVwVnBAnWZcFhYIHEEutqoNEit8oKSH');

define('_RIJNDAEL_IV_', 'x2YuM8Y0mpH1dALiVSUdoQ==');

define('_PS_DIRECTORY_', '/');

[El Patron]

it's possible that define('_PS_DIRECTORY_', '/'); is from 1.4 and you upgraded? 

 

remember to check using phpmyadmin as mentioned above.  though typically we can log into moved back office and change via seo&urls

 

clear your browser cookies/cache...and retest...if not help, then try lost password.

 

here is native 1531 settings.inc.php

define('_DB_SERVER_', '127.0.0.1');
define('_DB_NAME_', '1531');
define('_DB_USER_', 'root');
define('_DB_PASSWD_', 'pwd');
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_', 'some long value');
define('_COOKIE_IV_', 'another value');
define('_PS_CREATION_DATE_', '2014-09-01');
define('_PS_VERSION_', '1.5.3.1');
define('_RIJNDAEL_KEY_', 'another value');
define('_RIJNDAEL_IV_', 'another value==');

[sabin]

I tried forgot password and it returns:

There is 1 error

1. This account does not exist

 

 

 

I changed settings.inc.php to native 1.5.3.1 but is not working

 

Where do I find ps_shop_url using phpmyadmin?

 

 

Thank you for helping me!

 

 

 

it's possible that define('_PS_DIRECTORY_', '/'); is from 1.4 and you upgraded? 

 

remember to check using phpmyadmin as mentioned above.  though typically we can log into moved back office and change via seo&urls

 

clear your browser cookies/cache...and retest...if not help, then try lost password.

 

here is native 1531 settings.inc.php

define('_DB_SERVER_', '127.0.0.1');
define('_DB_NAME_', '1531');
define('_DB_USER_', 'root');
define('_DB_PASSWD_', 'pwd');
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_', 'some long value');
define('_COOKIE_IV_', 'another value');
define('_PS_CREATION_DATE_', '2014-09-01');
define('_PS_VERSION_', '1.5.3.1');
define('_RIJNDAEL_KEY_', 'another value');
define('_RIJNDAEL_IV_', 'another value==');

[El Patron]

 

I tried forgot password and it returns:

There is 1 error

1. This account does not exist

 

 

 

I changed settings.inc.php to native 1.5.3.1 but is not working

 

Where do I find ps_shop_url using phpmyadmin?

 

 

Thank you for helping me!

 

 

 

open you updgrade db and do some looking around to familiarize yourself.

 

 

you will also see table employee check that your admin email is there...

[sabin]

Now I see the problem, the production db has 324.8 MiB and 250 tables

When I try to export it download only 39.6 MiB and around 55 tables, I also have a (Max: 50MiB) restriction to upload an sql.

 

What do I have to do? Do I manually download chunks of 50 tables and upload them to test database?

 

 

Thank you!

[El Patron]

argh!...personally I'd have your hosting increase this...

 

the other thing you can try is not export three tables (_connections)...they usually get huge...

 

see if that helps, if so then just export table structures for (_connections) and import them to upgrade 

[sabin]

I have talked to hosting and they gave me root access to the server and everything went smooth from there. All the problems were coming from the fact that i was unable to download all my tables needed for my database.

I have also erased the content from (_connections) it was huge.

 

Thank you very much for the advice, you helped me a lot.

 

____________

In other order of business now I'm confronting with another issue

 

After the update in the catalog section of my site I have lost the formatting CSS for the description:

 

upgrade.alternative-naturiste.ro/62-abcese-dentare

 

Please copy the above link to your browser, I don't want google to index this subdomain.

 

Thank you again! 

 

argh!...personally I'd have your hosting increase this...

 

the other thing you can try is not export three tables (_connections)...they usually get huge...

 

see if that helps, if so then just export table structures for (_connections) and import them to upgrade