MY-Directory

Posted: **February 5th, 2021, 8:06 pm**

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

Posted: **February 6th, 2021, 8:26 am**

I will forward this to the developer to fix.

Posted: **February 6th, 2021, 9:08 am**

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

Posted: **February 6th, 2021, 11:17 am**

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

Posted: **February 6th, 2021, 1:53 pm**

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

Posted: **February 7th, 2021, 9:32 am**

Thanks for fix.

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

MY-Directory

Fatal DB Err when viewing Category or Location

Fatal DB Err when viewing Category or Location

Re: Fatal DB Err when viewing Category or Location

Re: Fatal DB Err when viewing Category or Location

Re: Fatal DB Err when viewing Category or Location

Re: Fatal DB Err when viewing Category or Location

Re: Fatal DB Err when viewing Category or Location