Project

General

Profile

Actions

Bug #8849

closed

Price filters in payment center table cause fatal SQL error

Added by krileon almost 3 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
High
Assignee:
Target version:
Start date:
28 January 2022
Due date:
% Done:

100%

Estimated time:

Description

When clicking a price under "Completed" column (also errors for "Pending", but not for "Paid on") in the "last 7 days payments" table an error is thrown as follows.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Completed' ) AND ( a.`time_paid_date` = '2022-01-21' ) AND ( a.`payment_status`' at line 4

The filters attempting to be applied to the payments table (&table=payments) are as follows.

[filter_payment_status]=Completed
[filter_time_paid_date]=2021-07-12

https://www.joomlapolis.com/forum/277-cb-paid-subscriptions-support/244632-you-have-an-error-in-your-sql-syntax

Actions

Also available in: Atom PDF