Zikula Community

• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Aug 21, 2007 - 05:17 AM

  Hi all!
  Last days, i began to explore pnWikka to manage content instead sections, and because some documents and info are cooperative, etc.
  
  I'm still a newbie using pnWikka and what i see, is that the 'auto-generated-links' to the other pages, must be the same Tags.
  
  I wonder if i can hack pnWikka to auto-generate "readable links" instead Tag-links. Change the One-Word-Tag form to a Wikipedia style... avoiding to put the links manually.
  Something like a hook that create/modify a Wiki reference when a pnWikka page is created/modified?
  I'll see...
  
  Here in the PN-Wiki develop some stuff that isn't included in the pnWikka module?
  
  
  
  edited by: nestormateo, Aug 21, 2007 - 09:14 PM
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Aug 21, 2007 - 06:59 AM

  When i've tried to install in my hosting (Apache 1.3.37 (Unix), PHP 5.1.6, MySQL 5.0.27-standard-log, Linux x86_64), launchs an error:
  _PNCG_CREATEINDEXFAILED - BLOB/TEXT column 'body' used in key specification without a key length
  
  pnWikka is only available in the SVN-nightly-build right?
  Will be published the improved version that works here in the PN community?
  
  
  
  edited by: nestormateo, Aug 21, 2007 - 09:27 PM
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• AmmoDump
  
  

  • Rank: Team Member
  • Registered: Dec 07, 2003
  • Last visit: May 09, 2010
  • Posts: 2703

  Posted: Aug 21, 2007 - 09:47 AM

  Mateo,
  
  I will PM you with a release copy.
  
  
  
  --
  David Pahl
  Zikula Support Team

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Aug 21, 2007 - 10:16 AM

  Thanks a lot David!
  i'm here.
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 19, 2007
  • Posts: 2

  Posted: Oct 19, 2007 - 01:11 AM

  Good morning all...
  
  This is really my first foray into the world of CMS and PN. I had toyed around with PN about a year ago (and Joomla and something else), but decided CMS was overkill for what I was doing at the time. Since then, I've taken on a new project that CMS is perfect for, and PN is the only one that I really liked.
  
  Anyways, out of curiosity, why is pnWikka so hard to find? There is nothing on Chestnut's site, the http://noc.postnuke.com/projects/pnconcept/ link only references the pnWikka bug report, and I'd found a thread in which a member had listed a link to a nightly SVN http://maledivenhilfe.com/pn/modules/pnWikka-1.0b+SVN20070202+multilang.tar.gz which I downloaded and attempted to install, but received the following error:
  
  

  Code

  _PNCG_CREATEINDEXFAILED - BLOB/TEXT column 'body' used in key specification without a key length [setvar] at line 301 in file /home/site/public_html/community/includes/pnobjlib/SessionUtil.class.php.

  
  
  I am running PN .8 RC1, and understand not everything has been tested and expected to work, etc... but I like living dangerously.
  
  Server:
  Operating system Linux
  Kernel version 2.6.9-023stab044.4-enterprise
  Machine Type i686
  Apache version 1.3.37 (Unix)
  PERL version 5.8.8
  PHP version 4.4.2
  MySQL version 4.1.22-standard
  
  Thanks,
  
  
  Jon

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Oct 19, 2007 - 04:12 AM

  Welcome to the Community Jon!,
  i've hacked a little the init code of pnWikka to avoid that error.
  The first table creation works with:
  
  
  

  Code

  // MAIN TABLE
      $tbl = &$pntable['pnwikka_pages'];
      $col = &$pntable['pnwikka_pages_column'];
  
      $sql ="
             id                   I(11)     NOT NULL AUTO PRIMARY,
             tag                  C(75)     NOT NULL DEFAULT '',
             time                 T         NOT NULL DEFAULT '0000-00-00 00:00:00',
             body                 X2        NOT NULL,
             owner                C(75)     NOT NULL DEFAULT '',
             user                 C(75)     NOT NULL default '',
             latest               C(1)      NOT NULL default 'N',
             note                 C(100)    NOT NULL default '',
             handler              C(30)     NOT NULL default 'page'
            ";
  
      $sqlarray = $dict->CreateTableSQL($tbl, $sql, $taboptarray);
  
      if ($dict->ExecuteSQLArray($sqlarray) != 2) {
          pnSessionSetVar('errormsg', _PNCG_CREATEMAINTABLEFAILED." - ".$dbconn->ErrorMsg());
          return false;
      }
  
      // Define the name of the index
      $idxname  = 'tag';
      $idxname2 = 'body';
  
      // Define columns with index
      $idxflds  = 'tag';
      $idxflds2 = 'body(500)';
  
      // Index options
      $idxoptarray = array();
      if (strtolower($dbtype) == 'mysql' && strtolower($dbtabletype) == 'myisam') {
          $idxoptarray = array('FULLTEXT' => 'FULLTEXT');
      }
  
      // ... and creating the index
      $sqlarray = $dict->CreateIndexSQL($idxname,  $tbl, $idxflds,  $idxoptarray);
  
      if ($dict->ExecuteSQLArray($sqlarray) != 2) {
          pnSessionSetVar('errormsg', _PNCG_CREATEINDEXFAILED." - ".$dbconn->ErrorMsg());
          return false;
      }

  
  
  
  I just added a fixed width (500) to the index field, but 500 characters of body is very little to be a MySQL.MyISAM.FULLTEXT index right, so i think that must be greater, but i don't know how much.
  
  
  Welcome again and Good luck!
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• slam
  
  

  • Rank: Team Member
  • Registered: May 03, 2004
  • Last visit: May 31, 2010
  • Posts: 511

  Posted: Oct 19, 2007 - 04:20 AM

  @ Mateo: As the necessary changes cumulated recently, and several people showed interest in contributing to pnWikka, I recently contacted Franky and proposed to open up development of this fine module. Unfortunately I never received an answer. As I have already contributed some stuff to this module, and use it for several bigger sites I decided to start a (hopefully temporary!) fork of it. You can find it at the NOC here http://noc.postnuke.com/plugins/scmsvn/viewcvs.php/?root=vpContact (I used another old project I had there and I'm not working on any more). Feel free to check out the latest code, or - even better - join us there.
  Greetings,
  Chris
  
  --
  an operating system must operate
  development is life
  my repo

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Oct 19, 2007 - 06:51 AM

  Very nice initiative slam!
  I'll send you the Spanish language pack too...
  and about this topic, i can't modify the pnWikka functions to support spaces into internal links... i've modified the pattern but without success...
  
  See you in the NOC soon!
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 19, 2007
  • Posts: 2

  Posted: Oct 19, 2007 - 03:29 PM

  Mateo, thank you very much. I'll give it a try this weekend.

  • 
  •  
•  
•  

Users on-line

• mesteele101

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