Dizkus

Hi,

we are moving our Website to a new server and want to upgrade our website as well. But since .726 ist NOT ready for php5 or even mysql5 we also decided to upgrade PostNuke too.

We did have the following problems:
After "successfull" Upgrading (this is waht PostNuke's upgrade process tells us) the site became unusable. First themeheader was unknown, so we used PSAK once more to set it to ExtraLite (as recommended in the manual). since PSAK refused to work we did it by hand. After that we encountered a fatal error saying that it does miss two field in nuke_blocks (pn_collapsable and pn_defaultstate). we altered the table - again - by hand and added those two int(11) fields with value 1 as default.
But this didn work too. we not even able to logon or to access administration masks.

So we seek for help succeeding the following targets:
upgrade .726 to .761
keeping ALL useraccounts (1300+)
keeping ALL news (several k) / downloads (several TB)

what we need to know is:
what does PostNuke NEED from PHP's features?! is there a list of features which MUST exist?!

we were naive enough to think that using the .72 to .761 upgrade function of 761's upgrade process would take care of all tables. ;)

any suggestions?

best regards

Simon

Well, you could set up a new clean install on the same server... just to make sure you PHP and PN.76x is playing nice...

This would also give you the ability to compare your original tables, with the new tables, with the upgraded tables...

But the upgrade should have taken care of all the core table requirements... (obviously third party are, well third party).

--
David Pahl
Zikula Support Team

Did you use the .76 version of PSAK , or the .750 version? 1.02 and 1.01 respectively I believe. After the theme reset, and the table definition, you say you were not able to log in - did the site come up at least? What error was given? Blank Page on logging in, blank on going to admin.php?

Did you have all the default core modules activated BEFORE upgrading?

I've completed similar upgrades. The cleanest way was with a clean install of .761, then populating the new database with the old using matching columns or SQL INSERT ... SELECT statements to copy rows over with adjustments as needed.

Caution needs to be taken to make sure all required tables are copied over - ie, groups as well as users, etc. - and that columns match (use full, extended inserts if exporting and reimporting from another, or names columns in insert statements).

This takes some time, but for a large site like your own, can mean LOTS less hassle down the road with good data and good, clean DB tables.

UHEweb

ps - many would, for a token fee, probably take your old DB and do the SQL transfers to the new .761 DB for you - ask around, or let them know you're willing to throw a few incentives if thats an option for you. Check their PN expertise first

If you used upgrade.php as per the manual in .760 your theme should already have been set to Extralite and the upgrade should have proceeded without a problem.

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

Hi,

first, hammerhead, i did AS the manual did say and it didnt worked. ;)

so i did install 762 from scratch (php5 mysql5) and everything went fine so far.
moved the PostNuke theme to the new site's theme directory - worked
copied directly via mysql the users, downloads, categories, photos/images, articles to the new site. worked.

BUT

now i have an issue i could not find anything in this forum since all talking about xanthia (what i dont want to use) and AutoTheme (what i dont want to use too).
i have a working "standard" PostNuke theme. the problem ist:
usually i did check in the footer what module/type is running so i could decide if i want to show the right blocks or not. the problem ist that under 762 it does not work anymore.
if i use Pagesetter as the primary module instead of news the right blocks are not shown anymore. if i read out what module is running its empty. under 726 it did work perfectly.

so: HOW do i enable right blocks when open the URL /index.php without parms?!
you may check yourself stage.thecenter.at (www.thecenter.at the "old" system, pretty much modified)

usually i did check if the $GLOBALS["index"] == 1 for showing right blocks but under 762...

well, any ideas?!

best regards

Simon

ps: here the codesnippet which decides if i show the right block or not. as said: works under 726 but not under 762.

AS far as I know, this should still work, but you may need to add



in the relevant portion of index.php

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

some aftermath:
avr. 4 weeks after upgrading from 726 to 762 i could not find anything that made trouble so far.

726 did run on php4 mysql4 and lighttpd 1.4.9 (PHP fastcgi)
762 runs smoothly on php5 mysql5 and lighttpd 1.4.11 (PHP fastcgi)

only bug we did find is a fastcgi bug in php5.1.2 which did cause some encoding issues of htmlspecialchars.

php5 is far much faster than php4 and PN participates of it. ;)

what we did:
installed on the target system PN762 from scratch
copied theme of source system to target system
installed thridparty modules as Pagesetter photoshare and such at target system
replicated source database of mysql4 to mysql5 on the target system
copied old database tables content (Pagesetter, user, photoshare, ...) to the target databasetables
some adustments here and there and everything worked

the only issue we still have is our multisite setup which we did put on ice until we find a stable rollout. (we did found several postings/tuts around here for multisite with different rollout.)

best regards

Simon

--
theCENTER netWork Founder/Administrator/Owner

Glad you got everything sorted - thanks for posting back with your result.

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide