Error while trying to add a new entry

[7webcreator]

Hello,

My list was working perfectly until I suddenly added a new entry and got the following error message: 0 DateTime::__construct(): Failed to parse time string (13/04/2018) at position 0 (1): Unexpected character
So now, I can still modify any entry of the list, however, as soon as I click on add, I get this error message.
Can someone help me understand what happens?
Thank you
My settings
Joomla 3.7 and Fabrik 3.6

 

[cheesegrits]

Which site / form?

-- hugh

 

[7webcreator]

Thank you for your reply.
Site: rocksolid
List id 8 order process
I have this error only on frontend

 

[cheesegrits]

OK, so how do I get to list 8 on the front end? You have a lot of menu links ... I don't feel like trying them all till I get lucky ...

-- hugh

 

[7webcreator]

Oh sorry! Please, click on confirmed orders.

 

[troester]

I don't get the error message after clicking "Add".
Maybe a caching issue?
Try to clear browser cache.

 

[7webcreator]

I did try many times to clear the browser cache with Ctrl F5, with no success. The fact is when I try with the menu that you can find under View all/Export, it is working. This menu is using the same table. Export list is a copy of Confirmed order.

 

[7webcreator]

Hello, I'm desperate. I still have the same issue...some Help, please

 

[isiway]

Hello, same error here when trying to add something to the list, is there any solution? Please help, people cant use the system cause of this error.

Error:
DateTime::__construct(): Failed to parse time string (--) at position 0 (-): Unexpected character

Is it a php 7.0 problem?

Thank you!!!

 

[troester]

@7webcreator is running php 5.6.28

@7webcreator :
I can't see an error when opening a new record on your site - and I can't submit because Exhibitors is readonly, empty, with notempty validation.
If it's on new records only I would suspect it's some date default. Disable all your date elements and enable one by one to find which is creating the error.
BTW: I can remember threads about issues with date format with "/", so maybe test with "-" instead.

@isiway:
Only if adding? Frontend/backend?
Which date element settings (default, format...)
Do you have a link?

 

[7webcreator]

Thank you for coming back to me.
I know which date element caused this issue. However, I would like to know if I de-activate it, will I lose the data?

 

[troester]

Unpublishing an element shouldn't do anything with your data.

(But a backup is always a good idea)

 

[7webcreator]

I unpublished all my date elements of the list involved with no success The problem remains. Any other solutions I should try?

 

[troester]

I really can't follow you.

1. In non of my browsers I get any error message after clicking on Add in http://rocksolidpromotions.aposto.info/confirmed-orders
(where the form doesn't make sense because with "Add" you get Exhibitors as an empty readonly element with a not-empty validation)
So what are the steps to replicate the issue?

2. You say "I know which date element caused this issue". Which one? How do you know it's this element? Especially if you say "I unpublished all my date elements of the list involved with no success The problem remains"?

Did you try to change date formats?
Do you have custom code, plugins...?

 

[7webcreator]

Sorry, in the meantime in order to continue working, I have to duplicate the list and change the menu destination.

Please try this link http://rocksolidpromotions.aposto.info/confirmed-orders/view-deadlines.

I got this issue when I added a row, entered the date 14/04/2018 for the date element "open date" and saved. I did not change the date formats and also don't have a custom code on this date element. The only place where I have a custom code is for the date elements orders___DeadlineRmc2 and orders___Deadlinesmp. The code is as follows

$start = '{orders___OpDate}';
if (!empty($start)) {
   $end = new DateTime($start);
   return $end->modify("-10 days")->format("d/m/Y");
}
else {
   return "";
}

The form is Rock Solid orders process.

 

[troester]

Did you try to unpublish these calc elements?
Did you debug what is in $start in new record?

As I've said:

I can remember threads about issues with date format with "/", so maybe test with "-" instead.

Found this
http://stackoverflow.com/questions/16757728/creating-new-date-time-from-string

 

[7webcreator]

So I have followed your instructions (unpublished the 2 calc involved and changed the format with "-" instead of "/") . The error message remains when I click on add.

 

[troester]

I don't see an "Add" button in http://rocksolidpromotions.aposto.info/confirmed-orders/view-deadlines so impossible to test anything.

I still see all date elements with /
I still see the calc elements (with -, but somebody in stackoverflow is saying "slashes and dashes")

 

[7webcreator]

Sorry, I forgot to add an access level to see it. The other date elements are not involved. I just changed the format of the calc elements

 

[troester]

Again: I don't get any error on Add.
But I also can't edit open date or exhibitors...
Did you try to use the code mentioned in the stackoverflow post?

Did you debug what is in $start in new record?

Did you try to use {orders___OpDate_raw}