AbanteCart Community

Shopping Cart Operations => Support => Topic started by: gold2000 on June 21, 2017, 10:24:44 AM

Title: Error 1054 while loginto admin panel
Post by: gold2000 on June 21, 2017, 10:24:44 AM
Hello Team

This morning suddenly I am facing this message while logging in to my Abantecart Admin

Please advise.
Title: Re: Error 1054 while loginto admin panel
Post by: abantecart on June 22, 2017, 01:37:47 PM
Hello.

Did you upgrade your AbanteCart recently?

Looks like you are missing `salt` field on users table.

You can ran these to make sure you have salt field
Code: [Select]
ALTER TABLE `ac_customers`
ADD COLUMN `salt` varchar(32) COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `ac_customers` ADD COLUMN `salt` varchar(8) COLLATE utf8_general_ci NOT NULL DEFAULT '';
 
ALTER TABLE `ac_users` ADD COLUMN `salt` varchar(8) COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `ac_users` MODIFY `password` varchar(40);

Do not forget to replace ac_ with your abmr_ prefix on the tables.