Problems after migrating from localhost

[pqangel]

Hello,

 

I've tried moving prestashop from localhost to a remote webserver and i'm encountering a few problems...

 

First, when i try to acces to the URL it redirects me to /es

tisana.dementecreativos.com/tienda redirects to tisana.dementecreativos.com/tienda/es

 

second when i try to access the backoffice it asks me for username and pwd but when i try to login it gives me a DB error:

[PrestaShopDatabaseException]

Unknown column 'a.weight' in 'field list'

SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`, a.`weight`
FROM `ps_advice` a

			LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice`
			LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice` 
WHERE (
			a.`validated` = 1 AND 
			a.`hide` = 0 AND 
			al.`id_lang` = 1 AND 
			at.`id_tab` = 1 AND 
			((a.`start_day` = 0 AND a.`stop_day` = 0) OR (17 >= a.`start_day` AND 17 <= a.`stop_day`)))

This is what I've done for the migration:

 

backed up files and upload them threw FTP to new server

backed up DB in a sql file and imported it to the new server

modified settings.inc.php with the new DB access values (name, username and pwd) this is the settings.inc php content (for obvious reasons i've modified DB access info as well as cookie and rijndael keys)

<?php
define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', 'DB');
define('_DB_USER_', 'user');
define('_DB_PASSWD_', 'password');
define('_DB_PREFIX_', 'ps_');
define('_MYSQL_ENGINE_', 'InnoDB');
define('_PS_CACHING_SYSTEM_', 'CacheFs');
define('_PS_CACHE_ENABLED_', '0');
define('_MEDIA_SERVER_1_', '');
define('_MEDIA_SERVER_2_', '');
define('_MEDIA_SERVER_3_', '');
define('_COOKIE_KEY_', 'key');
define('_COOKIE_IV_', 'key');
define('_PS_CREATION_DATE_', '2014-11-09');
if (!defined('_PS_VERSION_'))
        define('_PS_VERSION_', '1.6.0.9');
define('_RIJNDAEL_KEY_', 'key');
define('_RIJNDAEL_IV_', 'key';

I've changed ownership of prestashop directories to www-data

change values for domain and domain SSL in PS_configuration and PS_shop_url, URI is the same in both localhost and remote (/tienda/)

 

i don't really know what to do now. I've cheked ps_advice in the localhost and in the new server and is empty in both places but it works in localhost and not in the new server.

 

Any ideas?

 

thanks a lot