Feststreet Posted December 22, 2015 Share Posted December 22, 2015 Hi, While installing PrestaShop v1.6.1.3 under godaddy cpanel i got below error Kindly help as im not that much technically sound. Technical error:Error: A database query has failed. Is the entered database information correct? Does the account have available disk space?type = mysqlhost = localhostdatabase = i1724721_ps2username = i1724721_ps2password = **HIDDEN**Technical information:method = queryerrstr = SELECT `id_employee` FROM `ps_employee` WHERE `active`='1' ORDER BY `id_employee` ASC LIMIT 1MYSQL ERROR 1146: Table 'i1724721_ps2.ps_employee' doesn't existEnd of report. Link to comment Share on other sites More sharing options...
tuk66 Posted December 23, 2015 Share Posted December 23, 2015 What tables are installed in the i1724721_ps2 database. there should be almost 300 tables. "ps_employee doesn't exist" means that some tables are not created. 1 Link to comment Share on other sites More sharing options...
Feststreet Posted December 23, 2015 Author Share Posted December 23, 2015 Thanks for your response. We believe we know that as the error speaks. We request you to guide us with the steps regarding how to create table in mysql in godaddy as there is nothing precisely mention. Link to comment Share on other sites More sharing options...
johnrobertson Posted June 11, 2016 Share Posted June 11, 2016 I had a different problem with similar symptoms, trying to follow password reset instructions here:PrestaShop 1.4.x-1.6.x. How to reset admin panel details - Template Monster HelpI cut-and-pasted this query, but it the tables with names down the side of my myphpadmin screen begin plml_employee not ps_employee. Changing both references of my cut-and-past text did the job.Like you, I'm no great expert but if you have access to a set of control buttons on your server, one of them might read "phpAdmin". Click on that, open the database that includes Prestashop on your server, and have a look for names ending _employee or similar on the left hand side of the screen.I hope that someone better at this stuff than me can correct me if I'm wrong UPDATE `ps_employee` SET `passwd` = MD5('EGbvvetrMAhxyUupKday1VTuGG2RDywT08QxaqQKnyEfrWw1HzZoP6YPnewpassword123') WHERE `ps_employee`.`id_employee` = 1; Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now