7webcreator
Member
The database join is in a repeat group. The radiobutton element is not set for the filter but can be selected for the update. With PHP 7, I don't get this error message.
UPDATE
FILTER
UPDATE
FILTER
-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
date filter issue with php 8
- Thread starter 7webcreator
- Start date
The strange thing is that your error stack is showing "advanced search".
You say you don't have advanced search enabled.
As far as I know the update_col is using advanced search parts, so
if you disable the update_col plugin - does is still show the error during filtering?
You say you don't have advanced search enabled.
As far as I know the update_col is using advanced search parts, so
if you disable the update_col plugin - does is still show the error during filtering?
7webcreator
Member
Ah! I have advanced search enabled, but I have used the standard search for filtering.
I have now disabled the advanced search, and the results are displaying correctly. However, when I try to update a column from the results obtained using the date for filtering, I get an error 500.
I have now disabled the advanced search, and the results are displaying correctly. However, when I try to update a column from the results obtained using the date for filtering, I get an error 500.
Ok. One step back.
I can see the stripslashes error if I use Advanced search on an element in a repeatgroup (Advanced search is spinning in this case, the error can be seen in the network response).
I didn't test but I assume this is also the case with php7. Advanced search has issues (e.g. jdate not working, filter type auto-complete not working etc.)
I can't replicate the error in the normal filter even if additionally Advanced search is enabled.
But if it's working for you with Advanced search disabled it's ok.
Update-col with user selection is using the filter layout of elements which are set to be list filters. Which often doesn't make sense (e.g. date element with range filter is showing as range; field with dropdown filter as a dropdown so you never can set a "new" value etc).
So what is your exact setup (which elements are included in the update-col, which elements of these are also list filters (and which filter type), which element did you try to update etc.)?
"error 500": What do you get in your browser console in this case?
Did you clear all J! and browser cache?
It it really working with exactly the same setup with php7 (i.e. just by switching your site's php version)?
I can see the stripslashes error if I use Advanced search on an element in a repeatgroup (Advanced search is spinning in this case, the error can be seen in the network response).
I didn't test but I assume this is also the case with php7. Advanced search has issues (e.g. jdate not working, filter type auto-complete not working etc.)
I can't replicate the error in the normal filter even if additionally Advanced search is enabled.
But if it's working for you with Advanced search disabled it's ok.
Update-col with user selection is using the filter layout of elements which are set to be list filters. Which often doesn't make sense (e.g. date element with range filter is showing as range; field with dropdown filter as a dropdown so you never can set a "new" value etc).
So what is your exact setup (which elements are included in the update-col, which elements of these are also list filters (and which filter type), which element did you try to update etc.)?
"error 500": What do you get in your browser console in this case?
Did you clear all J! and browser cache?
It it really working with exactly the same setup with php7 (i.e. just by switching your site's php version)?
7webcreator
Member
I can confirm that there is no error with PHP 7 and "Advanced search" abled.
The form has six groups. Only one group (GROUP 1) contains repeatable elements.
GROUP 1
Form with a group containing repeatable elements highlighted in yellow and which are included in the update-col
1 x databasejoin
1 x radiobutton
GROUP 2
NO repeatable element in this group - Elements highlighted in yellow are included in the update-col
GROUP 3
GROUP 4
GROUP 5
GROUP 6
When I do an update-col on any element of the results obtained with the filter set by dates, I get the following error message
The form has six groups. Only one group (GROUP 1) contains repeatable elements.
GROUP 1
Form with a group containing repeatable elements highlighted in yellow and which are included in the update-col
1 x databasejoin
1 x radiobutton
GROUP 2
NO repeatable element in this group - Elements highlighted in yellow are included in the update-col
GROUP 3
GROUP 4
GROUP 5
GROUP 6
When I do an update-col on any element of the results obtained with the filter set by dates, I get the following error message
Sorry, I can't replicate.
What does the console show if you click on the circle with the arrows (should open the network response) and then look at "Preview"?
Maybe you can narrow down the issue by deactivating groups and elements etc.
BTW: What is the sense of having update-col on a repeat-group element?
What does the console show if you click on the circle with the arrows (should open the network response) and then look at "Preview"?
Maybe you can narrow down the issue by deactivating groups and elements etc.
BTW: What is the sense of having update-col on a repeat-group element?
7webcreator
Member
I think the issue is with the date plugin element. When I filter the list with any other field (not a date), I don't get an error when I update a column or several columns.
About the update-col on a repeat group element, the list gathers students attending the same classroom and students attending different classrooms. There are group lessons and individual lessons. That is why in this case, it is needed.
7webcreator
Member
Below are screenshots of what I get when I click on the blue arrows and the date element settings
7webcreator
Member
Thank you for your reply.
The below screenshot is what I have when I click on the preview tab. I have changed the date format to Y-m-d, and the update-col works. However, this date format will confuse the users, as most are Italian. Is it a way to display the date D j M y without having this error?
The below screenshot is what I have when I click on the preview tab. I have changed the date format to Y-m-d, and the update-col works. However, this date format will confuse the users, as most are Italian. Is it a way to display the date D j M y without having this error?
7webcreator
Member
Thank you very much. It is now working with this format too. 
That is the best support ever.
That is the best support ever.