Bug #5092: CBSubs URL filter in payment center causing SQL error - CB - Joomlapolis forge

Actions

Copy link

Bug #5092

closed

CBSubs URL filter in payment center causing SQL error

Added by krileon over 10 years ago. Updated over 10 years ago.

Status:

Rejected

Priority:

Urgent

Assignee:

krileon

Target version:

Start date:

19 February 2015

Due date:

% Done:

100%

Estimated time:

Description

Unsure if issue is in CBLib or CBSubs at this time. Clicking New Registrations, Upgrades, or Renewals in the payment center will cause the below.

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 '= '1' )' at line 2 SQL=SELECT COUNT FROM `jos_cbsubs_payments` AS a WHERE ( a.`time_paid_date` = '2015-01-12' ) AND ( (.`upgrades` = '1' )

The query seams to be broken. First it's missing "a" table as and second it has an extra bracket.

https://www.joomlapolis.com/forum/255-developer-members-support/228568-cbsubs-payments-center-error-1064-you-have-annerrornin-yournsqlnsyntax