I changed the shebang on every file in /optools to /usr/bin/python3 to work on my machine, but depending on how Python is configured in production, this may not be necessary.
I switched off only_full_group_by SQL mode in my local MySQL DB: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); as recommended in https://stackoverflow.com/questions/41887460/select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-inc. (I was getting an error of MySQLdb._exceptions.OperationalError: (1055, "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'register_tape.sales.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by") when loading a few files.)
TODO
When I search for an item in item_info.py, I get an error in the Apache log from item_graph.py when it tries to make a graph. The error is coming from a line in the Pillow module, so I'm not sure how to fix it. I fixed a similar error in sales_graph.py in this commit, but that fix does not work in item_info.py. I'm not familiar enough with matplotlib or Pillow to debug further, unfortunately.
Notes
/usr/bin/python3
to work on my machine, but depending on how Python is configured in production, this may not be necessary.only_full_group_by
SQL mode in my local MySQL DB:SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
as recommended in https://stackoverflow.com/questions/41887460/select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-inc. (I was getting an error ofMySQLdb._exceptions.OperationalError: (1055, "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'register_tape.sales.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by")
when loading a few files.)TODO