Page 1 of 1

Problem with list of contentpart last edited (1.3.3)

Posted: Wed 26. Sep 2007, 11:27
by zuker
Hi,

I have problem with list of contentpart (last edited) in admin home page. It doesn’t change when I ad new contentpart, it doesn’t change when I edit existing contentpart either. I use 1.3.3 version.

Any suggestions?

Image

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Fri 1. Feb 2008, 15:47
by zuker
I have installed phpwcms 1.3.5. but the problem still persists. I can privately post backend login of my test site you could take a look there.

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Fri 1. Feb 2008, 16:02
by Jensensen
actual (latest) Apache, PHP, MySQL... running there???

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Fri 1. Feb 2008, 16:48
by zuker
Here is a link to my site php info http://www.paveikslas.lt/wcms/php_info.php

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Fri 1. Feb 2008, 17:30
by DeXXus
Perhaps this is a mySQL issue?
When you enter dates that are out of the range or in the wrong format for a given date type, MySQL will often just enter in the default value of all zeros.

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Fri 1. Feb 2008, 17:40
by zuker
But with article date everything is ok. Look below:

Image

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Fri 1. Feb 2008, 18:32
by Jensensen
[x]

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Fri 1. Feb 2008, 19:18
by zuker
Jensensen,

thanks for the matter investigation that you made. Quite sad conclusions. :( I guess I’ll have to disable last edited CP list until this problem will be solved.

May be others have different suggestions? :? DeXXus..? Oliver..?

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Sat 2. Feb 2008, 00:20
by DeXXus
This was similar:
http://forum.phpwcms.org/viewtopic.php?t=14446

Do your templates for CP & Article have the same DATE tags formatted the same way?

Re: Problem with list of contentpart last edited (1.3.3)

Posted: Sat 2. Feb 2008, 12:17
by zuker
Yes!!! Problem solved!
Thanks DeXXus for a link. The problem was the same as described in related post – wrong database settings in Table: phpwcms_articlecontent Fields: acontent_created and acontent_tstamp. Described solution in linked post did not work, but after few attempts I made it work for me.

As I understand everything depends on MySQL version.
My MySQL is version 4.0.27 (quite old)
phpMyAdmin is version 2.10.2

regards

Zuker