[markdaps]

Hi,

When clicking on browse locations, or viewing a category, etc, from the front-end, a fatal error is logged.

Error:

Code: Select all

Fatal Error: Database (1064) SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM pmd_locations WHERE left_ BETWEEN '1' AND '3' AND (level=1 OR (level=2 A...' at line 1 in file /home/sites/.../public_html/directory/includes/class_database.php on line 211 (SQL: SELECT  FROM pmd_locations WHERE left_ BETWEEN '1' AND '3' AND (level=1 OR (level=2 AND child_row_id <= 6))  ORDER BY left_) in /home/sites/.../public_html/directory/includes/class_database.php on line 216

PS: I posted in the Git issues section before I realised that you had a forum for bug reporting.

Thanks

[administrator]

I will forward this to the developer to fix.

[administrator]

I am happy you folks are doing what I asked, click on everything!!

[administrator]

Hello Mark Can you please tell me a bit more about error share url or page having the error

[administrator]

Thanks for reporting error mark I fixed the error here is the modified file please update this file on your server
Here is the Path
\includes\class_database.php

[markdaps]

Thanks for fix.

I never had notification for replies to this topic turned on, and therefore missed your messages regarding this.