Zikula Community

• jmvaughn
  
  

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

  Posted: Feb 02, 2012 - 09:19 AM

  I am attempting to update my second (and hopefully last) PN 0.764 site to the Zikula 1.1.2 migration build.
  
  I had a problem attempting to do this with a different PN 0.764 site previously (see thread http://community.zik…pic-topic-58617.htm), however this other site is giving me some different problems.
  
  The site I am having problems with is www.sunlitgames.net . When I run the migration script I get an "Internal Server Error" shortly after clicking the "Upgrade All Modules" button. I have followed the migration instructions carefully, upgraded the download section to 2.2 before the upgrade, tried deleting the .htaccess file and of course applied the fix mentioned in the thread above. Nothing seems to work. This is on the same hosting provider and type of account as the earlier site, which I eventually got to work.
  
  I can hit refresh a few times after the "Internal Server Error" message, and I eventually get a screen showing a (way too short) list of modules that were upgraded (EZComments, News not upgraded, Reviews upgraded, Status upgraded, Top_list upgraded, and Web_Links upgraded).
  
  This is a much more busy and complicated site with pnPHPbb2, and a few custom modules/blocks. I can live without the forums, but I would like to at least carry over the news articles. I can then build back in some of the other bits over time.
  
  Any suggestions for getting the migration script to complete? Please let me know if there is any other information needed.
  
  Any help at all would be greatly appreciated.

  • 
  •  
• mesteele101
  
  

  • Rank: Helper
  • Registered: Sep 19, 2003
  • Last visit: May 25, 2010
  • Posts: 612

  Posted: Feb 03, 2012 - 04:22 AM

  It sounds like there is a problem upgrading one of the modules, and it sounds like your using a development area for testing. Backup the site, and with phpMyAdmin backup all the tables, uninstall all the modules and see if it completes the migration process with the modules removed. Trial and error, until you find out which module is causing the problem.
  
  PNphpBB2 works fine on 1.2.8, however there is a migration process to follow in order for it to work on 1.2.8. I believe there is a note on the PNphpBB2 site documenting the procedure.
  
  A note though, if at all you can get away from PNphpBB2 then I'd suggest doing so now, especially if you plan on migrating past 1.2.x. IMO its a dead project,

  • 
  •  
• jmvaughn
  
  

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

  Posted: Feb 03, 2012 - 04:31 AM

  I will give that a try, thanks for the suggestion.

  • 
  •  
• espaan
  
  

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

  Posted: Feb 03, 2012 - 07:18 AM

  Yes do remove all the modules files from your install (with Backup of course ). You can then try the core and system modules upgrade and later on in 112 try all the modules updates individually. Some modules are ready for this (News e.g. should be), but others might give problems like mesteele already described.
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
• jmvaughn
  
  

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

  Posted: Feb 07, 2012 - 09:16 AM

  Thanks to the suggestions above I was able to make some progress. I actually had to drop the tables in the database associated with the modules, but I did get nearly everything to import.
  
  I am still having trouble with the news articles, however. If I leave the "nuke_stories" table in the database, the upgrade fails. If I rename it to something else, then run the upgrade script, the script completes.
  
  If I then rename the table back to nuke_stories and try to initialize the news module, I get an error:
  Error! Update attempt failed.
  
  If I hit refresh, I get another error:
  Unknown column 'pn_aid' in 'field list'
  UPDATE nuke_stories SET pn_cr_uid = pn_aid
  
  Any ideas?

  • 
  •  
• Paustian
  
  

  • Rank: Softmore
  • Registered: May 30, 2005
  • Last visit: May 31, 2010
  • Posts: 340

  Posted: Feb 07, 2012 - 10:14 AM

  What is happening is that the SQL query the news module is trying to use does not match your table structure defined in pntable.php. This is deep in the weeds, but you can fix this. Compare the nuke stories table structure in phpMyAdmin to what pnTable is expecting. You may have to rename, add or delete some columns from the table in the mysql database to get it to work. Another thing to look at is the Stories (I think that is what is was called) module vs. the news module and see how the structure has changed. Post if you have more questions.

  • 
  •  
• jmvaughn
  
  

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

  Posted: Feb 08, 2012 - 02:29 AM

  Thank you for the response, Paustian. That may be a bit beyond my capability, but I will give it a try.

  • 
  •  
• jmvaughn
  
  

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

  Posted: Feb 08, 2012 - 05:18 AM

  I tried looking at the tables as Paustian suggested, but I was lost, and I'm starting to run out of time. So I thought I'd try to start from scratch and try to duplicate how I got my last PN .764 site to import.
  
  I found that deactivating and then removing the news module from the old site before backing the DB up, then renaming the nuke_stories table, then running the Zik upgrade script, renaming the nuke_stories back, allowed the upgrade script to complete without any errors. Next I went into the administration panel where it finally showed news 2.4.1 and allowed me to install and activate without error.
  
  However, I have a new issue. All the article time/date stamps are for today. Furthermore, when I go to the home page, no articles display.
  
  I think I'm getting closer here. Any further ideas?
  
  I do really appreciate the suggestions and help.
  
  
  
  Edited by jmvaughn on Feb 08, 2012 - 05:21 AM.

  • 
  •  
• jmvaughn
  
  

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

  Posted: Feb 08, 2012 - 05:50 AM

  Forgot to add that there is a message as follows on the home page:
  
  No news articles currently published
  
  Even though the listing of articles in the news module admin page shows each article stamped "Published 02/08/2012", I thought I'd go in and see if I needed to manually mark the articles published.
  
  I did so with one of them, and it did then show up on the home page (great happiness here, I know I'm getting closer). However, the published date then showed "Published 02/08/2012".
  
  I guess the last thing I need is some way to have all the articles import with the "published" flag set and the proper date.
  
  
  
  Edited by jmvaughn on Feb 08, 2012 - 05:58 AM.

  • 
  •  
• jmvaughn
  
  

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

  Posted: Feb 08, 2012 - 06:56 AM

  Made some more progress. Thought I'd post my findings and solution for anyone else in a similar situation.
  
  I figured out that if a date is in the pn_from field of nuke_stories, the article is published and shows that date.
  
  I then deleted the pn_from column in phpMyAdmin. Next, I used some SQL commands to recreate the column and copy the contents of the pn_time column into the newly created pn_from column.
  
  Here are the SQL commands I used, in case anyone needs them:
  ALTER TABLE `nuke_stories` ADD `pn_from` TEXT NOT NULL;
  UPDATE `nuke_stories` SET `pn_from` = `pn_time`;
  
  My articles now show up on the home page, and have the correct date.
  
  Next I'd like to see if I can get the topics and the icons to display for the articles. Will post back if I can get it to work.
  
  
  
  Edited by jmvaughn on Feb 08, 2012 - 07:25 AM.

  • 
  •  
• Paustian
  
  

  • Rank: Softmore
  • Registered: May 30, 2005
  • Last visit: May 31, 2010
  • Posts: 340

  Posted: Feb 08, 2012 - 07:10 AM

  You actually ended up doing what I was suggesting for the tables. The upgrade worked because you got rid of the troublesome tables during the upgrade process and then installed data afterward. You then solved the mismatch, by renaming your table column. Nice job!

  • 
  •  
• jmvaughn
  
  

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

  Posted: Feb 08, 2012 - 07:23 AM

  Thanks, Paustian :)
  
  I do have a couple of unresolved issues with regard to the news articles. First, the topic icons don't display for the articles (the image files are there, and they show up when I click on Topics in the admin panel).
  
  Second, when I click on the archive link above the news items on the home page, I get a list of all the years and months with articles (back to 2004, we have a lot of articles). When I click on some of the months (e.g., June 2008) that shows there are articles (17 in that case), no articles are displayed on the list that comes up. However, some months (e.g., Dec. 2008, which shows 9 articles present) DO show a list of articles, and the correct number to boot.
  
  Anyone have some ideas on how I might fix these last two news related issues?

  • 
  •  
•  
•  

Users on-line

• craigh,
• mazdev

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