AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: rvalani on September 15, 2016, 11:46:41 AM

Title: Admin panel Login error during upgrade
Post by: rvalani on September 15, 2016, 11:46:41 AM

Hi,
I upgraded my site from 1.2.7 to 1.2.8 I copied my database and its showing all the categories but when I click on them it shows error because probably I haven't set up SEO url.. Now to fix this issue when I try to go to admin page and login it throws me this error
SQL Error: Unknown column 'salt' in 'where clause'
Error No: 1054
SQL: SELECT * FROM users WHERE username = 'rahul' AND ( password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('my_password'))) )) OR password = '26474d26a8cbce658b7132467c1f3361' ) AND status = 1 in C:\xampp\htdocs\abante_128\core\database\amysqli.php on line 108

Also there are some images that are not showing properly

Title: Re: Admin panel Login error during upgrade
Post by: jaysbar on September 15, 2016, 12:56:58 PM

Hi

Check your salt key (system/config.php) and make sure it hasn't changed.

I would advise anyone reading this post - when you set up Abantecart, always set up a 2nd admin account incase the default one ever has a problem.

Title: Re: Admin panel Login error during upgrade
Post by: rvalani on September 15, 2016, 02:57:01 PM

Ya I checked my salt key is same

Title: Re: Admin panel Login error during upgrade
Post by: abolabo on September 16, 2016, 02:47:01 AM

this error means that you do not have salt column in the table customers.

https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database_upgrade.sql#L40