FrontAccounting forum — Sales group query error in mysql 8

Re: Sales group query error in mysql 8

null@example.com (bradlanier) — Sat, 10 Sep 2022 05:02:47 +0000

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

Re: Sales group query error in mysql 8

null@example.com (joe) — Tue, 06 Sep 2022 15:11:30 +0000

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

null@example.com (joe) — Tue, 06 Sep 2022 12:39:55 +0000

@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

null@example.com (joe) — Tue, 06 Sep 2022 08:56:22 +0000

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

null@example.com (joe) — Tue, 06 Sep 2022 06:28:57 +0000

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

null@example.com (bradlanier) — Mon, 05 Sep 2022 21:13:19 +0000

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

null@example.com (kvvaradha) — Sun, 02 May 2021 09:22:52 +0000

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

null@example.com (barbarian) — Sat, 01 May 2021 15:43:33 +0000

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.