witchypaws
Member
Having issues with a new list when trying to view the data
Turned on debug and getting the following
Fabrik has generated an incorrect query for the list Products: <br /><br /><pre>Unknown column 'whra_products.modified_by' in 'on clause'</pre><br /><pre> SELECT SQL_CALC_FOUND_ROWS DISTINCT `whra_products`.`prod_id` AS `whra_products___prod_id`, `whra_products`.`prod_id` AS `whra_products___prod_id_raw`, `whra_products`.`prod_created` AS `whra_products___prod_created`, `whra_products`.`prod_created` AS `whra_products___prod_created_raw`, `whra_products`.`prod_creator` AS `whra_products___prod_creator_raw`, `bwohc_users_1`.`name` AS `whra_products___prod_creator`, `whra_products`.`prod_modified` AS `whra_products___prod_modified`, `whra_products`.`prod_modified` AS `whra_products___prod_modified_raw`, `whra_products`.`prod_modified_by` AS `whra_products___prod_modified_by_raw`, `bwohc_users`.`name` AS `whra_products___prod_modified_by`, `whra_products`.`prod_product` AS `whra_products___prod_product`, `whra_products`.`prod_product` AS `whra_products___prod_product_raw`, `whra_products`.`prod_id` AS slug , `whra_products`.`prod_id` AS `__pk_val` FROM `whra_products` LEFT JOIN `#__users` AS `bwohc_users` ON `bwohc_users`.`id` = `whra_products`.`modified_by` LEFT JOIN `#__users` AS `bwohc_users_0` ON `bwohc_users_0`.`id` = `whra_products`.`prod_modified_by` LEFT JOIN `#__users` AS `bwohc_users_1` ON `bwohc_users_1`.`id` = `whra_products`.`creator` LEFT JOIN `#__users` AS `bwohc_users_2` ON `bwohc_users_2`.`id` = `whra_products`.`prod_creator`</pre><br />
/home/bocowhra/public_html/components/com_fabrik/models/list.php:948
Call stack
# Function Location
1 () JROOT/components/com_fabrik/models/list.php:948
2 FabrikFEModelList->getData() JROOT/components/com_fabrik/models/list.php:706
3 FabrikFEModelList->render() JROOT/components/com_fabrik/views/list/view.base.php:428
4 FabrikViewListBase->display() JROOT/components/com_fabrik/views/list/view.html.php:41
5 FabrikViewList->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102
6 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/administrator/components/com_fabrik/controllers/list.php:155
7 FabrikAdminControllerList->view() JROOT/libraries/src/MVC/Controller/BaseController.php:710
8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_fabrik/fabrik.php:87
9 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
10 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
11 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101
12 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159
13 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
14 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51
All my other lists working fine and created this the same as the others but don't know why it won't work
Please assist
Thanks Jacqui
Turned on debug and getting the following
Fabrik has generated an incorrect query for the list Products: <br /><br /><pre>Unknown column 'whra_products.modified_by' in 'on clause'</pre><br /><pre> SELECT SQL_CALC_FOUND_ROWS DISTINCT `whra_products`.`prod_id` AS `whra_products___prod_id`, `whra_products`.`prod_id` AS `whra_products___prod_id_raw`, `whra_products`.`prod_created` AS `whra_products___prod_created`, `whra_products`.`prod_created` AS `whra_products___prod_created_raw`, `whra_products`.`prod_creator` AS `whra_products___prod_creator_raw`, `bwohc_users_1`.`name` AS `whra_products___prod_creator`, `whra_products`.`prod_modified` AS `whra_products___prod_modified`, `whra_products`.`prod_modified` AS `whra_products___prod_modified_raw`, `whra_products`.`prod_modified_by` AS `whra_products___prod_modified_by_raw`, `bwohc_users`.`name` AS `whra_products___prod_modified_by`, `whra_products`.`prod_product` AS `whra_products___prod_product`, `whra_products`.`prod_product` AS `whra_products___prod_product_raw`, `whra_products`.`prod_id` AS slug , `whra_products`.`prod_id` AS `__pk_val` FROM `whra_products` LEFT JOIN `#__users` AS `bwohc_users` ON `bwohc_users`.`id` = `whra_products`.`modified_by` LEFT JOIN `#__users` AS `bwohc_users_0` ON `bwohc_users_0`.`id` = `whra_products`.`prod_modified_by` LEFT JOIN `#__users` AS `bwohc_users_1` ON `bwohc_users_1`.`id` = `whra_products`.`creator` LEFT JOIN `#__users` AS `bwohc_users_2` ON `bwohc_users_2`.`id` = `whra_products`.`prod_creator`</pre><br />
/home/bocowhra/public_html/components/com_fabrik/models/list.php:948
Call stack
# Function Location
1 () JROOT/components/com_fabrik/models/list.php:948
2 FabrikFEModelList->getData() JROOT/components/com_fabrik/models/list.php:706
3 FabrikFEModelList->render() JROOT/components/com_fabrik/views/list/view.base.php:428
4 FabrikViewListBase->display() JROOT/components/com_fabrik/views/list/view.html.php:41
5 FabrikViewList->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102
6 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/administrator/components/com_fabrik/controllers/list.php:155
7 FabrikAdminControllerList->view() JROOT/libraries/src/MVC/Controller/BaseController.php:710
8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_fabrik/fabrik.php:87
9 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
10 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
11 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101
12 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159
13 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
14 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51
All my other lists working fine and created this the same as the others but don't know why it won't work
Please assist
Thanks Jacqui