cpnetworld
Member
Hi
I would like to know what wrong I am doing, F3 (updated to latest at github) under j1.7.3
When a list is linked in a menu option
Single / individually Prefilter works ok but when two Prefilters are added simultaneously an MySQL error is displayed on front end.
From the error being displayed
getData: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 'sd_courses.status = '1' ) O
...........
WHERE ( sd_courses.course_type = '1' sd_courses.status = '1' ) ORDER BY `sd_courses`.`from_date` ASC LIMIT 0, 10
Probably AND has been missed between two conditions or some thing wrong on my end
Screen Shots attached
Rakesh
I would like to know what wrong I am doing, F3 (updated to latest at github) under j1.7.3
When a list is linked in a menu option
Single / individually Prefilter works ok but when two Prefilters are added simultaneously an MySQL error is displayed on front end.
From the error being displayed
getData: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 'sd_courses.status = '1' ) O
...........
WHERE ( sd_courses.course_type = '1' sd_courses.status = '1' ) ORDER BY `sd_courses`.`from_date` ASC LIMIT 0, 10
Probably AND has been missed between two conditions or some thing wrong on my end
Screen Shots attached
Rakesh