Skip to Content Skip to Menu

[SOLVED] Delimiter fields not emptying/updating correctly

10 years 7 months ago - 10 years 7 months ago #242986 by Michael2014
I´ve put quite a number of fields into a table/list that I created in the HTML area of the delimiter field.
Now when I want to clear the values of the corresponding fields in the backend aren´t emptied correctly and some (!) values aren´t changed.

This is what I get from a cb user fields database check:

CB fields data storage Database structure differences:
Table #__comprofiler Column avatar type is varchar(255) instead of text
Table #__comprofiler Column cb_profilbild type is varchar(255) instead of text
Table #__comprofiler Column website type is varchar(255) instead of text

The CB fields data storage database structure differences can be fixed (adjusted) by clicking here: Click here to Fix (adjust) all CB fields data storage database differences listed above (you can also Click here to preview fixing (adjusting) queries in a dry-run), but in all cases you need to backup database first as this adjustment is changing the database structure to match the needed structure for the installed version.
Click here to Show details

CB fields data storage database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red.


Any ideas?
Last edit: 10 years 7 months ago by Michael2014.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
10 years 7 months ago #243020 by krileon
Looks like you applied a quickfix to those columns and changed them from varchat to text to get around database column size limits. If intentional just ignore the tools check otherwise click the link to let tools fix it.

This shouldn't have anything to do with delimiter fields not working properly; please be more specific as to what is happening with them. Delimiter field display uses the description column of _comprofiler_fields.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

10 years 7 months ago - 10 years 7 months ago #243025 by Michael2014
Replied by Michael2014 on topic Delimiter fields not emptying/updating correctly
Hello Kyle,

it looks like the conditionals plugin causes the problems. If a value is changed or deleted and the conditional for "show field" is triggered before the changes have been saved, the values won´t be written to the database. Does that make any sense to you? I am currently trying to work around this problem by making it a requirement to fill all fields or empty all fields before the "show"-condition can be changed.

EDIT: This thread here www.joomlapolis.com/forum/153-professional-member-support/224961-inconstancy-with-cb-conditional has the lowdown on why it appeared to me that the fields didn´t empty/update. A Reset does indeed solve the issue, but is too "dangerous" for me to implement, i.e. the users for sure will delete one entry and accidentally loose a lot of already entered data :p
Last edit: 10 years 7 months ago by Michael2014.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
10 years 7 months ago - 10 years 7 months ago #243055 by krileon
There's no changing the behavior. It will either reset the values or it won't. Both have their issues so you need to pick which issues your users can live with. Resetting is the recommended usage and it's designed with resetting in mind, but it's disabled by default as it does cause data loss if a conditional mistake is made. Would value resetting on a field by field basis work better for your situation? As it maybe possible to implement that.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Last edit: 10 years 7 months ago by krileon.

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

10 years 7 months ago #243101 by Michael2014
Replied by Michael2014 on topic Delimiter fields not emptying/updating correctly

krileon wrote: ... Would value resetting on a field by field basis work better for your situation? As it maybe possible to implement that.


Either that or at least a warning about the data loss if fields aren´t empty.

Thanks for the speedy replies!

Michael

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

Moderators: beatnantkrileon
Powered by Kunena Forum