You are a Postnuke user?
You have a non English installation?
Fine! You can help us fix the last bigger bug in .8!
http://noc.postnuke.com/tracker/index.php?func=detail&aid=5262&group_id=5&atid=101
Please try to update a test installation of your .764 site and see if the reg_date is set correctly.
Report you observations here or better directly in the tracker.
If we can fix this in the next few days, we should be able to have the RC3 soon after.
--
best regards from Kiel, sailing city
Steffen Voss
Member of the Zikula Steering Committee
Read The Zikulan's Blog "If you want people to RTFM, make a better FM!"
Watch
GitHub Core
Show your support for Zikula! Sign up at Github account and watch the Core project!
GitHub Modules
Forum Activity
- michiel responded to »password problem« 10:01 AM
- mazdev responded to »Hide "Register new account" and change template to 3 col« 07:50 AM
- mesteele101 created topic »Zikula 1.3.3 - Site Search 1.5.2 - Unable to turn off plug-ins« 07:48 AM
- mesteele101 responded to »ERR (3): E_USER_ERROR: Smarty error: [in pagesvar:pagesitem2en line XXX]…« 25. May
- mazdev responded to »Pages 2.5.0 and updating - Page not found« 25. May
- mesteele101 responded to »Zikula 1.3.3 - Selecting a category in Pages not working« 25. May
- mdee created topic »How to implement returnpage ?« 25. May
Zikula Blog
- Anatomy of Open Source Projects on Mar 07
- Continuous Review on Mar 01
- Not Invented Here on Feb 24
- How to Contribute Your Code at Github on Jan 13
- 10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
- Submitting Bug Report Tickets That Get Results on Aug 17
- Cozi Tricks #1: Syntax Highlighting on Aug 07
Login
CoreDevs need help!
-
- Rank: Software Foundation
- Registered: Sep 03, 2002
- Last visit: May 09, 2010
- Posts: 909
Posted: Jan 22, 2008 - 09:45 AM
-
- Rank: Developer
- Registered: Feb 23, 2005
- Last visit: May 09, 2010
- Posts: 399
Posted: Jan 22, 2008 - 10:07 AM
I'm not sure if you mean that bug is only in none English installs or not. I updated a English only site with a couple of hundred users and all the reg dates are 1970-01-01 10:30:00. I'll update my install from SVN and try it again.
Ok, just tried it with latest SVN and it's still the same reg date is 1970 xx xx xx xx
edited by: denisrf, Jan 23, 2008 - 07:58 AM -
- Rank: Software Foundation
- Registered: Sep 03, 2002
- Last visit: May 09, 2010
- Posts: 909
Posted: Jan 22, 2008 - 10:33 AM
mmmh. Can you give us a list of the versions you use? Apache? PHP? MySQL?
--
best regards from Kiel, sailing city
Steffen Voss
Member of the Zikula Steering Committee
Read The Zikulan's Blog "If you want people to RTFM, make a better FM!" -
- Rank: Developer
- Registered: Feb 23, 2005
- Last visit: May 09, 2010
- Posts: 399
Posted: Jan 22, 2008 - 10:44 AM
Just coming back for that:
+ Apache 2.2.6
+ MySQL 5.0.45
+ PHP 5.2.4 -
- Rank: Team Member
- Registered: Mar 18, 2002
- Last visit: Oct 21, 2009
- Posts: 6606
Posted: Jan 22, 2008 - 11:47 AM
If anyone can provide a fix for this please do so. I've upgraded about ten different sites using databases from myself and others - In every single case the registration dates we're migrated as expected.
-Mark
--
Visit My homepage and Zikula themes. -
- Rank: Software Foundation
- Registered: Sep 03, 2002
- Last visit: May 09, 2010
- Posts: 909
Posted: Jan 22, 2008 - 11:14 PM
In the tracker Carsten said, that a manual execution of the SQL worked out right. Maybe it could help to automatically check after the update if the dates are 1970 and if so execute the SQL again?
--
best regards from Kiel, sailing city
Steffen Voss
Member of the Zikula Steering Committee
Read The Zikulan's Blog "If you want people to RTFM, make a better FM!" -
- Rank: Developer
- Registered: Feb 23, 2005
- Last visit: May 09, 2010
- Posts: 399
Posted: Jan 22, 2008 - 11:16 PM
I can't help with a patch, wish I could. The only other thing I can think of is; This site is fairly old, started life with .726 and over the years has been upgraded through all the different versions to 764. If that is having any effect I don't know. I've got a straight 764 thats not an upgrade, maybe I could get a backup of that and try it, see if that is any better. Can't do it today maybe tomorrow
Denis -
- Rank: Software Foundation
- Registered: Sep 03, 2002
- Last visit: May 09, 2010
- Posts: 909
Posted: Jan 22, 2008 - 11:44 PM
mmmh. One of our test sites has also a pretty long history. Could that be a problem? But on the other hand, Mark was able to update the dump of a site that failed for Carsten without any problems.
--
best regards from Kiel, sailing city
Steffen Voss
Member of the Zikula Steering Committee
Read The Zikulan's Blog "If you want people to RTFM, make a better FM!" -
- Rank: Team Member
- Registered: Jul 15, 2004
- Last visit: May 27, 2010
- Posts: 277
Posted: Jan 23, 2008 - 01:01 AM
kaffeeringe.de
But on the other hand, Mark was able to update the dump of a site that failed for Carsten without any problems.
That surprised me very much.
I've done all upgrades with the german language-pack installed.
But I although tried an upgrade after switching the pn7-site to english without success.
But could it be that we have wrong files installed?
(We can exclude any multilanguage database-settings, because Mark was able to update my SQL-dump)
BUT
My suggestion couldn't be correct, because denisrf has the same problem without any language-pack.
edited by: Herr.Vorragend, Jan 23, 2008 - 02:05 PM -
- Rank: Developer
- Registered: Feb 23, 2005
- Last visit: May 09, 2010
- Posts: 399
Posted: Jan 23, 2008 - 01:06 AM
Herr.Vorragend
But could it be that we have wrong files installed?
(We can exclude any multilanguage database-settings, because Mark was able to update my SQL-dump)
Not sure what you mean. Which wrong files?
I just did the same upgrade on a different server with the same result:
+ Apache 1.3.37
+ MySQL 4.1.22
+ PHP 4.4.4
edited by: denisrf, Jan 23, 2008 - 10:46 PM -
- Rank: Developer
- Registered: Mar 29, 2005
- Last visit: Mar 13, 2010
- Posts: 228
Posted: Jan 23, 2008 - 01:08 AM
I don't think the problem is related to the language pack because I'm having it on a fresh install using only the default english pack.
I think is related to the environment, as I said in the NOC. (and also I've found an hack that worked for me)
--
Zikula Italia
SimpleGallery -
- Rank: Team Member
- Registered: Jul 15, 2004
- Last visit: May 27, 2010
- Posts: 277
Posted: Jan 23, 2008 - 01:32 AM
I take back everything
By the way - my server settings:
PHP 4.4.8
mySQL 4.0.23
Apache/1.3.37
PHP 5.2.5
mySQL 4.1.21
Apache API Version: 20051115
edited by: Herr.Vorragend, Jan 23, 2008 - 02:52 PM -
- Rank: Developer
- Registered: Aug 23, 2003
- Last visit: May 31, 2010
- Posts: 1428
Posted: Jan 23, 2008 - 03:47 AM
I have the same problem. My regdate is converted to 1970 after an upgrade.
I have converted my testsite in 0.764 (recently installed and very clean, only 2 users) to 0.8. Both users have a regdate of 1970 after conversion.
Converting by hand (as suggested in the NOC):
Code
UPDATE pn_users,pnold_users SET pn_users.pn_user_regdate
= FROM_UNIXTIME(pnold_users.pn_user_regdate) where
pn_users.pn_uid=pnold_users.pn_uid;
works perfectly.
PHP 5.0.4
MySQL 4.1.20
Apache/2.0.54 (Fedora) API version 20020903
--
campertoday.nl, Module development, Dutch Zikula Community -
- Rank: Team Member
- Registered: Jan 02, 2003
- Last visit: Oct 21, 2009
- Posts: 800
Posted: Feb 03, 2008 - 03:43 AM
The fixed upgrade code is now in the SVN (revision 23637).
I also combined upgrade.76.php and upgrade.php into one file (upgrade.php), added some look and feel changes and prepared the code for better use in non-english sites.
Please test. No need for manual upgrades any longer
--
"He is not dangerous, he just wants to play...." -
- Rank: Developer
- Registered: Feb 23, 2005
- Last visit: May 09, 2010
- Posts: 399
Posted: Feb 03, 2008 - 04:42 AM
Excellent! Fixes the problem with reg dates and a much, much nicer and informative upgrade page.
One problem. On using upgrade.php for the first time it gives and error about "pnTemp/upgrade_languages" not found. I think because it looks for the file before it has been created. Reload the page and it all runs fine, the file has now been created for upgrade.php to find.
Denis
- Moderated by:
- Support
