Notice: Trying to get property 'id' of non-object in /var/www/vhosts/gruppomegawatt.it/gruppomegawatt.it/app/controllers/locations_controller.php on line 6
Database Error
Message:MySQL Query fail: SELECT bancos.*, locations.city FROM `bancos` LEFT OUTER JOIN `locations` ON `bancos`.`location_id` = `locations`.`id` WHERE bancos.portal_id = 1 AND bancos.location_id = AND active = 1 AND date(pubbl_start) <= DATE(NOW()) AND date(pubbl_end) >= DATE(NOW()) ORDER BY date_start ASC
MySQL Error:MySQL Query fail: SELECT bancos.*, locations.city FROM `bancos` LEFT OUTER JOIN `locations` ON `bancos`.`location_id` = `locations`.`id` WHERE bancos.portal_id = 1 AND bancos.location_id = AND active = 1 AND date(pubbl_start) <= DATE(NOW()) AND date(pubbl_end) >= DATE(NOW()) ORDER BY date_start ASC: 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 active = 1 AND date(pubbl_start) <= DATE(NOW()) AND date(pubbl_end) >= DATE(' at line 4
Date:Sunday, September 26, 2021 at 6:28:58 PM
Script:/punti-vendita/automazione
Backtrace:#0 Database->oops(MySQL Query fail: SELECT bancos.*, locations.city FROM `bancos` LEFT OUTER JOIN `locations` ON `bancos`.`location_id` = `locations`.`id` WHERE bancos.portal_id = 1 AND bancos.location_id = AND active = 1 AND date(pubbl_start) <= DATE(NOW()) AND date(pubbl_end) >= DATE(NOW()) ORDER BY date_start ASC) called at [/var/www/vhosts/gruppomegawatt.it/gruppomegawatt.it/framework/database.php:177] #1 Database->query(SELECT bancos.*, locations.city FROM `bancos` LEFT OUTER JOIN `locations` ON `bancos`.`location_id` = `locations`.`id` WHERE bancos.portal_id = 1 AND bancos.location_id = AND active = 1 AND date(pubbl_start) <= DATE(NOW()) AND date(pubbl_end) >= DATE(NOW()) ORDER BY date_start ASC) called at [/var/www/vhosts/gruppomegawatt.it/gruppomegawatt.it/app/models/banco.php:181] #2 Banco->raw_find2(date_start ASC, , 1) called at [/var/www/vhosts/gruppomegawatt.it/gruppomegawatt.it/app/controllers/locations_controller.php:6] #3 LocationsController->show() called at [/var/www/vhosts/gruppomegawatt.it/gruppomegawatt.it/framework/base_controller.php:64] #4 BaseController->action(show) called at [/var/www/vhosts/gruppomegawatt.it/gruppomegawatt.it/index.php:32]