SQL Query Issue

Hello -

Just a heads up - ran into and issue with reports.php - here is the fix for developer :

"JDatabaseMySQL::query: 1052 - Column 'function_type' in where clause is ambiguous

You had already declared it here --> c.function_type

So we need to do the same here --> AND function_type="coupon" AND function_type2="category" ORDER BY u.username"

IE -- >AND c.function_type="coupon" AND function_type2="category" ORDER BY u.username"

In fact - that whole query is missing the references 'c.' .

Thanks -
Patrick

Hi Patrick,

Thanks for pointing it out. I have reviewed the file and updated the queries accordingly. The changes will be reflected in the next version.