DBI Errors When Using Maypole

[prev] [thread] [next] [Date index for 2004/07/26]

Hello all,
I have a program I developed using Maypole and Class::DBI.  The
program works fine most of the time, but occasionally I'm receiving
the following errors in my Apache error log file:


  [Sun Jul 25 20:20:41 2004] [error] Tracker::ContactType can't SELECT
  id\nFROM   contact_type\n: DBD::mysql::st fetchrow_arrayref failed:
  fetch()
  without execute() [for Statement "SELECT id\nFROM   contact_type\n"]
  at
  /usr/local/share/perl/5.8.3/DBIx/ContextualFetch.pm line 59.\n at
  /usr/local/share/perl/5.8.3/Class/DBI/AsForm.pm line 120\n

  [Sun Jul 25 20:21:08 2004] [error] DBD::mysql::st fetchrow_array
  failed:
  fetch() without execute() [for Statement "SELECT name\nFROM
  province\nWHERE  id=?\n"] at
  /usr/local/share/perl/5.8.3/DBIx/ContextualFetch.pm line 87.\n

  [Sun Jul 25 21:21:21 2004] [error] Tracker::Contact can't SELECT
  id\nFROM
  contact\n: Can't use an undefined value as an ARRAY reference at
  /usr/local/share/perl/5.8.3/Class/DBI.pm line 1125.\n at
  /usr/local/share/perl/5.8.3/Class/DBI/Pager.pm line 48\n

  [Sun Jul 25 21:21:44 2004] [error] DBD::mysql::st fetchrow_array
  failed:
  fetch() without execute() [for Statement "SELECT name\nFROM
  province\nWHERE  id=?\n"] at
  /usr/local/share/perl/5.8.3/DBIx/ContextualFetch.pm line 87.\n
  [Sun Jul 25 21:26:52 2004] null: undef error - DBD::mysql::st
  fetchrow_array
  failed: fetch() without execute() [for Statement "SELECT mobile,
  email,
  city, person, fax, url, business, postalcode, address, province,
  company,
  home, country, created, type, title

  [Sun Jul 25 21:26:52 2004] null: FROM   contact

  [Sun Jul 25 21:26:52 2004] null: WHERE  id=?

  [Sun Jul 25 21:26:52 2004] null: "] at
  /usr/local/share/perl/5.8.3/DBIx/ContextualFetch.pm line 87.

  [Sun Jul 25 21:26:52 2004] [error] [client 192.168.0.3] File does not
  exist:
  /home/sidx/htdocs/tracker/contact/list/


As far as I can tell, these are not Maypole problems per se, but
appear to be with DBIx::ContextualFetch, or Class::DBI, or
Class::DBI::AsForm.  I have no idea why I'm receiving these errors,
since the program will run for hours before any of these errors being.
If I restart the Apache process, the program runs correctly again.

Is there anything I should be looking for to track down and solve this
problem?
        -- Robert

        -- 
            Robert James Kaes    ---  Flarenet Inc.  ---    (519) 426-3782
		 http://www.flarenet.com/consulting/
      * Putting the Service Back in Internet Service Provider *