Zikula Community

• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 20, 2010 - 03:11 PM

  I have finally decided to get off my kiester and figure out how to upgrade my site.
  
  Some background for you...
  
  I am currently running Zikula 1.1.2, PHP 5.2.13, and MySQL 5.1.46
  
  I would like to upgrade to 1.2.3 but I am also using PagEd 1.0 as my primary content module. PagEd won't was designed for PostNuke and won't work in any version of Zikula past 1.1.2 (trust me, I've checked). MUTransport 1.2.5 is supposed to convert PagEd content to News but it doesn't work in 1.1.2. I noticed that MUTransport version 1.0 is supposed to work with Zikula 1.1.2 but when I tried to regenerate the module list I got a 500 error. I also tried using legacy support with no success.
  
  I have tried to work with a localhost but for some reason it's not working properly. I'm using xampp but I think I've got a newer version so I think it's messing things up somehow. I'll try an older version and see what happens.
  
  If I can get it working on LocalHost I will try Zikula 1.1.2 with PagEd 1.0 and then upgrade Zikula to 1.2.3 and MUTransport to 1.2.5 and I'll see what happens. If it works I'll consider doing it on my website.
  
  Does anyone have any suggestions to keep me from screwing things up completely?
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• HalbrookTech
  
  

  • Rank: Developer
  • Registered: Dec 31, 1969
  • Last visit: Jun 01, 2010
  • Posts: 6859

  Posted: Jul 20, 2010 - 04:00 PM

  eledril

  If I can get it working on LocalHost I will try Zikula 1.1.2 with PagEd 1.0 and then upgrade Zikula to 1.2.3 and MUTransport to 1.2.5 and I'll see what happens. If it works I'll consider doing it on my website.

  
  
  The fact that PageEd won't run on 1.2.x and that MUTransport 1.2.5 won't run on 1.1.x yet was the first version to convert PageEd as I recall, should tell ya that PageEd doesn't need to be functioning to handle the conversion most likely :). I presume the live site is on a Linux server? If so, why not get VirtualBox and create a virtual Linux server with all the required stuff and work there? Or, depending on your hosting platform, my usual method is the use a subdomain and a clone of the database to test on.
  
  --
  Home Page | Find on Facebook | Follow on Twitter
  

  • 
  •  
• espaan
  
  

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

  Posted: Jul 20, 2010 - 07:33 PM

  Hi, first of all best of luck of course, since upgrading with older modules is always a hard.
  
  I would give xampp another try and get a zikula 123 running with your PagEd tables in the database and mutransport active. You can then try the convert to News from the PagEd tables. Pageed does not have to be running to import from (AFAIK, havent actually tried mutransport).
  With a localhost and xampp you can easily do database manipulation, copy (and re-copy) files etc.
  
  This is also what happens when a module is doing an upgrade from an much older version. The previous version does not have to run in the new zikula version to be able to upgrade the tables. It is just fiddling with database tables and modules variables.
  
  --
  campertoday.nl, Module development, Dutch Zikula Community

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 28, 2010 - 06:46 PM

  Thanks for the comments guys, I appreciate it.
  
  For some reason I was never able to get xampp to work on the LocalHost. I'll try VirtualBox and let you know what happens.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 28, 2010 - 07:04 PM

  I get to play with Linux now... should be fun.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 29, 2010 - 05:58 PM

  Currently banging my head on my keyboard... fighting with Ubuntu, trying to install xampp to the Ops folder like it says and it won't let me. I'll try xampp in Windows again and see if I can get it to work.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• HalbrookTech
  
  

  • Rank: Developer
  • Registered: Dec 31, 1969
  • Last visit: Jun 01, 2010
  • Posts: 6859

  Posted: Jul 29, 2010 - 06:32 PM

  Did you install Ubuntu in VirtualBox or did you download a pre-installed image?
  
  --
  Home Page | Find on Facebook | Follow on Twitter
  

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 29, 2010 - 06:43 PM

  I installed it. I tried again and managed to get 1.2.3 running on xampp running in Windows. I'll try it and see what happens.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Aug 07, 2010 - 05:05 PM

  Okay... so I've got xampp running in Windows 7 with Zikula 1.2.3. I imported PagEd's SQL Tables and copied the PagEd folder from my live site to the Local Host.
  In Modules, PagEd shows as Not Installed. When I try to install, I get "Error! Invalid module state transition. Error! Could not change module state." In MUTransport 1.2.5, PagEd shows up but as "not installed".
  My question is this... Is there any way to install, initialize or activate PagEd in Zikula without going through the Modules module? Would I go into one of the config.php files or is it something I need to change in the SQL table?
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: May 18, 2010
  • Posts: 985

  Posted: Aug 08, 2010 - 02:18 AM

  In eg. phpMyAdmin/mysqlDumper change following:
  _PREFIX_modules --> pn_state --> change to '3'
  that should do the trick
  
  - Igor

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Aug 08, 2010 - 04:56 AM

  That worked. It's now active, and somehow, I have no idea how, but PagEd 1.0 is working in Zikula 1.2.3. I did a test post and it shows up. I have 2 separate SQL tables for PagEd now. Z_ and ZK_. Z_ is the new one and ZK_ is the old one. Is there a way to import the data from the ZK_ tables into the Z_ tables or can I rename the tables?
  
  
  
  Edited by eledril on Aug 08, 2010 - 11:58 AM.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: May 18, 2010
  • Posts: 985

  Posted: Aug 08, 2010 - 05:51 AM

  you can do an export/import and change eg.
  INSERT INTO `ZK__pageEd` [ < -- this is an example of course]
  or indeed you can rename it too if you want to
  
  - Igor

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Aug 08, 2010 - 03:24 PM

  So, I renamed the tables and the articles are showing up. I tried to use MUTransport to import the PagEd articles into News but I got a Blank Page. Any suggestions?
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Aug 08, 2010 - 03:38 PM

  I added "php_flag display_errors on" to the .htaccess file but I will still getting the Blank Page.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Aug 08, 2010 - 04:17 PM

  Apparently the PagEd articles did get transferred over. When I tried to approve them, I got the error "Exit handler:Invalid table-key [news] passed to _getAllColumns. Exit handler:Exiting after SQL-error. Exit handler:Error! Invalid result received." but it seems they were approved anyway.
  I then changed the Start Page from "PagEd" to "News" and it looks just awful.
  The main block shows at the top:
  _NEWS
  [ _NEWS_CATEGORYLIST | _NEWS_ARCHIVES | _NEWS_SUBMIT ]
  Any of the images that I had included show up as
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
•  
•  

Users on-line

• 0 users

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