Zikula Community

• jmvaughn
  
  

  • Rank: Registered User
  • Registered: Sep 01, 2011
  • Last visit:
  • Posts: 20

  Posted: Sep 01, 2011 - 03:24 AM

  I am attempting to upgrade a PostNuke 0.764 site to Zikula. I have followed the instructions carefully, gone back and double checked things, and re-tried a number of times but I keep getting stuck at the same point.
  
  When running the upgrade.php script, everything works perfectly until I get to the last section, "Upgrade All Modules". At this point, I get the following error:
  
  Unknown column 'pn_aid' in 'field list'
  UPDATE nuke_stories SET pn_cr_uid = pn_aid
  News not upgraded
  
  All the other modules and tables seem to work OK. I can go into the new site and only the News module does not work.
  
  Also, I do get the Internal Server Error 500, even though I deleted the .htaccess file as directed in the upgrade instructions.
  
  Has anyone else had this issue? Can anyone offer a solution?
  
  Any help would be greatly appreciated.

  • 
  •  
• jmvaughn
  
  

  • Rank: Registered User
  • Registered: Sep 01, 2011
  • Last visit:
  • Posts: 20

  Posted: Sep 01, 2011 - 10:59 AM

  Some more information.
  
  First, I get the Internal Server Error shortly after pressing the "Upgrade All Modules" button. But then I can go back and press the button again and everything shows a green checkmark except for News.
  
  Second, I found this post where a user had a similar problem to mine:
  http://community.zikula.org/module-Forum-viewtopic-topic-57381.htm
  
  The user in that post (helgej) mentions that pn_aid and pn_time fields are missing in the table pn_stories. The pn_stories (actually nuke_stories in my case) table had those fields before the upgrade.php, but disappeared afterwards. I was able to create the two fields in nuke_stories after the upgrade. This allowed me to get into modules and successfully initialize and activate the News module (something I could not do before). However, as soon as I try to go to the home page (and the site tries to load the News articles), I get an Internal Server Error message.
  
  After reading the post I reference above, I have some additional questions. User helgej mentioned that he "upgraded News to the 2.2 and went on to 2.4.1" but the migration distribution I used upgraded all the way to 2.4.1, so I'm not sure how I could repeat what he did to solve my problem.
  
  If more information is needed, please let me know and I will try and get it posted as well.

  • 
  •  
• espaan
  
  

  • Rank: Developer
  • Registered: Aug 23, 2003
  • Last visit: May 31, 2010
  • Posts: 1428

  Posted: Sep 01, 2011 - 03:14 PM

  Hi, what version of News are you coming from (is that 1.3)? The upgrade is intented to work, but postnuke News was of course quite a bit different in DB tables than the current News module.
  
  First of all make sure of course that you have backups of the original DB tables for News and the related tables (autnews, queue if needed). The upgrade should work fine up until 241.
  After that version you go into gettext versions of the module. THen you should update Zikula as well to 12x.
  
  I can remember that there were some issues with upgrading from PN news and the order of DB table fields renaming.
  I have looked inthe upgrade code of 241 and there is first a DBUtil call to update the tables and later on some specific field renaming actions. It might be that the general DBUtil call already removes the old DB columns so that the speicif c update routing cant find them later on.
  
  So it might be that some specific actions are needed to get this working.
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
• jmvaughn
  
  

  • Rank: Registered User
  • Registered: Sep 01, 2011
  • Last visit:
  • Posts: 20

  Posted: Sep 01, 2011 - 09:12 PM

  Espaan,
  
  Thanks for your reply. The version of news in the old site reads 1.3 in the Modules section.
  
  I have indeed backup everything.

  • 
  •  
• jmvaughn
  
  

  • Rank: Registered User
  • Registered: Sep 01, 2011
  • Last visit:
  • Posts: 20

  Posted: Sep 02, 2011 - 11:38 PM

  Anyone have any specific suggestions I can try next?
  
  I have been trying to do this for a week now. I had no idea moving a fairly simple installation of PostNuke to Zikula was going to be this difficult.

  • 
  •  
• espaan
  
  

  • Rank: Developer
  • Registered: Aug 23, 2003
  • Last visit: May 31, 2010
  • Posts: 1428

  Posted: Sep 03, 2011 - 07:23 AM

  Hi,
  
  can I ask you to send me the News tables via mail ? Than I can have a look at what is going on with News 241 and your tables.
  
  erik
  dot
  spaan
  at
  gmail
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
• jmvaughn
  
  

  • Rank: Registered User
  • Registered: Sep 01, 2011
  • Last visit:
  • Posts: 20

  Posted: Sep 08, 2011 - 03:37 AM

  Thanks to espaan's time and patience, I now have the News articles imported correctly.
  
  Here is a description of how the issue was solved.
  
  I erased everything, restored my backups, and started again. This time I used phpMyAdmin to rename the nuke_stories table to nuke_stories_bkup before I ran the upgrade.php migration script. I ran the script and everything was successful except the conversion of the News module. I deleted the nuke_stories table created by the upgrade script, then renamed the nuke_stories_bkup table back to nuke_stories.
  
  I was then able to go into Modules and click to install and initialize the new version of News. Next, I clicked News and then News Publisher Settings and changed the "Number of articles on News lead page" to 10 (it was blank previously). At this point all the articles appeared on the home page and all the articles appear to have imported correctly.

  • 
  •  
•  
•  

Users on-line

• 0 users

This list is based on users active over the last 60 minutes.