Problem with list of contentpart last edited (1.3.3)

[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?

[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.

[Jensensen]

actual (latest) Apache, PHP, MySQL... running there???

[zuker]

Here is a link to my site php info http://www.paveikslas.lt/wcms/php_info.php

[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.

[zuker]

But with article date everything is ok. Look below:

[Jensensen]

[x]

[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..?

[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?

[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