Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Mar 16, 2006
  • Posts: 16

  Posted: Feb 15, 2006 - 04:58 AM

  I'm having trouble getting the the pnUpper module installed properly. I go through the interactive setup, finish the last step, and then it dumps me back to the modules screen without the module getting initialized at all.
  
  The installation script only creates two of the tables, and then prints out this error:
  
  Error: Formatgroup table creation failed
  
  I've tried to look through the code, but i can't see where the problem is. pnUpper is .1c and postnuke install is .761
  
  Taken from pninit.php of pnUpper:
  

  Code

  $groupstable  = &$pntable['up_groups'];
  $groupscolumn = &$pntable['up_groups_column'];
  
  $flds = "
      $groupscolumn[gid]       I        AUTOINCREMENT PRIMARY,
      $groupscolumn[groupname] C  (100) NOTNULL DEFAULT '',
      $groupscolumn[directory] C  (255) NOTNULL DEFAULT '',
      $groupscolumn[image]     C  (40)  NOTNULL DEFAULT ''
  ";
  
  // Creating the table
  $sqlarray = $dict->CreateTableSQL($groupstable, $flds, $taboptarray);
  
  if ($dict->ExecuteSQLArray($sqlarray) != 2) {
      pnSessionSetVar('errormsg', _PNUPPERCREATETABLEFAILED2);
      return false;
  }
  
  $idxname = "GroupsIndex";
  $idxflds = $groupscolumn['groupname'];
  $sqlarray = $dict->CreateIndexSQL($idxname, $groupstable, $idxflds);
  
  if ($dict->ExecuteSQLArray($sqlarray) != 2) {
      pnSessionSetVar('errormsg', _PNUPPERCREATEINDEXFAILED2);
      return false;
  }

  
  
  Problem seems to be in here somewhere, but I can't nail it down. Any help would be appreciated.

  • 
  •  
• Guite
  
  

  • Rank: Team Member
  • Registered: Jan 19, 2003
  • Last visit: Apr 06, 2010
  • Posts: 442

  Posted: Feb 25, 2006 - 11:15 PM

  Hi,
  
  I am afraid i have no clue where the error could be at the moment.
  But it must be something within this part:
  
  

  Code

  $formatgroupstable  = &$pntable['up_formatgroups'];
      $formatgroupscolumn = &$pntable['up_formatgroups_column'];
  
      $flds = "
          $formatgroupscolumn[fid]       I        NOTNULL DEFAULT '',
          $formatgroupscolumn[gid]       I        NOTNULL DEFAULT ''
      ";
  
      // Creating the table
      $sqlarray = $dict->CreateTableSQL($formatgroupstable, $flds, $taboptarray);
  
      if ($dict->ExecuteSQLArray($sqlarray) != 2) {
          pnSessionSetVar('errormsg', _PNUPPERCREATETABLEFAILED3);
          return false;
      }

  
  
  --
  Guite | ModuleStudio

  • 
  •  
• Guite
  
  

  • Rank: Team Member
  • Registered: Jan 19, 2003
  • Last visit: Apr 06, 2010
  • Posts: 442

  Posted: Mar 08, 2006 - 02:33 AM

  This problem has been solved now.
  Please use this version of pninit.php, then it works with mysql 5.
  Make sure that all tables are removed before the new initialization.
  
  --
  Guite | ModuleStudio

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 418

  Posted: Sep 11, 2006 - 12:23 PM

  Got the same error, and I'm using MySQL 5, but the link posted is dead, searching the NOC for pnUpper did come with re result: no files has been posted. Anyone care to share a working copy of pninit.php?

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 379

  Posted: Sep 12, 2006 - 05:04 AM

  Change line 741 to:
  

  Code

  $pnRender->assign('authid', pnSecGenAuthKey('Modules'));

  
  
  Worked for me a while ago, anyway.
  
  http://www.guite.de/module-GuiteForum.html has support for the modules they put out. I couldn't live without pnUpper.

  • 
  •  
•  
•  

Users on-line

• mazdev

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