User Activity

  • Posted a comment on discussion Help allocPSA on allocPSA

    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

  • Posted a comment on discussion Help allocPSA on allocPSA

    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...

  • Posted a comment on discussion Help allocPSA on allocPSA

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

  • Posted a comment on discussion Help allocPSA on allocPSA

    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...

  • Posted a comment on discussion Help allocPSA on allocPSA

    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.

  • Posted a comment on discussion Help allocPSA on allocPSA

    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

  • Posted a comment on discussion Help allocPSA 1.5 on allocPSA

    Hi there. can you tell us what the error is that's thrown? -- Con

  • Posted a comment on discussion Help allocPSA on allocPSA

    Hi Anonymous. it's hard to say what would be classified as many improvements from...

View All

Personal Data

Username:
conz
Joined:
2000-01-23 21:58:56

Projects

  • HypatiaDB   Last Updated:
  • OpenTender   Last Updated:
  • Project Logo allocPSA   Last Updated:
  • grename Graphical mass file-rename utility Last Updated:

Skills

  • No skills entered.

Personal Tools