frontend-submit-form: "Unknown column 'Array' in 'where clause'"

More
2 years 2 months ago #82850 by ggppdk
Hello
this will occur if $item->created_by is an array , but item->created_by should be a numeric (an integer)

but how can the above happen ? maybe some plugin during content plugin made the modification ?


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
2 years 2 months ago - 2 years 2 months ago #82864 by kath

Hello
this will occur if $item->created_by is an array , but item->created_by should be a numeric (an integer)

but how can the above happen ? maybe some plugin during content plugin made the modification ?

 
Uh, I have no idea, don't know about any 'non-regular' plugins running.
There are notifications about those Frontend-item-creations. Those Notifications go to a uer group and two users. Might that have to do something with the error?

EDIT:
The content type that can be created via my frontend-form has three custom fields (textarea, image Reusable (DB mode), checkbox).
The textarea and the checkbox both have -in their field configs- in "viewing" > "content plugins" > "Trigger content plugins"=no.
The image(s) field does not show info about content plugins.
Last edit: 2 years 2 months ago by kath. Reason: Added more detailed information.

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago - 2 years 1 month ago #82959 by kath
Hi there,

sorry to nag here, but I'm still stuck on this: Installed a local copy to further investigate, and this is the call stack:Unknown column 'Array' in 'where clause'

---
Unknown column 'Array' in 'where clause'
C:\xampp\htdocs\[...]]\libraries\joomla\database\driver\mysqli.php:610
Call stack
#     Function     Location
1     ()   JROOT\libraries\joomla\database\driver\mysqli.php:610
2     mysqli_query()     JROOT\libraries\joomla\database\driver\mysqli.php:610
3     JDatabaseDriverMysqli->execute()     JROOT\libraries\joomla\database\driver.php:1740
4     JDatabaseDriver->loadResult()     JROOT\libraries\src\User\UserHelper.php:297
5     Joomla\CMS\User\UserHelper::getUserId()     JROOT\libraries\src\User\UserWrapper.php:134
6     Joomla\CMS\User\UserWrapper->getUserId()     JROOT\libraries\src\User\User.php:280
7     Joomla\CMS\User\User::getInstance()     JROOT\libraries\src\Factory.php:266
8     Joomla\CMS\Factory::getUser()     JROOT\administrator\components\com_flexicontent\views\item\view.html.php:1285
9     FlexicontentViewItem->_buildEditLists()     JROOT\administrator\components\com_flexicontent\views\item\view.html.php:714
10     FlexicontentViewItem->_displayForm()     JROOT\administrator\components\com_flexicontent\views\item\view.html.php:49
11     FlexicontentViewItem->display()     JROOT\administrator\components\com_flexicontent\controllers\items.php:1470
12     FlexicontentControllerItems->edit()     JROOT\libraries\src\MVC\Controller\BaseController.php:702
13     Joomla\CMS\MVC\Controller\BaseController->execute()     JROOT\components\com_flexicontent\flexicontent.php:270
14     require_once()     JROOT\libraries\src\Component\ComponentHelper.php:402
15     Joomla\CMS\Component\ComponentHelper::executeComponent()     JROOT\libraries\src\Component\ComponentHelper.php:377
16     Joomla\CMS\Component\ComponentHelper::renderComponent()     JROOT\libraries\src\Application\SiteApplication.php:194
17     Joomla\CMS\Application\SiteApplication->dispatch()     JROOT\libraries\src\Application\SiteApplication.php:233
18     Joomla\CMS\Application\SiteApplication->doExecute()     JROOT\libraries\src\Application\CMSApplication.php:225
19     Joomla\CMS\Application\CMSApplication->execute()     JROOT\index.php:49
---

The page is of type FlexiContent > Submission form.

Joomla! 3.10.11
php 8.1.10
Flexicontent 4.1.3

I disabled all plugins (except a captcha-plugin because the page type seems to want one there.)

Thanks a lot!
Last edit: 2 years 1 month ago by kath. Reason: fixed broken table-formatting in post

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #82960 by ggppdk
Hello

Micker has replicated it , it seems that it is an FC bug
i will try to address this tomorrow or the day after


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #82972 by kath

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #83000 by kath
Hi guys,

is there any news on this? Even any quickfix for the meantime would be highly appreciated.

Thanks for gettting to me! :)
Ben

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.765 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline