installing Prestashop getting MySQL ERROR !!!! What to do for this ??? Is any MySQL setting needs to get setup

[lse123]

Posted and here

https://forums.cpanel.net/threads/i-went-install-prestashop-from-cpanel-but-requires.662729/#post-2711117      #2 

When tried installing Prestashop getting MySQL ERROR !!!! What to do for this ??? Is any MySQL setting needs to get setup ? I tried 5 times same error message

Installing: Error: A database query has failed. Is the entered database information correct? Does the account have available disk space? type = mysql host = localhost database = paphos_marketplace username = paphos_YYYYY password = **HIDDEN** Technical information: method = query arguments = array ( 0 => 'SELECT `id_employee` FROM `pr_employee` WHERE `active`=\'1\' ORDER BY `id_employee` ASC LIMIT 1', 1 => NULL, 2 => 'id_employee',) errstr = Technical Error: 1146 Table 'paphos_marketplace.pr_employee' doesn't existSELECT `id_employee` FROM `pr_employee` WHERE `active`='1' ORDER BY `id_employee` ASC LIMIT 1

 

[lse123]

to install prestashop is ok with PHP 7.2  ???  Mysql versions ??

 

[selectshop.at]

See here the requirements tested in production. Detailed PS versions 1.7.x you will find further down in the topic:

https://www.prestashop.com/forums/topic/884856-best-server-settings-for-prestashop-17-tested-in-production/

The error you are having is saying that the employee you are using is not available on that database. Although you are free to use another prefix as the default ps_ for database tables, I will not change that. If you are using extra modules it could happen that they will not assign to another prefix. You are using pr_ instead of ps_.

[lse123]

I followed the settings recommended but same error --- nothing written in database --- before start installing --i have make the changes to PHP 7.2 and restarted Apache... but again same error see below????? what to do???

 

 

 

[selectshop.at]

You read last sentence ? Try to change prefix of database tables to default, which is ps_.

You are using which SQL and php ? You are installing/installed by which way ? The best is to download the package from here, unzip the package, up all folders and files to our FTP and install from there. If you are installing with a tool it could happen that the code is adapted/broken.

[lse123]

1

I am Not sure for extra modules...?

2

" You are using pr_ instead of ps_."   so suggest change to ps_ ...?

--------------------------------

3

I am installing from cPanel > Applications > at...installatron  >>> 

yyy.yyy.yyy.yyy:2083/cpsess5203754273/3rdparty/installatron/index.cgi#/apps 

Because i prefer Auto updates...

 

 

[selectshop.at]

1 hour ago, lse123 said:

2

" You are using pr_ instead of ps_."   so suggest change to ps_ ...?

yes, give a try.

1 hour ago, lse123 said:

I am installing from cPanel > Applications > at...installatron  >>> 

yyy.yyy.yyy.yyy:2083/cpsess5203754273/3rdparty/installatron/index.cgi#/apps 

Because i prefer Auto updates...

 

 

Use manual install I mentioned before. I will never use automatic update for a shop in production. This does not make any sense. In this case it is better to adopt "never touch a running system". If you read here there are several problems with upgrades. So make sure your site is running well instead of making automatic things, corrupting your business.

 

[lse123]

Installing: Error: A database query has failed. Is the entered database information correct? Does the account have available disk space? type = mysql host = localhost database = paphos_marketplace username = paphos_market password = **HIDDEN** Technical information: method = query arguments = array ( 0 => 'SELECT `id_employee` FROM `ps_employee` WHERE `active`=\'1\' ORDER BY `id_employee` ASC LIMIT 1', 1 => NULL, 2 => 'id_employee',) errstr = Technical Error: 1146 Table 'paphos_marketplace.ps_employee' doesn't existSELECT `id_employee` FROM `ps_employee` WHERE `active`='1' ORDER BY `id_employee` ASC LIMIT 1

 

Again same error... are you recommend check any MySQL/MariaDB settings... ?

 

[selectshop.at]

Install manually. Server settings required you will find on the link I named in my first post.

[lse123]

after install manually

may import install to

cPanel > Applications > at...installatron ...?

 

[selectshop.at]

What do you want to do ? From what I learned you are struggling with install = shop not working. Which data do you want to import if database is not working ?

[lse123]

cPanel > Applications > at...installatron ... has import option of a prestashop install, from either same server or other server providing FTP pass/user/IP etc

 

[selectshop.at]

1) I cannot say from where cPanel is taking the files. I don't use cPanel.  As I told before, download the package from official Prestashop site, unpack the package and upload the folders and files to your FTP. Afterwards open the domain and install with Prestashop Installer. The installatron is not a tool from Prestashop but from cPAnel. I cannot say if this will work on your server.

2) The import option in Installatron I presume is for an already installed and running shop. Do you have a running shop ? If yes it is better to follow these tutorials, instead of to use automatic tools not coded by Prestashop.

https://www.prestashop.com/en/blog/how-to-migrate-prestashop-to-a-new-server

and

https://devdocs.prestashop.com/1.7/basics/keeping-up-to-date/migration/

or

http://doc.prestashop.com/display/PS16/System+Administrator+Guide#SystemAdministratorGuide-MovingPrestaShop

[lse123]

You must install PHP zip extension first

The problem was this extension and not proceeded one click install ... now all ok

[lse123]

I installed both manually and one click in differ db differ folders

one click install is here - after installed php zip extension and restarted apache

http://www.paphos.city/marketplace2020/

 

manual install is here but getting error... any hint ???

http://www.paphos.city/marketplace/

This page isn’t working

www.paphos.city is currently unable to handle this request.

HTTP ERROR 500

 

 

[selectshop.at]

500 errors are server errors. Read server error logs. If the first install is running, you can login to back-office ? All things are working ? If yes, then you can proceed. If not, than activate debug mode and see where the server is writing errors.

[lse123]

the error

HTTP ERROR 500

is any related to .htaccess ... file? because exist two

in paphos.city  /marketplace2020,  /marketplace

 

[selectshop.at]

This should not make any difference, if you have your Prestashop in two distinct folders. But this also depends on your server configuration. You read the server error logs like I suggested before ? Debug mode from the shop not working activated as also suggested before ?

You can give a try and delete the cache folder of the shop not working and see if solves the blank page. See here: https://www.prestashop.com/forums/topic/1008318-blanck-admin-page-breaking-modules-clean-the-cache/?do=editComment&comment=3171815

 

[lse123]

the shop not working Never worked neither admin nor client --- how clean cache????