Notice (8): Undefined offset: 0 [APP/Controller/TemplatesController.php, line 106]

  
Notice (8): Undefined offset: 0 [APP/Controller/TemplatesController.php, line 110]

  
Warning (512): Unable to emit headers. Headers sent in file=/var/www/html/divaexports.in/vendor/cakephp/cakephp/src/Error/Debugger.php line=754 [CORE/src/Http/ResponseEmitter.php, line 48]

  
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/html/divaexports.in/vendor/cakephp/cakephp/src/Error/Debugger.php:754) [CORE/src/Http/ResponseEmitter.php, line 145]

  
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/html/divaexports.in/vendor/cakephp/cakephp/src/Error/Debugger.php:754) [CORE/src/Http/ResponseEmitter.php, line 173]

  
    
    
    Error: Database Error
    
    
  
  

Database Error PDOException

Documentation API

Error: 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 'GROUP BY album_id ORDER BY Albums.id desc LIMIT 9 OFFSET 0' at line 1

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.

SQL Query:

SELECT Products.id AS `Products__id`, Products.design_no AS `Products__design_no`, Products.album_id AS `Products__album_id`, Products.catalogno AS `Products__catalogno`, Products.brand AS `Products__brand`, Products.product AS `Products__product`, Products.fabric AS `Products__fabric`, Products.stock AS `Products__stock`, Products.total_products AS `Products__total_products`, Products.Image AS `Products__Image`, Products.subcategory AS `Products__subcategory`, Products.category_id AS `Products__category_id`, Products.wholesale_price AS `Products__wholesale_price`, Products.weight AS `Products__weight`, Products.created AS `Products__created`, Albums.id AS `Albums__id`, Albums.name AS `Albums__name`, Albums.slug AS `Albums__slug`, Albums.rate AS `Albums__rate`, Albums.weight AS `Albums__weight`, Albums.size AS `Albums__size`, Albums.high_resolution AS `Albums__high_resolution`, Albums.white_background AS `Albums__white_background`, Albums.page_desc AS `Albums__page_desc`, Albums.seo_title AS `Albums__seo_title`, Albums.seo_desc AS `Albums__seo_desc`, Albums.seo_keyword AS `Albums__seo_keyword`, Albums.created AS `Albums__created`, Albums.status AS `Albums__status` FROM products Products INNER JOIN albums Albums ON Albums.id = (Products.album_id) WHERE category_id=  GROUP BY album_id  ORDER BY Albums.id desc LIMIT 9 OFFSET 0

If you want to customize this error message, create src/Template/Error/pdo_error.ctp

toggle vendor stack frames