MySQL 5.7 issue?

[edwbaker]

I have just upgraded to MySQL 5.7 and I am getting a number of issues, such as this one when trying to add an item to an existing Sales Order:

'An error occurred when updating that sale:
Error encountered when calibrating payments: Expression #1 of ORDER BY clause is not in SELECT list, references column 'beans.transactions.date' which is not in SELECT list; this is incompatible with DISTINCT [ SELECT DISTINCT(transactions.id) as payment_id FROM transactions WHERE transactions.payment = "customer" AND transactions.id IN (154) ORDER BY transactions.date ASC, transactions.id ASC ]'

I assume these errors are due to the MySQL upgrade - as these were functions I used regularly before.

[cdp1337]

The build of beansbooks is currently based on an old version of Kohaha which may not support MySQL 5.7. It for a fact doesn't support MySQLi!

I'm in the process of porting the application over to Kohana 3.3 now, and given the massive amount of changes, I'm not surprised upstream hasn't ported it yet. In the event I can manage a successful port, I'll let you know; (we're running MariaDB 10.1 just for reference).

[cdp1337]

After far too many hours on the keyboard, we have a functioning BB install w/ Kohana 3.3 on PHP 7 and MariaDB 10! I will continue testing with legacy data to ensure that nothing breaks and get something committed to our fork of the project in the next few days. Granted this won't be in the official repo, so take my progress with a grain of salt.

[chthonik]

Because the packaging required is not being updated to newer releases (Ubuntu 16.04), I would recommend building a docker container to run the application in. Here is a link to one that has served me well for installing: https://hub.docker.com/r/nimmis/apache-php5/~/dockerfile/. Use this in your Dockerfile, just remove the packages that are not needed in the README and add the few that are missing.