Fatal DB Err when viewing Category or Location
  • markdaps
    Posts: 21
    Joined: February 5th, 2021, 7:31 pm

    Fatal DB Err when viewing Category or Location

    by markdaps » 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
    Mark M | Web Developer
  • User avatar
    administrator
    Site Admin
    Posts: 27
    Joined: February 4th, 2021, 2:08 pm

    Re: Fatal DB Err when viewing Category or Location

    by administrator » February 6th, 2021, 8:26 am

    I will forward this to the developer to fix.
  • User avatar
    administrator
    Site Admin
    Posts: 27
    Joined: February 4th, 2021, 2:08 pm

    Re: Fatal DB Err when viewing Category or Location

    by administrator » February 6th, 2021, 9:08 am

    I am happy you folks are doing what I asked, click on everything!!
  • User avatar
    administrator
    Site Admin
    Posts: 27
    Joined: February 4th, 2021, 2:08 pm

    Re: Fatal DB Err when viewing Category or Location

    by administrator » 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
  • User avatar
    administrator
    Site Admin
    Posts: 27
    Joined: February 4th, 2021, 2:08 pm

    Re: Fatal DB Err when viewing Category or Location

    by administrator » 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
    You do not have the required permissions to view the files attached to this post.
  • markdaps
    Posts: 21
    Joined: February 5th, 2021, 7:31 pm

    Re: Fatal DB Err when viewing Category or Location

    by markdaps » 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.
    Mark M | Web Developer

Who is online

Users browsing this forum: No registered users and 3 guests