Jump to content

Pagination error


Ehsanai

Recommended Posts

I enable the debug but I have error with this when open the product page:

[PrestaShopDatabaseException]

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 '() LIMIT 8' at line 23

Is it related to that error?

Link to comment
Share on other sites

  • 3 weeks later...

Same error. 

(1/1) ContextErrorException
User Notice: Integer value is expected, got `double`

in Pagination.php line 49
at Pagination->setPagesCount(22.0)
in ProductListingFrontController.php line 413
at ProductListingFrontControllerCore->getTemplateVarPagination(object(ProductSearchQuery), object(ProductSearchResult))
in ProductListingFrontController.php line 351
at ProductListingFrontControllerCore->getProductSearchVariables()
in ProductListingFrontController.php line 513
at ProductListingFrontControllerCore->doProductSearch('catalog/listing/category', array('entity' => 'category', 'id' => 300))
in CategoryController.php line 137
at CategoryControllerCore->initContent()
in Controller.php line 292
at ControllerCore->run()
in Dispatcher.php line 515
at DispatcherCore->dispatch()
in index.php line 28

Link to comment
Share on other sites

anyone knows where pagescount drive the value from?

 

    public function setPagesCount($pagesCount)
    {
        if (!is_int($pagesCount)) {
            trigger_error(sprintf('Integer value is expected, got `%s`', gettype($pagesCount)), E_USER_NOTICE);
            $pagesCount = (int) $pagesCount;
        }

        $this->pagesCount = $pagesCount;

        return $this;
    }

Link to comment
Share on other sites

  • 2 months later...

Same error here after move PS 1.7.6.5 to new server😪.

I don't have the override of ProductListingFrontController.php in override>classes>controller, so this isn't a solution for me.

And I can't log in at the BO.

Anyone any idea?? 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...