Forums

issue with AbstractMySQLDriver.php

Permalink
Hi guys,

Hope you're well,

I'm really stuck on this problem while updating a custom package to 5.7 - Its to do with a model file which sorts out the table/pagination display from the database - the problem is throwing this error:

"An exception occurred while executing ' where 1=1 limit 0,500 ': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where 1=1 limit 0,500' at line 1"

The header of the model file looks like this:

namespace Concrete\Package\TourManager\Src;
use Concrete\Core\Legacy\DatabaseItemList as DatabaseItemList;
use Loader;
use Core;
class TourItemList extends DatabaseItemList {
   protected $autoSortColumns = array();
   protected $searchColumns = array();
   protected $sortByString;
   protected $itemsPerPage = 500;
   protected $enableStickySearchRequest;
   private $stickySortArray = array();
   private $inactivityFilters = array();
   private $dateFormat;
   private $listQuery;
   private $fieldMap;
Viewing 15 lines of 16 lines. View entire code block.


and the bit that's causing the problem is this function inside the model file:

public function getTourItemsPerPage() {
      return $this->itemsPerPage;
   }


Please any assistance would be greatly appreciated!

Thanks,
Omar
omars786