-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
-
Subscription and download (Fabrik 4.1 for J!4.2+ and J!5.1) are working now
See Announcement
We have resolved the issue with the J! updater and this will be fixed in the next release.
Stange Date problem
- Thread starter cytino
- Start date
- Status
cheesegrits
Support Gopher
Ack phfffft. I'm really starting to hate the date code, LOL!
The problem is, we currently use the standard PHP routine strtotime() to process the submitted date, which takes a formatted time string and spits out a UNIX style timestamp, which we can then format back into the MySQL date format for storing in db.
So far so good ... but strtotime() only "understands" a certain subset of the almost infinite ways of formatting a date. And in particular, it can get confused between an m-d-Y and a d-m-Y format, when m and d are both 12 or less.
Much to my surprise, there doesn't seem to be any date handling routine which takes a formatted date string AND a format string, and spits out a timestamp.
So ... really the only solution is that we will have to write one.
For now, can you try something for me, and use m-d-Y instead of d-m-Y, see if that works?
-- hugh
The problem is, we currently use the standard PHP routine strtotime() to process the submitted date, which takes a formatted time string and spits out a UNIX style timestamp, which we can then format back into the MySQL date format for storing in db.
So far so good ... but strtotime() only "understands" a certain subset of the almost infinite ways of formatting a date. And in particular, it can get confused between an m-d-Y and a d-m-Y format, when m and d are both 12 or less.
Much to my surprise, there doesn't seem to be any date handling routine which takes a formatted date string AND a format string, and spits out a timestamp.
So ... really the only solution is that we will have to write one.
For now, can you try something for me, and use m-d-Y instead of d-m-Y, see if that works?
-- hugh
cheesegrits
Support Gopher
What is the "main problem"?
We think we have resolved the problem, by creating a new function that "reverse engineers" the format you used when submitting the data to the db.
Upgrade to the latest SVN and try again. You should be able to use your original d.m.Y format.
-- hugh
We think we have resolved the problem, by creating a new function that "reverse engineers" the format you used when submitting the data to the db.
Upgrade to the latest SVN and try again. You should be able to use your original d.m.Y format.
-- hugh
The date displays Ok when the date picker element is used, however.
In the database the date and time format are stored as:
1969-12-31 18:00:00
When a form view is used the date is also displayed as:
1969-12-31 18:00:00
The problem is that my users being European cannot get there heads around the US display format.
Please help.
CYTino
In the database the date and time format are stored as:
1969-12-31 18:00:00
When a form view is used the date is also displayed as:
1969-12-31 18:00:00
The problem is that my users being European cannot get there heads around the US display format.
Please help.
CYTino
cheesegrits
Support Gopher
I think we may finally have gotten dates working properly in the latest SVN. I found a bug which was causing dates to be reset to "start of epoch" (the 1969 date) in certain circumstances.
Try updating to the latest SVN, and see if that fixes things. On my test server, I'm now able to use any date format and it works fine.
-- hugh
Try updating to the latest SVN, and see if that fixes things. On my test server, I'm now able to use any date format and it works fine.
-- hugh
Hi
I have upgraded to svn 972
the problem is still the same i.e.
If i choose 2008.07.01
It appears in the database and table view as: as as 2008-12-01 00:00:00
I know that this has caused you a major headache but I must keep asking for help as I cannot progress without this.
CYTino
I have upgraded to svn 972
the problem is still the same i.e.
If i choose 2008.07.01
It appears in the database and table view as: as as 2008-12-01 00:00:00
I know that this has caused you a major headache but I must keep asking for help as I cannot progress without this.
CYTino
cheesegrits
Support Gopher
Unfortunately my development server just blew a power supply (literally 10 minutes ago), and it's an esoteric external supply for a Dell Optiplex SX260, so I can't run down to Gigaparts and get one.
I'm ordering it for 2 day delivery off the net now, but until it gets here I'm totally without my Fabrik test / dev server. Can't even test your date problem.
-- hugh
I'm ordering it for 2 day delivery off the net now, but until it gets here I'm totally without my Fabrik test / dev server. Can't even test your date problem.
-- hugh
cheesegrits
Support Gopher
OK, I'm back on the air, my dev server is up again. We made a few more changes to the date stuff, so if you could upgrade to the latest SVN and let me know if the problem still exists b4 I try and duplicate it ...
-- hugh
-- hugh
cheesegrits
Support Gopher
Any news on this one, can I close it out?
-- hugh
-- hugh
cheesegrits
Support Gopher
No response, closing.
-- hugh
-- hugh
- Status