by matt | Feb 10, 2017 | Prestashop, SQL, Uncategorized
Database of your Prestashop project could be really huge after some time because of all the junk stats related data. The most of such data is not needed at all and it is only takes space on your server and slows the whole project down significantly. The best example...
by matt | May 5, 2016 | Prestashop, SQL, Uncategorized
During the years I have been working on Prestashop professionally I gathered many useful SQL queries which help you to overcome some unusual tasks. Here is a collection of useful SQL queries for Prestashop project ready to be fired. This is my personal collection from...
by matt | Aug 22, 2014 | Prestashop, Uncategorized
UPDATE ps_employee SET passwd = md5(‘cookiehereNEWPASSWORDHERE’) WHERE email =’myemail@gmail.com’ //example UPDATE ps_employee SET passwd = md5(‘DLKSDBqSddf7TNqNBTuuefrDkgsfsdaymAoQupDShBQvQZhrQD5zUPASSWORD123′) WHERE email...