During the last few hours, I've followed the instructions that you've provided with the upgrade.html document included into the PostNuke RC4 package, I've cloned my site to a testing account and I've tried to upgrade it several times from 0.764 to 0.800 RC4 without success.
This is what I've done:
1. I've activated all the required modules of my 0.764 site
2. I've deleted all the files
3. I've uploaded PostNuke 0.8 RC4
4. I've edited the config.php file with the current database information
5. I've changed the atributes of the pnTemp directory
6. Then, I've opened the browser and I've gone to *mytestsite*.com/upgrade.php
7. I've selected the english version
8. I've clicked over the "click here to start the upgrade process" button
Well, at this point it has always appeared the following message:
"This script will upgrade PostNuke from versions 0.764 to the latest release. Upgrades from prior releases are not supported by this script.
BEFORE proceeding you should backup your database
Backing Up user database...
Table 'pn_users76x' already exists
CREATE TABLE pn_users76x SELECT * FROM pn_users
done
Users database structure upgraded.
Unknown column 'pn_position' in 'field list'
SELECT pn_bid, pn_position, pn_weight FROM pn_blocks"
And that's all. I can't continue upgrading. Where is the problem? Is this a bug or I am doing something wrong?
PS: The database of my site has a size of 135 MB. Is this a problem?
Forum Activity
- mdee responded to »Different page content under one template (tpl file) based on URL« 07:17 AM
- Guite responded to »Remove contents of nuke_sc_anticracker from Database« 01:30 AM
- espaan responded to »Categories disappear when editing ...« 08. Feb
- eledril responded to »How decrease zikula cpu usage« 08. Feb
- jmvaughn responded to »PN 0.764 to Zikula 1.1.2 (migration) Internal Server Error« 08. Feb
- eledril created topic »Where can I download BBCode and BBSmile?« 08. Feb
- Paustian responded to »Need Feedback« 08. Feb
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
I can't upgrade to PostNuke 0.800 RC4
-
- Rank: Freshman
- Registered: Sep 10, 2004
- Last visit: Apr 23, 2010
- Posts: 93
Posted: Jun 04, 2008 - 11:15 AM
-
- Rank: Team Member
- Registered: Sep 06, 2006
- Last visit: May 09, 2010
- Posts: 2411
Posted: Jun 04, 2008 - 01:13 PM
Mmmm, the DB size is probably a problem,
which is the heavy section? News? Forum?
i recommend you to upgrade the Core only
and after that, try to upgrade other "Heavy modules" one by one...
Also, if you'd tried to upgrade your site
and try again later without recover the 0.7 data again
you'll get some SQL errors...
Good luck
--
- Mateo T. -
Mis principios... son mis fines -
- Rank: Freshman
- Registered: Sep 10, 2004
- Last visit: Apr 23, 2010
- Posts: 93
Posted: Jun 04, 2008 - 06:21 PM
Hola Mateo,
The heavy section?
There are more than 2.500 articles and more than 2.300 posts, but why is this a problem?
I've tried to upgrade with the PostNuke 0.800 RC4 Core and the full package, but the message is exactly the same. -
- Rank: Freshman
- Registered: Sep 10, 2004
- Last visit: Apr 23, 2010
- Posts: 93
Posted: Jun 04, 2008 - 06:34 PM
The version of the MySQL database I have installed into the server is 4.1.20. Is this ok or I need to upgrade it?
edited by: Abadia, Jun 05, 2008 - 07:34 AM -
- Rank: Developer
- Registered: Aug 23, 2003
- Last visit: May 31, 2010
- Posts: 1401
Posted: Jun 04, 2008 - 08:54 PM
regarding your database, have you ever cleaned out caching stuff, sessions, etc. You can check which tables are the biggest ones. Or is it just the News articles?
Quote
Unknown column 'pn_position' in 'field list'
SELECT pn_bid, pn_position, pn_weight FROM pn_blocks"
Do you have a column pn_position in your pn_blocks table?
http://community.postnuke.com/Wiki-SystemRequirements.htm says mysql 4.1.6 is required, so your 4.1.20 should not be a problem.
--
campertoday.nl, Module development, Dutch Zikula Community -
- Rank: Team Member
- Registered: Mar 18, 2002
- Last visit: Oct 21, 2009
- Posts: 6606
Posted: Jun 04, 2008 - 11:52 PM
The error messages (e.g. Table 'pn_users76x' already exists) indicate that you've already attempted an upgrade on this database. Revert to the original, unaltered .7x database and try again.
-Mark
--
Visit My homepage and Zikula themes. -
- Rank: Freshman
- Registered: Sep 10, 2004
- Last visit: Apr 23, 2010
- Posts: 93
Posted: Jun 05, 2008 - 01:06 AM
Mark, I've followed your instructions and it appears a Blank Page with Firefox and an HTTP 404 error message with Internet Explorer.
-
- Rank: Team Member
- Registered: Mar 18, 2002
- Last visit: Oct 21, 2009
- Posts: 6606
Posted: Jun 05, 2008 - 01:18 AM
Follow the linked Blank Page tutorial and see if that helps isolate the problem. You *must* revert the database back to the .7x one at each attempt otherwise things will get mixed up.
-Mark
--
Visit My homepage and Zikula themes. -
- Rank: Team Member
- Registered: Mar 18, 2002
- Last visit: Oct 21, 2009
- Posts: 6606
Posted: Jun 05, 2008 - 01:24 AM
Failing this, if your able, please send me a copy of your DB for testing. E-mail a zipped verion to markwest at postnuke dot com.
-Mark
--
Visit My homepage and Zikula themes. -
- Rank: Freshman
- Registered: Sep 10, 2004
- Last visit: Apr 23, 2010
- Posts: 93
Posted: Jun 07, 2008 - 08:59 AM
Hello,
I've followed the Blank Page tutorial, I've turned on displaying errors adding the line 'php_flag display_errors on' in the .htaccess file and I've repeated the whole upgrading process described in the first message of this post (activate the required modules, delete the files, upload Postnuke 0.8 RC4, edit the config.php...).
Then, I've opened the browser and I've gone to *mydomain*.com/upgrade.php.
It has appeared the following message:
Quote
"Fatal error: Call to undefined function: file_put_contents() in /var/www/vhosts/*mydomain*.com/httpdocs/upgrade.php on line 228"
If I simply click over the "click here to start the upgrade process" button (this is what I did 3 days ago when I wrote the first message of this post), this is what the system shows:
Quote
This script will upgrade PostNuke from versions 0.764 to the latest release. Upgrades from prior releases are not supported by this script.
BEFORE proceeding you should backup your database
* Backing Up user database... done
* Users database structure upgraded.
* Module database structure upgraded.
* upgrade Theme: successful
* upgrade Profile: successful
* upgrade Blocks: successful
* upgrade Users: successful
* Existing users have been activated
* Blocks tables upgraded
* Reset theme to ExtraLite
Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/vhosts/*mydomain*.com/httpdocs/includes/classes/adodb/adodb.inc.php on line 923
As you can see, the message is completely different from the one that appeared three days ago (the first message of this post) but I've done exactly the same.
????
Then, I've repeated the whole process but this time I've edited the upgrade.php file, I've deleted the line 228 and then I've clicked over the "click here to start the upgrade process" button. This is the message that has appeared:
Quote
"This script will upgrade PostNuke from versions 0.764 to the latest release. Upgrades from prior releases are not supported by this script.
BEFORE proceeding you should backup your database
* Backing Up user database...
Table 'pn_users76x' already exists
CREATE TABLE pn_users76x SELECT * FROM pn_users
done
* Users database structure upgraded.
Unknown column 'pn_position' in 'field list'
SELECT pn_bid, pn_position, pn_weight FROM pn_blocks
Fatal error: Call to a member function on a non-object in /var/www/vhosts/*mydomain*.com/httpdocs/system/Blocks/pninit.php on line 224"
Any idea on what I have to do now? -
- Rank: Team Member
- Registered: Mar 18, 2002
- Last visit: Oct 21, 2009
- Posts: 6606
Posted: Jun 08, 2008 - 08:10 AM
-
- Rank: Freshman
- Registered: Sep 10, 2004
- Last visit: Apr 23, 2010
- Posts: 93
Posted: Jun 08, 2008 - 09:56 AM
PHP 4.3.9 -
- Rank: Team Member
- Registered: Mar 18, 2002
- Last visit: Oct 21, 2009
- Posts: 6606
Posted: Jun 08, 2008 - 09:33 PM
I've now fixed the file_put_contents error. The last of the three is again likely because you rerun the process without first resetting the database back to the original backup.
The second error is simply a timeout on your system - and I don't think there is much we can do about this. You *may* need a local development system (xammp or similar) to upgrade your database. We attempt to increase the timeout in the upgrade script but as all hosts are variable this may not always work.
Following this fix my own site upgrades cleanly on PHP 4. This fix will appear in the in the full zikula v1.0 release.
-Mark
--
Visit My homepage and Zikula themes. -
- Rank: Freshman
- Registered: Sep 10, 2004
- Last visit: Apr 23, 2010
- Posts: 93
Posted: Jun 08, 2008 - 11:37 PM
Ok, thank you Mark. I'll test the patch when you release Zikula 1.0. -
- Rank: Team Member
- Registered: Sep 06, 2006
- Last visit: May 09, 2010
- Posts: 2411
Posted: Jun 09, 2008 - 04:52 AM
The timeout problem may be avoided if you upgrade the core only
and then your ValueAddons one by one...
Upgrade the CORE,
then upload and upgrade the News module, Forum, etc...
may be that can work
--
- Mateo T. -
Mis principios... son mis fines
- Moderated by:
- Support
Users on-line
This list is based on users active over the last 60 minutes.
