Zikula Community

• bvdbos3
  
  

  • Rank: Registered User
  • Registered: Mar 06, 2011
  • Last visit:
  • Posts: 37

  Posted: Sep 23, 2011 - 04:01 PM

  I have PN0.764 site with quite some content in the htmlpages-module, I'm doing a test-upgrade to ZK1.2.8. The last version of htmlpages is version 2.2 from 20-11-2007, almost four years old now. htmlpages work in ZK1.2.8 but I don't know how htmlpages will work in ZK1.3.x so to be on the safe side, I wanted to convert to the pages-module v2.4.1.
  
  Converting the data from htmlpages to the pages module was quite easy with the following query, assuming your pages-module has no data in it before the conversion:
  

  Code

  insert into pn_pages (pn_pageid,pn_title, pn_content,pn_counter,pn_displaywrapper,pn_displaytitle, pn_displaycreated,pn_displayupdated, pn_displaytextinfo,pn_displayprint,pn_obj_status, pn_cr_date,pn_cr_uid,pn_lu_date,pn_lu_uid) select pn_pid,pn_title,pn_content,'0','1','1','1','1','1', pn_printlink,'1',pn_timest,pn_uid,now(),pn_uid from pn_htmlpages

  
  
  I use file-based short urls. To keep my existing links working I added
  

  Code

  # htmlpages to pages
  RewriteRule ^module-htmlpages-display-pid-([0-9]+).p?html?$ module-Pages-display-pageid-$ 1.html

  
  just after the basic entry rules.
  
  Above query doesn't set the category though.
  
  
  
  Edited by bvdbos3 on Sep 23, 2011 - 04:35 PM.

  • 
  •  
•  
•  

Users on-line

• 0 users

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