Con Zymaris

Howdy Keith. We're still using the system in production with no problems, but in virtualisation or container modes, and with the then supported instances of the web-server and SQL server. If you're able to setup (or migrate) an old instance as a container or VM, then all works fine.

Hi Keith, PHP 5.6 should be fine to use. Zero-ing in on what the cause of the issue is may be difficult however. Do you have the options of making a VM of your existing, functioning allocPSA server that you can then continue hosting as a VM?

Howdy Keith, We're many months into the lengthy process of migrating allocPSA to PHP 7.x and updated MySQL/MariaDB. With luck, that should be finished in the coming months. In the meantime, we recommend that users host their previously running allocPSA instances as a VM, while taking sensible precautions to limit remote access etc, to reduce security risks. -- Con

Hi Wally, is this still occuring? Does it always resolve when you restart MySQL? Are you using the same MySQL server version as you'd used previously? -- Con

There appears to be a change in the configuration of mysql (as of 5.7.12) which results in the ongoing generation of errors like: 1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by The actual problem is not one related to the SELECT statements and can be resolved by adding the following: [mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION...

This file (db_patches.sql) is missing from the GitHub repo. It's available from here however.

Running the db_data.sql script within interactive mysql generates a number of errors, see below: ERROR 1366 (HY000): Incorrect string value: '\xE2\x82\xA1' for column 'currencyTypeLabel' at row 1 ERROR 1366 (HY000): Incorrect string value: '\xD9\x84.\xD8\xB3' for column 'currencyTypeLabel' at row 1 Query OK, 1 row affected (0.00 sec) ERROR 1366 (HY000): Incorrect string value: '\xE0\xB8\xBF' for column 'currencyTypeLabel' at row 1 ERROR 1366 (HY000): Incorrect string value: '\xD0\x85\xD0\x9C' for...

When tryng to install the current version of allocPSA (1.8.x) there will be a requirement to execute the db_patches.sql script within the intgeractive mysql program. This file appears to be missing.