| 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: | Thursday, September 21, 2023 at 3:04:23 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]
|