bjohnson045 / phpMyDirectory

https://www.phpmydirectory.com
GNU General Public License v3.0
34 stars 21 forks source link

Fatal Error: Database (1064) SQLSTATE[42000] When viewing a listing category #11

Closed markdaps closed 3 years ago

markdaps commented 3 years ago

When visiting a category from the front-end, a fatal db error 1064 occurs. A single primary category has been added, and attached to a test listing.

// 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 pmdlocations WHERE left BETWEEN '1' AND '3' AND (level=1 OR (level=2 A...' at line 1 in file /home/sites/10a/a/a2fe61e45c/public_html/directory/includes/class_database.php on line 211 (SQL: SELECT FROM pmdlocations WHERE left BETWEEN '1' AND '3' AND (level=1 OR (level=2 AND child_rowid <= 6)) ORDER BY left) in /home/sites/.../directory/includes/class_database.php on line 216 //

markdaps commented 3 years ago

This issue has been patched.