[ic] Rh9 perl5.8 search failure

Aaron Rubin ronnie at karatedepot.com
Wed Sep 29 08:50:52 EDT 2004

Debugging info from around the error, datatrace=4 and DBI.pm debugging

Vend::Table::DBI:debug: bad= connecting to
    DBI::db=HASH(0x9c11834) trace level set to 0x0/4 (DBI @ 0x0/0) in
DBI 1.43-nothread (pid 6505)
Vend::Table::DBI:debug: products: DBI didn't die, bad=
Vend::Table::DBI:debug: products connected to
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x9c11834)~INNER 'Driver')
    .. FETCH DBI::db=HASH(0x9c11834) 'Driver' = DBI::dr=HASH(0x8222b6c)
    <- FETCH= DBI::dr=HASH(0x8222b6c) at DBI.pm line 622 via
/usr/lib/interchange/lib/Vend/Data.pm line 1040
Vend::Table::DBI:debug: connect count open: 1
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9c11834)~INNER 'RaiseError'
    STORE DBI::db=HASH(0x9c11834) 'RaiseError' => 1
    <- STORE= 1 at DBI.pm line 637 via
/usr/lib/interchange/lib/Vend/Data.pm line 1040
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9c11834)~INNER 'PrintError'
    STORE DBI::db=HASH(0x9c11834) 'PrintError' => 0
    <- STORE= 1 at DBI.pm line 637 via
/usr/lib/interchange/lib/Vend/Data.pm line 1040
    -> prepare for DBD::Pg::db (DBI::db=HASH(0x9c50e54)~0x9c11834
'select sku from products where sku = ?')
DBD::Pg::st, 9b4df58, Null!)
    dbih_make_com(DBI::db=HASH(0x9c11834), 9c660f0, DBD::Pg::st, 140, 0)
dbd_st_prepare: statement = >select sku from products where sku = ?<
    dbd_preparse scanned 1 placeholders
    <- prepare= DBI::st=HASH(0x9b4e000) at DBI.pm line 1649 via
/usr/lib/interchange/lib/Vend/Data.pm line 158
    -> selectrow_array for DBD::Pg::db
(DBI::db=HASH(0x9c50e54)~0x9c11834 DBI::st=HASH(0x9b4e000) undef
		 bind $1 <== 'error/HTTP_NOT_FOUND.html.var' (type 0)


-----Original Message-----
From: interchange-users-bounces at icdevgroup.org
[mailto:interchange-users-bounces at icdevgroup.org] On Behalf Of Aaron
Sent: Tuesday, September 28, 2004 8:12 PM
To: interchange-users at icdevgroup.org
Subject: [ic] Rh9 perl5.8 search failure

Hey everyone,	

  I'm putting up a new site and am setting up using Rh9 perl5.8
postgresql (sharing the database with out other store) It worked for a
while, then suddenly all static pages which use search-region return
missing pages with "Sorry, the page
(error/HTTP_INTERNAL_SERVER_ERROR.html.var) was not found", nothing in
the local or global error logs and "Premature end of script headers:
catalog" in httpd/error_log
  I rebuilt perl using perl-kitchensink-5.8.0-rh9, reinstalled
interchange, redid the pgsql/conf and everything ran fine for about a
day (site isn't live, I was using it though, putting in the signio
information and testing credit card transactions) and then the same
thing happened. All pages that include [search-region] and scan type
searched always fail and always return Premature end of script headers:
catalog in httpd/error_log.
  The products table we use has many added and renamed fields from the
foundation store.
  All non search pages including flypage work fine and orders can be
  Any ideas?


interchange-users mailing list
interchange-users at icdevgroup.org

More information about the interchange-users mailing list