search

bjohnson045 / phpMyDirectory

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

1.5.3 - class_database error when try to delete locations #41

Open moonslice opened 2 years ago

moonslice commented 2 years ago

I'm trying to delete locations on a 1.5.3 pmd site, but when I try, I get error

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 'AND' at line 1 in file /home/find.../public_html/includes/class_database.php on line 202 (SQL: SELECT COUNT(*) FROM pmd153_listings l INNER JOIN pmd153_locations lc ON l.locationid=lc.id WHERE lc.left BETWEEN AND ) in /home/find.../public_html/includes/class_database.php on line 207

I tried uploading the opensource class_database.php file, but that didn't help.

Any suggestions or ideas how to edit that php file to work?

thanks!

sirslmarx commented 2 years ago

I have the same problem but with a different error code Fatal error: Call to undefined method Locations::getFullCount() in /home/sirsam/public_html/cp/admin_locations.php on line 26

Not sure how to fix this