CodeIgniter\Database\Exceptions\DatabaseException

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 ') - abs( longitude - )) ASC LIMIT 1' at line 7

Callstack:

  1. CodeIgniter\Database\BaseConnection->query() in /homepages/18/d18865395/htdocs/bnb24/system/Database/BaseBuilder.php:1616
  2. CodeIgniter\Database\BaseBuilder->get() in /homepages/18/d18865395/htdocs/bnb24/app/Models/Accommodations.php:1319
  3. App\Models\Accommodations->getRegionData() in /homepages/18/d18865395/htdocs/bnb24/app/Controllers/Results.php:128
  4. App\Controllers\Results->view() in /homepages/18/d18865395/htdocs/bnb24/app/Controllers/Results.php:70
  5. App\Controllers\Results->city() in /homepages/18/d18865395/htdocs/bnb24/system/CodeIgniter.php:932
  6. CodeIgniter\CodeIgniter->runController() in /homepages/18/d18865395/htdocs/bnb24/system/CodeIgniter.php:497
  7. CodeIgniter\CodeIgniter->handleRequest() in /homepages/18/d18865395/htdocs/bnb24/system/CodeIgniter.php:366
  8. CodeIgniter\CodeIgniter->run() in /homepages/18/d18865395/htdocs/bnb24/index.php:67