Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Jul 07, 2005
  • Posts: 6

  Posted: Jul 04, 2005 - 11:44 PM

  Hi forum,
  
  I'am developing a new module for the german red cross and currently stuck at getting my pninit.php to work.
  
  The pninit.php works as far as it creates the necessary database table, but when I try to initialisize it via the administration I get a Blank Page. After that I try to reload the site and it shows me the administration panel and the modules list, with "You are not authorized to carry out this operation" above it.
  
  Anyone can offer a hint?
  
  Sorry for my poor english...

  • 
  •  
• **unknown user**
  
  

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

  Posted: Jul 04, 2005 - 11:50 PM

  safroe

  Hi forum,
  
  I'am developing a new module for the german red cross and currently stuck at getting my pninit.php to work.
  
  The pninit.php works as far as it creates the necessary database table, but when I try to initialisize it via the administration I get a Blank Page. After that I try to reload the site and it shows me the administration panel and the modules list, with "You are not authorized to carry out this operation" above it.
  
  Anyone can offer a hint?
  
  Sorry for my poor english...

  
  
  the you are not authorized, is for security, you cant refresh it.
  
  
  as far as the Blank Page, u should debug the script, to see how far it actually gets, and what variables are being passed

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Jul 07, 2005
  • Posts: 6

  Posted: Jul 05, 2005 - 12:25 AM

  I don't get it, maybe could take a look. The problem seems to be the verification whether the database table creation failed or not. A var_dump($dbconn->ErrorNo() gives me 0, the SQL-command is correct and works...
  
  

  Code

  <?php
  
  function DRK_init() {
      list($dbconn) = pnDBGetConn();
      $pntable = pnDBGetTables();
      $fahrzeugtable = $pntable['_drk_fv_fahrzeug'];
      $fahrzeugcolumn = &$pntable['_drk_fv_fahrzeug_column'];
      $sql = "CREATE TABLE $fahrzeugtable ( $fahrzeugcolumn[FahrzeugID] TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
                                            $fahrzeugcolumn[FahrzeugKennzeichen] VARCHAR(12) NOT NULL DEFAULT '',
                                            $fahrzeugcolumn[FahrzeugArt] VARCHAR(32) NOT NULL DEFAULT '',
                                            $fahrzeugcolumn[FahrzeugEinheit] VARCHAR(32) NOT NULL DEFAULT '',
                                            PRIMARY KEY(FahrzeugID) )";
      $dbconn->Execute($sql);
      if($dbconn->ErrorNo() != 0) {
          pnSessionSetVar('errormsg', _CREATETABLEFAILED);
          return false;
      }  
      return true;
  }
  
  function DRK_delete() {
      list($dbconn) = pnDBGetConn();
      $pntable = pnDBGetTables();
      $sql = "DROP TABLE $pntable[_drk_fv_fahrzeug]";
      $dbconn->Execute($sql);
      if($dbconn->ErrorNo() != 0) {
          pnSessionSetVar('errormsg', _DROPTABLEFAILED);
          return false;
      }
      return true;
  }
  
  ?>

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Jul 07, 2005
  • Posts: 6

  Posted: Jul 05, 2005 - 01:14 AM

  A var_dump($dbconn->ErrorNo()); outputs "int(0)", I think that is not the same as $dbconn->ErrorNo() = 0 because int(0) is an empty value and $dbconn->ErrorNo() = 0 is an integer value with 0 in it?

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Jul 07, 2005
  • Posts: 6

  Posted: Jul 05, 2005 - 06:59 AM

  Do you acknowledge? Could anyone please confirm the rightness of my code?

  • 
  •  
• **unknown user**
  
  

  • Rank: Senior
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 2330

  Posted: Jul 05, 2005 - 07:22 AM

  Make sure there is no white-space or extra lines after the ?> ... this is a leading cause of white-screen errors in the init process, IMHO.
  
  Maybe try these as your first 2 lines in the init function:
  

  Code

  $dbconn  =& pnDBGetConn(true);
  $pntable =& pnDBGetTables();

  
  
  ...overall, it looks like your function should work...I don't see anything throwing up a red flag, but my eyes are tired...

  • 
  •  
• **unknown user**
  
  

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

  Posted: Jul 05, 2005 - 08:05 AM

  Do you also have the upgrade function? I think you have to have it present, even if it doesn't have any code in it.

  • 
  •  
• **unknown user**
  
  

  • Rank: Senior
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 2330

  Posted: Jul 05, 2005 - 08:08 AM

  Good idea jediping... I didn't think it was required, but nonetheless...even if just:

  Code

  function DRK_upgrade()
  {
     return true;
  }

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Jul 07, 2005
  • Posts: 6

  Posted: Jul 05, 2005 - 08:27 AM

  Ah, that did work. I BIG thanks to you...
  Am I right that the & in:
  

  Code

  $dbconn  =& pnDBGetConn(true);
  $pntable =& pnDBGetTables();

  
  gives me the first array-value?

  • 
  •  
• **unknown user**
  
  

  • Rank: Senior
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 2330

  Posted: Jul 05, 2005 - 08:35 AM

  What was is that worked...adding the upgrade function...or changing up the $dbconn...?
  
  The & doesn't give you the first array value...it gives you a reference to the database connection resource as a whole, if I understand it correctly.

  • 
  •  
• Simon
  
  

  • Rank: Legend
  • Registered: Dec 11, 2002
  • Last visit: Oct 21, 2009
  • Posts: 11674

  Posted: Jul 05, 2005 - 09:16 AM

  Quote

  The & doesn't give you the first array value...it gives you a reference to the database connection resource as a whole, if I understand it correctly.

  
  
  Yes, you reference the object rather than creating a copy of it (which is what = does). This uses less memory, and also has some other applications, which I've used in the past and have now forgotten
  
  --
  itbegins.co.uk - Zikula Consulting
  
  birtwistle.me.uk - Personal Blog
  
  
  Please read the Support Guide

  • 
  •  
• **unknown user**
  
  

  • Rank: Senior
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 2330

  Posted: Jul 05, 2005 - 09:18 AM

  Then, if the reference is changed or altered, the original variable is also changed to reflect that, right?

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Jul 07, 2005
  • Posts: 6

  Posted: Jul 05, 2005 - 06:11 PM

  I think the upgrade function and deleting all whitespaces after the ?>

  • 
  •  
•  
•  

Users on-line

• slam

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