Skip to Content Skip to Menu

data field is automatically filled with 0000-00-00

9 years 9 months ago #257428 by paolo.sard
data field is automatically filled with 0000-00-00 was created by paolo.sard
When i update any user profile in backend, automatically any data field is filled with 0000-00-00 values instead of the desired NULL value.. This only happens if i update profiles in backend. When profile update is made by single user in frontend, everything works fine.. any help?

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
9 years 9 months ago #257455 by nant
Replied by nant on topic data field is automatically filled with 0000-00-00

paolo.sard wrote: When i update any user profile in backend, automatically any data field is filled with 0000-00-00 values instead of the desired NULL value.. This only happens if i update profiles in backend. When profile update is made by single user in frontend, everything works fine.. any help?


Joomla version?
CB Version?
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48479
  • Thanks: 8283
  • Karma: 1443
9 years 9 months ago #257474 by krileon
Replied by krileon on topic data field is automatically filled with 0000-00-00
Why do you need it stored as NULL? It's storing as designed, which is SQL date format for an SQL date column type. Empty date will store as 0000-00-00 and empty datetime will store as 0000-00-00 00:00:00.

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.

Moderators: beat, nant, krileon
Powered by Kunena Forum