[#19607] - [4.0] Editing an article failed in debug mode with error **Save failed with the following error: Incorrect datetime value: '' for column 'created' at row 1**
- Closed
- 19 Aug 2018
- Medium
- Build: staging
- # 19607
Steps to reproduce the issue
- Create an article with a title and a text
- Save and close this article
- Open this article again and save it.
Expected result
The article is saved
Actual result
You see the error Save failed with the following error: Incorrect datetime value: '' for column 'created' at row 1
It is not possible to fill the date fields
joomla-cms-bot
- | Labels |
Added:
?
|
||
Yes, you are right. The error occurs only with debug mode.
| Title |
|
||||||
I see the problem: the field value somehow becomes translatable:
franz-wohlkoenig
- | Status | New | ⇒ | Discussion |
| Category | ⇒ | com_content |
| Labels |
Added:
J4 Issue
|
||
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-06-08 20:40:46 |
| Closed_By | ⇒ | brianteeman |
i cant replicate this. I am going to assume this has been fixed elsewhere and close it. it can always be reopened if required
@brianteeman the issue still. You need active the language debug for replicate. And the problem is what said dgrammtiko.
My error - it is ok on creating an article just not for editing
| Status | Closed | ⇒ | New |
| Closed_Date | 2018-06-08 20:40:46 | ⇒ | |
| Closed_By | brianteeman | ⇒ |
Interesting there is the same problem in Joomla 3 but instead of getting a save failed error the field is blanked and the article is saved.
The assumption of @dgrammatiko cannot be correct as all the date fields are displayed that way with debug on and its just this one field that has a problem
@brianteeman but that is the problem: the value with the ** is nowhere near valid so it throws
well its probably something to do with this line then
translateformat="true"
In the form field or the HTML helper or whatever it is handling that you’re
going to need to force JLanguage out of debug mode, translate the format,
and reset the state. Check for other uses of setDebug for examples, I’m
sure there’s one out there.
On Fri, Jun 8, 2018 at 5:02 PM Brian Teeman notifications@github.com
wrote:
well its probably something to do with this line then
translateformat="true"—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#19607 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAWfoTN19Wp3HcBdV0AoqUiZz-avHxVjks5t6vRcgaJpZM4R9dUl
.
--
- Michael Please pardon any errors, this message was sent from my iPhone.
If anyone works on this then you need to also check all date fields - i quickly checked publishing dates in modules and its the same behaviour
| Status | New | ⇒ | Discussion |
I did find some uses of setDebug to try and learn from them and create a pr but I failed
wilsonge
- | Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-08-19 11:40:54 |
| Closed_By | ⇒ | wilsonge |
@astridx is this behaviour with language debug on? Does it work when not in debug mode?