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?

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

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.

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

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?


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

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.

Mark, I've followed your instructions and it appears a Blank Page with Firefox and an HTTP 404 error message with Internet Explorer.

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.

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.

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:



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:



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:



Any idea on what I have to do now?

What PHP version are you attempting the upgrade on?

-Mark

--
Visit My homepage and Zikula themes.

PHP 4.3.9

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.

Ok, thank you Mark. I'll test the patch when you release Zikula 1.0.

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