Hi,
I want to ask, I found an error like this when I set advanced setting - user ID - t_orders - id_orders.
I use linked tables.
when I remove id_orders from user ID there is no problem?
how to make 'SELECT id_order...' like SELECT db_data_center.t_orders.
id_order...'
Error : D:\XAMPP\htdocs\project1\vendor\doctrine\dbal\src\Driver\API\MySQL\ExceptionConverter.php(49): An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db_data_center.t_orders' doesn't exist
debug result :
#0 D:\XAMPP\htdocs\project1\vendor \doctrine\dbal\src\Connection.php(1939): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))
#1 D:\XAMPP\htdocs\project1\vendor\doctrine\dbal\src\Connection.php(1881): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))
#2 D:\XAMPP\htdocs\project1\vendor\doctrine\dbal\src\Connection.php(1 106): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT `id_order...', Array, Array)
#3 D:\XAMPP\htdocs\project1\vendor\doctrine\dbal\src\Connection.php(902): Doctrine\DBAL\Connection->executeQuery('SELECT `order_id...', Array, Array)
#4 D:\XAMPP\htdocs\project1\vendor\doctrine\dbal\src\Connection.php(1152): Doctrine\DBAL\Connection->fetchAllAssociative('SELECT `order_id...', Array, Array)
#5 D:\XAMPP\htdocs\project1\models\TOrders.php(1642): rine\DBAL\Connection->executeCacheQuery('SELECT `order_id...', Array, Array, Object(Doctrine\DBAL\Cache\QueryCacheProfile))
#6 D:\XAMPP\htdocs\project1\models\TOrdersItem.php(1679): PHPMaker2024\GAProject\TOrders->getUserIDSubquery(Object(PHPMaker2024\GAProject\DbField), Object(PHPMaker2024\GAProject\DbField))
#7 D:\XAMPP\htdocs\project1\models\TOrdersItem.php(633): PHPMaker2024\GAProject\TOrdersItem->addDetailUserIDFilter('', 't_orders')
#8 D:\XAMPP\htdocs\project1\models\TOrdersItemGrid.php(743): PHPMaker2024\GAProject\TOrdersItem->applyUserIDFilters('')
#9 D:\XAMPP\htdocs\project1\views\TOrdersItemGrid.php(7): PHPMaker2024\GAProject\TOrdersItemGrid->run()
#10 D:\XAMPP\htdocs\project1\views\TOrdersAdd.php(237): include_once('D:\\XAMPP\\htdocs...')
#11 D:\XAMPP\htdocs\project1\vendor\slim\php-view\src\PhpRenderer.php(219): include('D:\\XAMPP\\htdocs...')