PDO::query(): Argument #1 ($query) cannot be empty

PHPMaker General Discussion (PHPMaker)
1

it started showing the error: http://localhost/base_path/MyTableList in some generated pages. Does anyone know what can it be?MariaDB 10.3.34

2

You may enable debug and also check HTTP response to see what’s the cause of the error you mentioned.Post the error message then for more discussion.

3

in my case… I’m used to creating Views with the purpose of feeding drop-down lists and so I uncheck the option to generate the code… from what I’ve seen, the update is no longer allowing this and the error happens… I go pass this information on to see if support verifies

4

Are you sure? It seems you’re using SQL Server database; there is dbo schema in your SQL above.

5

C:\xampp\htdocs\sms_dev\vendor\doctrine\dbal\src\Driver\PDO\Connection.php(69): PDO::query(): Argument #1 ($query) cannot be emptyDebug

#0 C:\xampp\htdocs\sms_dev\vendor\doctrine\dbal\src\Driver\PDO\Connection.php(69): PDO->query('')
#1 C:\xampp\htdocs\sms_dev\vendor\doctrine\dbal\src\Connection.php(1065): Doctrine\DBAL\Driver\PDO\Connection->query('')
#2 C:\xampp\htdocs\sms_dev\vendor\doctrine\dbal\src\Connection.php(866): Doctrine\DBAL\Connection->executeQuery('', Array, Array)
#3 C:\xampp\htdocs\sms_dev\vendor\doctrine\dbal\src\Connection.php(1112): Doctrine\DBAL\Connection->fetchAllAssociative('', Array, Array)
#4 C:\xampp\htdocs\sms_dev\models\TbTreinRealizadoList.php(2225): Doctrine\DBAL\Connection->executeCacheQuery('', Array, Array, Object(Doctrine\DBAL\Cache\QueryCacheProfile))
#5 C:\xampp\htdocs\sms_dev\models\TbTreinRealizadoList.php(2011): PHPMaker2023\sms\TbTreinRealizadoList->renderRow()
#6 C:\xampp\htdocs\sms_dev\views\TbTreinRealizadoList.php(202): PHPMaker2023\sms\TbTreinRealizadoList->setupRow()
#7 C:\xampp\htdocs\sms_dev\vendor\slim\php-view\src\PhpRenderer.php(215): include('C:\\xampp\\htdocs...')
#8 C:\xampp\htdocs\sms_dev\vendor\slim\php-view\src\PhpRenderer.php(183): Slim\Views\PhpRenderer->protectedIncludeScope('views/TbTreinRe...', Array)
#9 C:\xampp\htdocs\sms_dev\vendor\slim\php-view\src\PhpRenderer.php(152): Slim\Views\PhpRenderer->fetchTemplate('TbTreinRealizad...', Array)
#10 C:\xampp\htdocs\sms_dev\vendor\slim\php-view\src\PhpRenderer.php(49): Slim\Views\PhpRenderer->fetch('TbTreinRealizad...', Array, true)
#11 C:\xampp\htdocs\sms_dev\controllers\ControllerBase.php(74): Slim\Views\PhpRenderer->render(Object(Slim\Http\Response), 'TbTreinRealizad...', Array)
#12 C:\xampp\htdocs\sms_dev\controllers\TbTreinRealizadoController.php(14): PHPMaker2023\sms\ControllerBase->runPage(Object(Slim\Http\ServerRequest), Object(Slim\Http\Response), Array, 'TbTreinRealizad...')
...
6

juniorpinto wrote:

so I uncheck the option to generate the code… from what I’ve seen, the update is no longer allowing this and the error happens… >

So, if you give a tick mark to generate the code, does the error not happen?

7

Note that if you use view as lookup table, you do need to generate scripts for the view. (You don’t need to enable them in the menu editor though.)