Ckforms1.5 migration:Failed to parse time string

Hi all

I followed the article on how to migrate CKforms data from my Joomla1.5 site to a new 2.5 development site created using jupgrade. www.example.com is my 1.5 site, www.example.com/jupgrade is my 2.5 development site. Both are using the same database, but obviously the 2.5 site uses a different database prefix (j25_) to the 1.5 site (gti_). The migration of the site has been perfect up until this point. The site's are running on PHP Version 5.3.29 by the way.

The only issue I have had is when i updated my main menu items on the 2.5 site that link to the pages with the forms on. I assumed that i would just have to change my menu item type from 'CK Forms » Ckforms' to type 'Visforms » Form' then select the form I wanted to use on the page. After doing this, I used the front-end menu to navigate to the page I just added to the menu item, but i was returned this error:

500 - DateTime::__construct() [datetime.--construct]: Failed to parse time string (1410383557th) at position 10 (t): The timezone could not be found in the database :ohmy:

After doing some research it seems this is an error created by the difference in the way 1.5 and 2.5 handle timezone information, but i have no idea where to start fixing it. I've read i might need to change:
- the timezone information for each of my imported users.the
- the timezone information in my php.ini or htaccess.ini file

Joomla 1.5 site system PHP date info:
date/time support: enabled
"Olson" Timezone Database Version: 2013.3
Timezone Database: internal
Default timezone: Europe/London

Joomla 2.5 site system PHP date info:
date/time support: enabled
"Olson" Timezone Database Version: 2013.3
Timezone Database: internal
Default timezone: UTC

I can obviously see that the default timezone is different for each but I don't know if this is what might be causing the issue, and if so how to correct it.

Please let me know if there is further info you need. it would be great if you could help me with a place to start looking to solve these errors! Thankyou guys!

I just thought i'd let you know that this doesn't happen for all forms attached to menu items, I have 2 forms setup, one works fine, and one gives the error, which is a bit confusing.

Hi,

I've never heard of such a problem before, but updating a Joomla! 1.5 installation is always a very individual thing.

Could you, as a first step, export the joomla 2.5 tables (all of them) with phpMyAdmin or some other mySql tool into a file and send me the .sql file to contact@vi-solutions.de?, so that I can take a look at the tables?

Regards,
Aicha

Hi

I fixed this in the end. I noticed it was a timestring error, so i looked in my forms for a field that included a 'type [date]' field. I figured if there is timezone differences between 1.5 and 2.5 it had to be a field that included a date that was causing the error. Sure enough I changed this to text, saved, then changed back to date, saved again. This time when i refreshed my page the imported form showed! No more error

Hi,

I'm glad to hear you found the solution and sorry, I couldn't help you, so that you had to figure this out on your own.

Thank you very much for the post and the solution which may help other!

Kind regards,
Aicha