I am trying to debug this problem I am having:
My question is how do I figure out what the query that problem actually is.
The list in question is made up of three fields, two of them are data joins. Each of those data joins link to lists which also have multiple fields and data joins as well.
An error has occurred.
500 Fabrik has generated an incorrect query for the list <database name>: <br />
Call stack
# Function Location
1 JApplicationCms->execute() H:\Applications\xampp\htdocs\joomla\administrator\index.php:51
2 JApplicationAdministrator->doExecute() H:\Applications\xampp\htdocs\joomla\libraries\cms\application\cms.php:261
3 JApplicationAdministrator->dispatch() H:\Applications\xampp\htdocs\joomla\libraries\cms\application\administrator.php:152
4 JComponentHelper::renderComponent() H:\Applications\xampp\htdocs\joomla\libraries\cms\application\administrator.php:98
5 JComponentHelper::executeComponent() H:\Applications\xampp\htdocs\joomla\libraries\cms\component\helper.php:380
6 require_once() H:\Applications\xampp\htdocs\joomla\libraries\cms\component\helper.php:405
7 JControllerLegacy->execute() H:\Applications\xampp\htdocs\joomla\administrator\components\com_fabrik\fabrik.php:86
8 FabrikAdminControllerList->view() H:\Applications\xampp\htdocs\joomla\libraries\legacy\controller\legacy.php:702
9 JCacheControllerView->get() H:\Applications\xampp\htdocs\joomla\administrator\components\com_fabrik\controllers\list.php:153
10 FabrikViewList->display() H:\Applications\xampp\htdocs\joomla\libraries\joomla\cache\controller\view.php:95
11 FabrikViewListBase->display() H:\Applications\xampp\htdocs\joomla\components\com_fabrik\views\list\view.html.php:41
12 FabrikFEModelList->render() H:\Applications\xampp\htdocs\joomla\components\com_fabrik\views\list\view.base.php:400
13 FabrikFEModelList->getData() H:\Applications\xampp\htdocs\joomla\components\com_fabrik\models\list.php:683
500 Fabrik has generated an incorrect query for the list <database name>: <br />
Call stack
# Function Location
1 JApplicationCms->execute() H:\Applications\xampp\htdocs\joomla\administrator\index.php:51
2 JApplicationAdministrator->doExecute() H:\Applications\xampp\htdocs\joomla\libraries\cms\application\cms.php:261
3 JApplicationAdministrator->dispatch() H:\Applications\xampp\htdocs\joomla\libraries\cms\application\administrator.php:152
4 JComponentHelper::renderComponent() H:\Applications\xampp\htdocs\joomla\libraries\cms\application\administrator.php:98
5 JComponentHelper::executeComponent() H:\Applications\xampp\htdocs\joomla\libraries\cms\component\helper.php:380
6 require_once() H:\Applications\xampp\htdocs\joomla\libraries\cms\component\helper.php:405
7 JControllerLegacy->execute() H:\Applications\xampp\htdocs\joomla\administrator\components\com_fabrik\fabrik.php:86
8 FabrikAdminControllerList->view() H:\Applications\xampp\htdocs\joomla\libraries\legacy\controller\legacy.php:702
9 JCacheControllerView->get() H:\Applications\xampp\htdocs\joomla\administrator\components\com_fabrik\controllers\list.php:153
10 FabrikViewList->display() H:\Applications\xampp\htdocs\joomla\libraries\joomla\cache\controller\view.php:95
11 FabrikViewListBase->display() H:\Applications\xampp\htdocs\joomla\components\com_fabrik\views\list\view.html.php:41
12 FabrikFEModelList->render() H:\Applications\xampp\htdocs\joomla\components\com_fabrik\views\list\view.base.php:400
13 FabrikFEModelList->getData() H:\Applications\xampp\htdocs\joomla\components\com_fabrik\models\list.php:683
My question is how do I figure out what the query that problem actually is.
The list in question is made up of three fields, two of them are data joins. Each of those data joins link to lists which also have multiple fields and data joins as well.