Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 22

  Posted: Jun 28, 2006 - 01:50 AM

  Hello!
  I come here for ask something that have me in a trouble.
  I started to code a module. I read many manuals and study the whole Example mod. When I finished the pntables and pninit files, I tried to initialize it but nothing happens. The postnuke 0.762 installation is correct (other mods. start correctly)
  The mod folder's name is revist.
  
  Here you are the content of both files. What I done wrong?
  
  pntables.php
  

  Code

  <?php
  function revist_pntables() {
      $pntable = array();
      $revs = pnConfigGetVar('prefix') . '_revista';
      $pntable['revista'] = $revs;
      $pntable['revista_column'] = array('rid' => 'pn_rid',
                                          'rurl' => 'pn_url',
                                          'rfecha' => 'pn_fecha',
                                          'rimagen' => 'pn_imagen');
  return $pntable;
  }
  ?>

  
  
  pninit.php
  

  Code

  <?php
  function revist_init()
  {
      $dbconn  =& pnDBGetConn(true);
      $pntable =& pnDBGetTables();
      $revtable  = &$pntable['revista'];
      $revcolumn = &$pntable['revista_column'];
      $dict = &NewDataDictionary($dbconn);
      $taboptarray =& pnDBGetTableOptions();
      $flds = "
          $revcolumn[rid] I NOTNULL AUTOINCREMENT PRIMARY,
          $revcolumn[rurl] C NOTNULL DEFAULT '',
          $revcolumn[rfecha] D NOTNULL DEFDATE,
          $revcolumn[rimagen] C NOTNULL DEFAULT ''
      ";
      $sqlarray = $dict->CreateTableSQL($revtable, $flds, $taboptarray);
      if ($dict->ExecuteSQLArray($sqlarray) != 2) {
          pnSessionSetVar('errormsg', _EXAMPLECREATETABLEFAILED);
          return false;
      }
      return true;
  }
  
  function revist_delete()
  {
      $dbconn = pnDBGetConn(true);
      $pntable = pnDBGetTables();
      $revtable = $pntable['revista'];
      $dict = &NewDataDictionary($dbconn);
      $sqlarray = $dict->DropTableSQL($revtable);
      if ($dict->ExecuteSQLArray($sqlarray) != 2) {
          pnSessionSetVar('errormsg', _EXAMPLEDROPTABLEFAILED);
          return false;
      }
      return true;
  }
  
  function revist_update()
  {
      return true;
  }
  ?>

  
  
  Please help!! THANKS!
  
  
  
  edited by: SiCk949, Jun 28, 2006 - 02:50 PM

  • 
  •  
• markwest
  
  

  • Rank: Team Member
  • Registered: Mar 18, 2002
  • Last visit: Oct 21, 2009
  • Posts: 6606

  Posted: Jun 28, 2006 - 02:02 AM

  Looks ok from a quick glance - although it's easy to miss things on screen. What diagnositics have you done so far? I'd recommend
  
  1) checking there are no sytax errors in the file by calling it directly in the browser i.e. http://www.example.com/modules/yourmod/pninit.php (make sure display errors are on in your PHP install first). If there's a syntax error you'll see it here
  2) Add a die statement to the first line of init function to check that your init function is being reached - remove after this check....
  3) print out the sqlarray variable and then paste the generated SQL into phpMyAdmin get some better feedback on why your SQL might not be working ok.
  
  -Mark
  
  --
  Visit My homepage and Zikula themes.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 22

  Posted: Jun 28, 2006 - 02:44 AM

  Hello!
  First of all, thanks for ur help!
  1) I check the pninit.php on browser and no errors result (Blank Page).
  2) I can't understand this step.
  3) Cause the use of ADODB I don't know how to from the SQL command.
  I tried:
  
  CREATE TABLE `pn_revista` (
  `pn_rid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `pn_rurl` CHAR NOT NULL DEFAULT '',
  `pn_rfecha` DATE NOT NULL DEFAULT '0000-00-00',
  `pn_rimagen` CHAR NOT NULL DEFAULT '');
  
  And works correctly (don't know if it correspond with my code, but its that i wanna create)
  Thanks again
  
  
  EDIT
  finally i edited the SQL string to
  

  Code

  $revcolumn[rid]     I       NOTNULL AUTOINCREMENT PRIMARY,
          $revcolumn[rurl]    C(255)  NOTNULL default '',
          $revcolumn[rfecha]  D       NOTNULL DEFDATE,
          $revcolumn[rimagen] C(255)  NOTNULL default ''

  
  and works!!!
  thanks markwest!
  
  
  
  edited by: SiCk949, Jun 28, 2006 - 02:55 PM

  • 
  •  
• markwest
  
  

  • Rank: Team Member
  • Registered: Mar 18, 2002
  • Last visit: Oct 21, 2009
  • Posts: 6606

  Posted: Jun 28, 2006 - 04:30 AM

  The idea of step 3 was to add the following code just after the call to the CreateTableSQL method. This gets you to the SQL generated for your DB - this can be pasted into phpMyAdmin for a better look at what mysql is returning.
  
  

  Code

  print_r($sqlarray);
  die;

  
  
  Anyway looks like you've got there - a missing default date.
  -Mark
  
  --
  Visit My homepage and Zikula themes.

  • 
  •  
•  
•  

Users on-line

• mesteele101

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