Sinisakrisan (Talk | contribs) (→Failed to parse time string) |
Sinisakrisan (Talk | contribs) (→Failed to parse time string) |
||
| Line 5: | Line 5: | ||
:::[[File:Timestring.png]] | :::[[File:Timestring.png]] | ||
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'''<br /> | 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'''<br /> | ||
| − | 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 <br /> | + | 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 23:59:59 can never be an actual date <br /> |
In this case, 1987 is the year, 34 is the month and 54 is the day. Obviously, the date here is wrong.<br /> | In this case, 1987 is the year, 34 is the month and 54 is the day. Obviously, the date here is wrong.<br /> | ||
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. | ||
| Line 12: | Line 12: | ||
First, navigate to your database. You will most likely use phpMyAdmin as a common software to manage your database | 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> | <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> | ||
| + | Once database have been selected, navigate to '''Search''' tab | ||
| + | :::[[File:Phpmyadminseach.png]] | ||
| + | Insert the word you want to search for. In our case, it would be ''1987-34-58 23:59:59'''<br /> | ||
| + | Select to find '''exact phrase''' - This is particularly important as 1987 is a valid year and it could find more records if we don't set this option<br /> | ||
| + | Select All tables to be searched and click on '''Go''' button | ||
| + | :::[[File:Phpmyadminseach2.png]] | ||
| + | You should see similar result like on the picture bellow | ||
| + | :::[[File:Phpmyadminseach3.png]] | ||
| + | You can now either delete the record, or browse it further. Lets just clivk on '''Delete'''. We will leave up to you if you want to browse it further.<br /> | ||
| + | Now refresh your JomSocial dashboard. If error is gone, good, if other error is thrown (most likely on a large and dirty databases) just repeat the same process. | ||
==Second issue== | ==Second issue== | ||
Revision as of 03:21, 5 December 2013
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 23:59:59 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.
First, navigate to your database. You will most likely use phpMyAdmin as a common software to manage your database
Once database have been selected, navigate to Search tab
Insert the word you want to search for. In our case, it would be 1987-34-58 23:59:59'
Select to find exact phrase - This is particularly important as 1987 is a valid year and it could find more records if we don't set this option
Select All tables to be searched and click on Go button
You should see similar result like on the picture bellow
You can now either delete the record, or browse it further. Lets just clivk on Delete. We will leave up to you if you want to browse it further.
Now refresh your JomSocial dashboard. If error is gone, good, if other error is thrown (most likely on a large and dirty databases) just repeat the same process.