goodluck11 Posted May 14, 2014 Share Posted May 14, 2014 (edited) Hello I am changing the store 1.4.0.17 to 1.5.6.2 I have a problem with customer passwords of the old store that do not work in the new, is there any solution for this problem? If no solution, there is any way to regenerate the password for all clients and then send an email with the new? Thank you! Edited May 19, 2014 by obox11 (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted May 15, 2014 Share Posted May 15, 2014 Hello I am changing the store 1.4.0.17 to 1.5.6.2 I have a problem with customer passwords of the old store that do not work in the new, is there any solution for this problem? If no solution, there is any way to regenerate the password for all clients and then send an email with the new? Thank you! how did you upgrade manual or one click upgrade? please explain. Link to comment Share on other sites More sharing options...
goodluck11 Posted May 15, 2014 Author Share Posted May 15, 2014 how did you upgrade manual or one click upgrade? please explain. hi i have created a new parallel store and had imported costumers with sql, all data are well less password that fails when I try to identify. I think the problem is because there is another COOKIE_KEY in the new store.. if import is from csv I have to regenerate all passwords... Link to comment Share on other sites More sharing options...
goodluck11 Posted May 15, 2014 Author Share Posted May 15, 2014 (edited) Hi I put my old COOKIE_KEY in the new shop at the archive settings.inic.php and when i opened my client account in the new shop. went out this error: Fatal error: Uncaught You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`' at line 6<br /><br /><pre>SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN ()) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` </pre> thrown in /var/www/mishop.com/classes/db/Db.php on line 613 I have searched for solutions but have not found yet.. Edited May 15, 2014 by obox11 (see edit history) Link to comment Share on other sites More sharing options...
goodluck11 Posted May 15, 2014 Author Share Posted May 15, 2014 how did you upgrade manual or one click upgrade? please explain. I can't resolve my problem, check my error please Link to comment Share on other sites More sharing options...
goodluck11 Posted May 19, 2014 Author Share Posted May 19, 2014 I solved the problem, the problem was in the groups of the previous shop did not match the id_group new once changed the group costumer in the back office of the store had to resave it as group customer not to leave error. Link to comment Share on other sites More sharing options...
Recommended Posts