AdAgency Campaigns with error links

DragAuth

From the Advertisers Portal in the AdAgency Pro, any link I click takes me to an error page. It doesn't matter what I click, Campaign Name, Manage Ads, or Action, they all give me errors to the next page.

SQL

What do I need to do to get my campaigns to work properly?

Ninja

DragAuth
Hi
Its error on your Joomla user tables, have you updated Joomla recently ?
I found some DB error may in Joomla extensions > DB and its fixed.
Please check the panel now.

manhta

DragAuth
Hi,
This is an error with mysql 8.0. You can fix by opening file

/components/com_adagency/views/adagencycampaigns/tmpl/editform.php

find this string

GROUP_CONCAT(DISTINCT CAST(ugm.group_id as CHAR)) groups

change it to

GROUP_CONCAT(DISTINCT CAST(ugm.group_id as CHAR)) `groups `

DragAuth

I do have the most recent Joomla update available. It was updated no more than 2 weeks ago.

I did check it again, and I am still getting the same error.

Ninja

DragAuth
Hi
its fixed on the backend, on frontend i can see DB error from Joomla user table.
I shared with dev team for further fix. It seems you imported the DB here from older site with different Joomla versions.

DragAuth

Manhta, thank you. The code change helped me to access all the campaigns from the back end. From the front end when I go to a Campaign I am getting the following screen error. On the plus, it's not the same error.

manhta

DragAuth
I've updated the code. Please check.

DragAuth

It is working in both front and back end. That did the trick. Thank you.