• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

error 500 - Column 'id' in field list is ambiguous

SoilentRed

Caaan do!
I'm trying to make this app for victims of Harvey to express a need and site users commits to fulfill that need. I have two list, needs and fulfillments. then I'll have another list that combines the two to show which request have been fulfilled and which have not that can still be.

I'm still in testing and debugging mode - working on the back end of joomla. I'm working on wamp. I've enabled debugging in fabrik and appended &fabrikdebug=1 to the end of my url, but it doesn't report anything. This is the full error I receive after enabling debug system in system setting and development for error reporting.

An error has occurred.
500 Fabrik has generated an incorrect query for the list Harvey Relief Fulfillment: <br /><br /><pre>Column 'id' in field list is ambiguous</pre>

Call stack
#
Function Location
1 () JROOT\components\com_fabrik\models\list.php:930
2 FabrikFEModelList->getData() JROOT\components\com_fabrik\models\list.php:700
3 FabrikFEModelList->render() JROOT\components\com_fabrik\views\list\view.base.php:405
4 FabrikViewListBase->display() JROOT\components\com_fabrik\views\list\view.html.php:41
5 FabrikViewList->display() JROOT\libraries\joomla\cache\controller\view.php:98
6 JCacheControllerView->get() JROOT\administrator\components\com_fabrik\controllers\list.php:153
7 FabrikAdminControllerList->view() JROOT\libraries\legacy\controller\legacy.php:709
8 JControllerLegacy->execute() JROOT\administrator\components\com_fabrik\fabrik.php:86
9 require_once() JROOT\libraries\cms\component\helper.php:389
10 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:364
11 JComponentHelper::renderComponent() JROOT\libraries\cms\application\administrator.php:98
12 JApplicationAdministrator->dispatch() JROOT\libraries\cms\application\administrator.php:156
13 JApplicationAdministrator->doExecute() JROOT\libraries\cms\application\cms.php:265
14 JApplicationCms->execute() JROOT\administrator\index.php:51

What are your thoughts here? As always, I value your input and am eternally grateful.

Hope you are well!
 
are you using dbjoin elements with concat label or data where and addressing an id element in your query?
Use {thistable}.id (Fabrik will replace it with the correct table alias)

Gesendet von meinem GT-I9300 mit Tapatalk
 
I also got this problem, and the debug code wasn't intuitive. The answer from Troester fixed it.

For me I had a cascading dropdown element:
Code:
issue, ' ', pain_code

The code that worked was:
Code:
{thistable}.issue, ' ', {thistable}.pain_code

Hope this helps others.
 
Last edited:
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top