Sinisakrisan (Talk | contribs) |
Sinisakrisan (Talk | contribs) (→Failed to parse time string) |
||
| Line 9: | Line 9: | ||
It can also happen that you have completely date unrelated value like random string of characters, solution will however, be the same. | It can also happen that you have completely date unrelated value like random string of characters, solution will however, be the same. | ||
<center>{{alert|'''Warning:''' Before you proceed, please backup your entire site and whole database|alert-danger}}</center> | <center>{{alert|'''Warning:''' Before you proceed, please backup your entire site and whole database|alert-danger}}</center> | ||
| + | |||
| + | First, navigate to your database. You will most likely use phpMyAdmin as a common software to manage your database | ||
| + | <center>{{alert|'''Note:''' The images shown bellow might differ in various versions of phpMyAdmin. If that is the case, please refer to the [http://www.phpmyadmin.net/home_page/docs.php phpMyAdmin Manual]|alert}}</center> | ||
==Second issue== | ==Second issue== | ||
Revision as of 02:51, 5 December 2013
Note: The explanations in this article only apply to sites that are being upgraded to JomSocial 3.1 from earlier versions.
If you are starting from a fresh sites, you'll most likely never experience issues explained here
If you are starting from a fresh sites, you'll most likely never experience issues explained here
Failed to parse time string
This is a very common error, specially for the sites which have old database (several years old sites) or those with a lot of dirty data
It looks like the error does not tell us anything special, but if you take a closer look, the error actually said that is failing to parse date string 1987-34-58 23:59:59 which is true, because 1987-34-58 can never be an actual date
In this case, 1987 is the year, 34 is the month and 54 is the day. Obviously, the date here is wrong.
It can also happen that you have completely date unrelated value like random string of characters, solution will however, be the same.
Warning: Before you proceed, please backup your entire site and whole database
First, navigate to your database. You will most likely use phpMyAdmin as a common software to manage your database
Note: The images shown bellow might differ in various versions of phpMyAdmin. If that is the case, please refer to the phpMyAdmin Manual