Error 500

[witchypaws]

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

 

[juuser]

Does the element "modified_by" still exist/is published in your "whra_products" list? And does the column "modified_by" exist in the database table when you check e.g. from PhpMyAdmin?

 

[troester]

In the element list there's only a prod_modified_by.

Additionally to @juuser : check elements in trash

 

[witchypaws]

Hi guys, thanks for your help

the element still existed, was published, etc

I managed to fix it by changing the element to a field, deleting the join in phpmyadmin, then resetting the element as a user join again. Once I had done that, it all started working again. No idea how it stopped working

Am blaming gremlins

Thanks

Jacqui