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.
If you are experiencing this error in allocPSA, then read on. Current versions (1.8.x) require the mbstring PHP extension. To install that, refer to your operating systen's HOWTO, for example: https://askubuntu.com/questions/772397/mbstring-is-missing-for-phpmyadmin-in-ubuntu-16-04