When I attempt to access mysql from cli using the below:
mysql -u root -p
I receive the following error:
ERROR 1524 (HY000): Plugin '*717792008D019DA9A8E4133215A0AECDFBE6847F' is not loaded
I am also getting the following error when trying to access phpmyadmin:
Your PHP installation is incomplete.
Missing php-mysql or php-pdo or php-pdo-mysql or any other (message is not clear).
This is not a projeqtor issue, itr is pure PHP issue, I'm affraid we cannot help much.
Culprit seemed to be php as you indicated.
Removed older version of PHP to PHP Version 7.1.3 and problem resolved.
Thank you for the insight.
Really, PHP 7.1.3 is a very old version and should not be used in production anymore.
Hello CatalystDROID,
You seem to encounter many issues with your web server installation and therefore, issues with ProjeQtOr.
Maybe you can have a look at this page concerning the compatibilities and technical requirements :
https://www.projeqtor.org/en/product-en/technical-en/64-setup-en/412-product-prerequisites-en
And also this one about security during the setup-up
https://www.projeqtor.org/en/product-en/technical-en/64-setup-en/413-product-setup-en
With all those information, you should be able to set up a correct web server for your ProjeQtOr instance.
Currently I am using Projeqtor v10.3.4 and PHP v7.1.3.
Should I upgrade php to a specific version?
Will a new updated php version play nice with Projeqtor v10.3.4 ?
Just check Technical prerequisites as defined on the website.
I see the following:
Recommended MySql configuration (in my.ini ou my.cnf) :
innodb-default-row-format=dynamic
collation when creating the database :
For ProjeQtOr = V10.0 : utf8mb4_general_ci
Should I be using utf8mb4_general_ci instead of the latin1_general_ci ?
Yes, it is highly advised to use UTF8
But i needed to change it to 'latin1_general_ci' to resolve the below errors and the Global Planning. Will I get these errors again if I change it to 'utf8mb4_general_ci' ?
** ERROR ** [V10.3.4] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1'
** ERROR ** [V10.3.4] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'
The parameter you changed is just to tell projeqtor the encoding of your DB.
If your DB is Latin, you must specifylatin.
DB (not th9e parameter in proj=eqtor, the DBengine) should be encodeded UTF8MB4, then projeqtor parameter is useless.
Ok. But what is confusing to me is why it was looking to use a latin1 CHARACTER SET in the first place. Is this a default ? I did not make any changes to reflect this at the DB level.
What can I do/check to make sure I am setup properly?
Should I check/update something in mysql setup? What elements/values should I have in any projeqtor config files etc?
Thanks again for any assistance.
Hello,
That's exactly what we are telling you from the beginning.
As it's explained in the documentation and in our website (I already gave you the useful links), your database should be encoded in UTF8mb4, just like Babynus told you.
That's part of your mysql setup, even before installing ProjeQtOr on your webserver.
Then, the installation should be automatic, you should not have to change anything in the config files directly (concerning the encoding).


