[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:Pg:host=********;port=5432;dbname=catalog
    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
DBI:Pg:host=*******;port=5432;dbname=catalog__
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x9c11834)~INNER 'Driver')
dbd_db_FETCH
    .. 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'
1)
dbd_db_STORE
    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'
0)
dbd_db_STORE
    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 = ?')
    dbih_setup_handle(DBI::st=HASH(0x9b4e000)=>DBI::st=HASH(0x901e374),
DBD::Pg::st, 9b4df58, Null!)
    dbih_make_com(DBI::db=HASH(0x9c11834), 9c660f0, DBD::Pg::st, 140, 0)
thr#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
'error/HTTP_NOT_FOUND.html.var')
dbd_bind_ph
		 bind $1 <== 'error/HTTP_NOT_FOUND.html.var' (type 0)
dbd_st_execute


Thanks.
aaron

-----Original Message-----
From: interchange-users-bounces at icdevgroup.org
[mailto:interchange-users-bounces at icdevgroup.org] On Behalf Of Aaron
Rubin
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
placed.
  Any ideas?

aaron

_______________________________________________
interchange-users mailing list
interchange-users at icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users



More information about the interchange-users mailing list