SQL Query Issue


  • Your avatar
    seyi    
     4 years ago
    0

    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"
  • Default avatar
    patrick7    
     4 years ago
    0

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

    Thanks -
    Patrick
  • Your avatar
    seyi    
     4 years ago
    0

    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.