FrontAccounting forum — Sales group query error in mysql 8

Re: Sales group query error in mysql 8

2022-09-10T05:02:47Z

Tested and it works on MySQL 8.0.30 Ubuntu. Thank you!

Re: Sales group query error in mysql 8

2022-09-06T15:11:30Z

I have now installed Mysql 8.0.27 and tested and everything works fine with the two fixed files. Both without table pref and with.

I will now push the files to stable repository

/Joe

Re: Sales group query error in mysql 8

2022-09-06T12:39:55Z

@bradlanier

You are of course also welcome to test this. Please replace the files on your server and report back. Thanks in advance.

Joe

Re: Sales group query error in mysql 8

2022-09-06T08:56:22Z

Hello again.

@barbarian

I have tried to fix this with backticks where ever the table is included in an sql statement.
It is ok on a table prefix, I have tested.
But what about without table prefix.

Will you replace the two downloaded files /sales/includes/db/sales_groups_db.inc and /includes/ui/ui_lists.inc and see if it works in Mysql 8 without table prefix.

Thanks in advance.

/Joe

Re: Sales group query error in mysql 8

2022-09-06T06:28:57Z

We will have to backtick the group's table in SQL statements, I guess. Let me have a look at this.

Joe

Re: Sales group query error in mysql 8

2022-09-05T21:13:19Z

When can we get this fixed? I do not have prefixes. Cannot edit groups and the customer branch edit/create is not functional as well

Re: Sales group query error in mysql 8

2021-05-02T09:22:52Z

Yes. This will be one future coming issue for FA. @joe, before many people experience the issue rename the table to use it better way.

Sales group query error in mysql 8

2021-05-01T15:43:33Z

In FA, sales group table name is "TB_PREFIX.groups".
When I setup FA without prefix, the table name is only "groups".
In mysql 8, groups is a reserved keyword so all query with table groups would throw an error.
It can be solved by adding backtick in the table name part in the query but it would change a lot in FA.