1. NOTICE: If you are using Fabrik and update to Joomla 3.10, you will need to update to Fabrik 3.10. And, if you are using Fabrik, do not upgrade to Joomla 4, we do not have a supported version ready for release. More information on a release date coming soon. Also, please note that Fabrik 3.10 will not install on any Joomla sites less than 3.8.
    Dismiss Notice

Color Picker Problem

Discussion in 'Community' started by idrive72, Jul 26, 2022.

  1. idrive72

    idrive72 New Member

    Level: Community
    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
     
    Last edited: Jul 26, 2022
  2. lousyfool

    lousyfool Well-Known Member

    Level: Community
    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...
     
  3. idrive72

    idrive72 New Member

    Level: Community
    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.
     
  4. lousyfool

    lousyfool Well-Known Member

    Level: Community
    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.
     
  5. idrive72

    idrive72 New Member

    Level: Community
    Yes, I want to deepen to try to understand.

    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.
     
  6. lousyfool

    lousyfool Well-Known Member

    Level: Community
    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?
     

Share This Page