Color Picker Problem

[idrive72]

Hi everyone, I have a problem with the "Color Picker" plugin. I created a form containing 4 Color Picker elements with appropriate default values. When I go to select the colors and save the form, the confirmation message appears regularly but nothing is written in the database. I searched the forum for something that could help me but I didn't find anything like it. Can you help me?

Thank you

Guido

P.S.
I use Joomla 3.10.10
Fabrik 3.10
MariaDB 10.4.24
Apache 2.4.53 (Win64) OpenSSL/1.1.1n PHP/8.0.19

 

[lousyfool]

What do you mean by "nothing is written in the database"? The cell remains empty, not even the default value (like 0,0,0 or whatever it is)?
Any JS error or else?
I have it working without any problem here...

 

[idrive72]

Yes, nothing is written in the db, completely empty despite the confirmation message.
I suspect it depends on PHP8 because I did a test on another site that I run with PHP7.4 and it worked right away. I am thrilled!
I found that if in the "Fabrik form option" I do not insert anything in place of "-1" in the row ID and the same in keyname, the record is saved regularly. Now I am trying to use the "autofill" plugin to recover the data from the db. It seems to go but I don't know if it's the right method.

 

[lousyfool]

The site where I'm using the colour picker is on PHP 7 as well, so it might be a PHP 8 thing, indeed.
You should then get an error with Joomla's error reporting set to max, telling us more and where to look.
It seems that not many people are using the colour picker -- at least with PHP 8 -- which may explain why there were no reports yet.

Not sure what you mean by "recover data from the db" and what you're trying to do, but if it's about the colour picker trouble, I don't think autofill is going to do anything for you. To fill in the colour picker "blanks" in the DB, you'll probably want to use phpMyAdmin.

 

[idrive72]

The site where I'm using the colour picker is on PHP 7 as well, so it might be a PHP 8 thing, indeed.
You should then get an error with Joomla's error reporting set to max, telling us more and where to look.
It seems that not many people are using the colour picker -- at least with PHP 8 -- which may explain why there were no reports yet.

Yes, I want to deepen to try to understand.

Not sure what you mean by "recover data from the db" and what you're trying to do, but if it's about the colour picker trouble, I don't think autofill is going to do anything for you. To fill in the colour picker "blanks" in the DB, you'll probably want to use phpMyAdmin.

Translation error from Italian, I meant "read data from db". As mentioned in the previous post, if I don't filter the data based on the user logged in the form page, when I save, the data is written in the db regularly. So, by reopening the same form, using the autofill plugin, I can see the data just saved. I hope I explained myself.
However, I noticed that, from time to time, autofill fails to read the data from the db and sometimes everything is ok. This behavior is strange and should never happen.

 

[lousyfool]

As mentioned in the previous post, if I don't filter the data based on the user logged in the form page, when I save, the data is written in the db regularly. So, by reopening the same form, using the autofill plugin, I can see the data just saved. I hope I explained myself.
However, I noticed that, from time to time, autofill fails to read the data from the db and sometimes everything is ok. This behavior is strange and should never happen.

Maybe it's me, maybe it's a translation thing, but the title and your initial post in this thread was about the colour picker value not being stored in the database, at least under PHP 8. Are we still talking about this?
Did you check in phpMyAdmin if the entire new record is missing, or if only the colour picker cell is empty?
As asked before: Do you have JS errors in the browser console? With Joomla error reporting set to maximum, do you have errors on the page?
Did you try PHP 7 instead of 8 on this site, and does the problem then still persist or go away?