Prepare error: ERROR: invalid input syntax for type date: "" LINE 1: ...VISIT_TIME" FROM "RECEPTION" WHERE "VISIT_DATE" = '' AND "TO... ^
В файле: /var/www/toop/library/X1/Db/Adapter/Pgsql.php:289
#0 /var/www/toop/library/X1/Db/Statement.php(62): X1\Db\Adapter\Pgsql->prepare('SELECT "VISIT_T...')
#1 /var/www/toop/library/X1/Db/Adapter.php(108): X1\Db\Statement->__construct(Object(X1\Db\Adapter\Pgsql), 'SELECT "VISIT_T...', Array)
#2 /var/www/toop/library/X1/Db/Adapter/Pgsql.php(128): X1\Db\Adapter->query('SELECT "VISIT_T...', NULL)
#3 /var/www/toop/webapps/toop/controllers/ReceptionController.php(127): X1\Db\Adapter\Pgsql->fetchAll('SELECT "VISIT_T...')
#4 /var/www/toop/library/X1/MVC/Control.php(101): toop\ReceptionController->availableTime()
#5 /var/www/toop/library/X1/MVC/Control.php(66): X1\MVC\Control->tryAction('availableTime')
#6 /var/www/toop/library/X1/MVC/Controller.php(60): X1\MVC\Control->run(Object(X1\MVC\Request))
#7 /var/www/toop/library/X1/MVC/Dispatcher.php(84): X1\MVC\Controller->run(Object(X1\MVC\Request))
#8 /var/www/toop/library/X1/App/FrontController.php(144): X1\MVC\Dispatcher->dispatch()
#9 /var/www/toop/public/index.php(36): X1\App\FrontController->run()
#10 {main}
SELECT "MAXRECEPTIONS" FROM "FILIALS" WHERE "HOST" = 'mytishchi.opeka.mosreg.ru' AND "SYS_STATE" = '0' AND "ADDRESS" = ''