search

Theophilix / event-table-edit-old

Event Table Edit is a free table plugin for Joomla 3.x to create a responsive, editable table with CSV / XML import and export, and a simple appointment booking system function. Any help in the development is highly appreciated.
GNU General Public License v3.0
10 stars 6 forks source link

The date is not displayed correctly #139

Closed f24nz closed 5 years ago

f24nz commented 5 years ago

When editing a date, the frontend table always shows 1970-01-01, in the database it is stored correctly though.

Theophilix commented 5 years ago

Which PHP / ETE version do you use? I can not reproduce this error on demo.eventtableedit.com...

f24nz commented 5 years ago

PHP 7.2.14 ETE 4.7.4

Theophilix commented 5 years ago

Which date format do your dates have?

f24nz commented 5 years ago

Normally I use the format %a, %d.%m.%Y, but I have tried it with different formats too. The format itself is always represented correctly though

Theophilix commented 5 years ago

I tried to reproduce your problems on my test website (http://test.eventtableedit.com/index.php/new-table) but I could not find an error, I downloaded 4.7.4 version and use PHP 7.1.23. You could try to go back to 4.7.3 version (https://github.com/Theophilix/event-table-edit/releases/tag/4.7.3), or uninstall and reinstall 4.7.4. Don't forget to clean up your mysql table. What is your browser and which version do you use?

twinbits3D commented 5 years ago

I have the same problem with the date! Running on PHP 7.2 on joomla 3.9.4 . Can't understand what's going on. On an old table it's possible to use the date field correctly. If I setup an new table with the date field, it displays on all rows 1970-01-01 .

Theophilix commented 5 years ago

I can reproduce this error. For a quick fix: a) use 4.6.6 version b) use text as datatype c) Import your data via csv Check, if there is an empty space in your date. It seems like a change in Joomla PHP causes this. I need a few days to find the error. I have not much free time left these days.

Theophilix commented 5 years ago

I fixed the error now. It was a date conversion problem in helpers/etetable.php. Check my latest commit.

twinbits3D commented 5 years ago

Thank you for your work. Wish you a nice weekend!

Am 21.03.2019 um 19:23 schrieb Theophilix notifications@github.com:

I fixed the error now. It was a date conversion problem in helpers/etetable.php. Check my latest commit.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Theophilix/event-table-edit/issues/139#issuecomment-475348498, or mute the thread https://github.com/notifications/unsubscribe-auth/AuPuPTdOuaiEVxLM6wTEq5sB5cIt3xHgks5vY84OgaJpZM4bmqxa.