[ic] undefined carts on upgrade

David Etheredge David_e at charter.net
Fri Jan 3 08:38:01 UTC 2014


----- Original Message ----- 
From: "Gert van der Spoel" <gert at 3edge.com>
To: <interchange-users at icdevgroup.org>
Sent: Thursday, January 02, 2014 3:06 AM
Subject: Re: [ic] undefined carts on upgrade


> Is this an InnoDB table or MYISAM? I think that upgrading could have
> affected your database.
>
> Have you tried to set up the standard catalog? The other day that I went 
> to
> the latest Interchange and had some issues with my site (server crash of
> hell), what I did was eventually to first install the Demo site and see if 
> I
> could get that one to work properly, at least the basiscs. This helped me
> identify a couple of areas that were not playing nice (mainly database
> related, but also simply because the crash had removed a few files /
> includes / images).
>
> CU,
>
> Gert
>
> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org
> [mailto:interchange-users-bounces at icdevgroup.org] On Behalf Of David
> Etheredge
> Sent: Thursday, January 02, 2014 7:30 AM
> To: interchange-users at icdevgroup.org
> Subject: Re: [ic] undefined carts on upgrade
>
>
> ----- Original Message ----- 
> From: "Stefan Hornburg (Racke)" <racke at linuxia.de>
> To: <interchange-users at icdevgroup.org>
> Sent: Tuesday, December 31, 2013 9:18 AM
> Subject: Re: [ic] undefined carts on upgrade
>
>
>> On 12/31/2013 08:01 AM, David Etheredge wrote:
>>>
>>> ----- Original Message ----- From: "David Etheredge"
>>> <David_e at charter.net>
>
> Additional updates:
>
> I enabled some of the error logging in Vend::Table::DBI and am getting the
> following:
>
>
> Vend::Table::DBI:debug: tree: DBI didn't die, bad=
> table pay_cert_redeem created: create table pay_cert_redeem (
> code varchar(32) NOT NULL PRIMARY KEY,
> pay_id varchar(32) NOT NULL,
> link_tid varchar(32) NOT NULL,
> trans_date char(128),
> ip_addr varchar(64) NOT NULL,
> trans_type varchar(64) NOT NULL,
> voided int DEFAULT 0,
> captured int DEFAULT 0,
> username varchar(64),
> amount decimal(12,2) NOT NULL,
> items text
> )
>
> ' in /home/ezclang/catalogs/ezclang/products/pay_cert_redeem.autonumber at
> /usr/local/interchange/lib/Vend/Table/DBI.pm line 575.
>
> Vend::Table::DBI:debug: Cannot create AutoNumberCounter:
> Vend::Table::DBI:debug: bad= connecting to dbi:Pg:dbname=ezclark
> Vend::Table::DBI:debug: pay_cert_redeem: DBI didn't die, bad=
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>
Set up the Standard catalog in a blank /public_html.

Something apparantly was not set up correct as file ownerships and 
permissions did not match.

Manually corrected as best as possible.

I am back to getting the same errors.

Enabled debugging and tracing. This is what I get in icdebug on interchange 
restart.:

There are 2 files that build .gdbm files locale and variable from the txt 
files. All others appear to fail although they have the same ownre, group, 
and file attributes.
DBI::db=HASH(0x41bfde8) trace level set to 0x0/1 (DBI @ 0x0/0) in DBI 
1.630-ithread (pid 5304)

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM tree WHERE 2 = 1')= DBI::st=HASH(0x41c0ec0) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'parent_fld' 'mgroup' 'msort' 'page' 'form' 
'name' 'description' 'inactive' 'extended' 'next_line' 'indicator' 
'exclude_on' 'depends_on' 'super' 'help_name' 'img_dn' 'img_up' 'img_sel' 
'img_icon' 'url' 'member' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41c0a28))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM state WHERE 2 = 1')= DBI::st=HASH(0x9c80f0) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'sorder' 'country' 'state' 'name' 'tax' 
'postcode' 'shipmodes' 'tax_name' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41c0cc8))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM ups_cache WHERE 2 = 1')= DBI::st=HASH(0x41c1028) 
at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'weight' 'origin' 'zip' 'country' 'shipmode' 
'cost' 'updated' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x417a110))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM products WHERE 2 = 1')= DBI::st=HASH(0x41c3698) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'sku' 'description' 'title' 'template_page' 'comment' 
'thumb' 'image' 'price' 'wholesale' 'prod_group' 'category' 'tax_category' 
'nontaxable' 'weight' 'option_type' 'author' 'related' 'featured' 
'gift_cert' 'download' 'dl_type' 'dl_location' 'inactive' 'url' 'sale_price' 
'image_large' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41c3ae8))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM order_returns WHERE 2 = 1')= 
DBI::st=HASH(0x41c3da0) at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'order_number' 'session' 'username' 'rma_number' 
'nitems' 'total' 'return_date' 'update_date' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41c40e8))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM pay_cert_redeem WHERE 2 = 1')= 
DBI::st=HASH(0x41c5058) at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'pay_id' 'link_tid' 'trans_date' 'ip_addr' 
'trans_type' 'voided' 'captured' 'username' 'amount' 'items' ] at DBI.pm 
line 1873

<- DESTROY(DBI::st=HASH(0x41c5880))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM pay_cert_lock WHERE 2 = 1')= 
DBI::st=HASH(0x41c76b0) at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'pid' 'ip_addr' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41c79c8))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM pricing WHERE 2 = 1')= DBI::st=HASH(0x41c7e90) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'sku' 'price_group' 'q2' 'q5' 'q10' 'q25' 'q100' 'w2' 
'w5' 'w10' 'w25' 'w100' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41c82e0))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM merchandising WHERE 2 = 1')= 
DBI::st=HASH(0x41c9178) at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'sku' 'featured' 'banner_text' 'banner_image' 
'blurb_begin' 'blurb_end' 'timed_promotion' 'start_date' 'finish_date' 
'upsell_to' 'cross_sell' 'cross_category' 'others_bought' 'times_ordered' ] 
at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41c9400))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('ChopBlanks', '1')= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM options WHERE 2 = 1')= DBI::st=HASH(0x41c98f8) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'sku' 'o_group' 'o_sort' 'o_default' 'o_label' 
'o_value' 'o_widget' 'o_height' 'o_width' 'description' 'price' 'wholesale' 
'display_type' 'o_simple' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41b6f70))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM forum WHERE 2 = 1')= DBI::st=HASH(0x41aae40) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'parent' 'artid' 'mod_time' 'created' 'username' 
'email' 'name' 'host' 'score' 'lastscore' 'reason' 'anon' 'extended' 
'subject' 'comment' 'additional' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41d41a8))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM transactions WHERE 2 = 1')= 
DBI::st=HASH(0x41c9e50) at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'store_id' 'order_number' 'session' 'username' 
'shipmode' 'nitems' 'subtotal' 'shipping' 'handling' 'salestax' 'total_cost' 
'fname' 'lname' 'company' 'address1' 'address2' 'city' 'state' 'zip' 
'country' 'phone_day' 'phone_night' 'fax' 'email' 'b_fname' 'b_lname' 
'b_company' 'b_address1' 'b_address2' 'b_city' 'b_state' 'b_zip' 'b_country' 
'b_phone' 'order_date' 'order_ymd' 'order_wday' 'payment_method' 'po_number' 
'avs' 'order_id' 'auth_code' 'update_date' 'status' 'tracking_number' 
'affiliate' 'campaign' 'parent' 'archived' 'deleted' 'complete' 'comments' 
'currency_locale' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41b6dc0))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM inventory WHERE 2 = 1')= DBI::st=HASH(0x41bc818) 
at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'sku' 'quantity' 'stock_message' 'account' 
'cogs_account' 'min_order' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x4164088))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM country WHERE 2 = 1')= DBI::st=HASH(0x41bd088) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'sorder' 'region' 'selector' 'shipmodes' 'name' 
'iso' 'isonum' 'tax' 'no_state' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41b64d8))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM affiliate WHERE 2 = 1')= DBI::st=HASH(0x41cbd58) 
at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'affiliate' 'name' 'campaigns' 'coupon_amount' 
'join_date' 'url' 'timeout' 'active' 'password' 'image' ] at DBI.pm line 
1873

<- DESTROY(DBI::st=HASH(0x41d49e8))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM userdb WHERE 2 = 1')= DBI::st=HASH(0x41b6e50) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'username' 'password' 'acl' 'mod_time' 's_nickname' 
'company' 'fname' 'lname' 'address1' 'address2' 'address3' 'city' 'state' 
'zip' 'country' 'phone_day' 'mv_shipmode' 'b_nickname' 'b_fname' 'b_lname' 
'b_company' 'b_address1' 'b_address2' 'b_address3' 'b_city' 'b_state' 
'b_zip' 'b_country' 'b_phone' 'p_nickname' 'email' 'fax' 'phone_night' 
'address_book' 'accounts' 'preferences' 'carts' 'owner' 'file_acl' 'db_acl' 
'mail_list' 'credit_limit' 'inactive' 'dealer' 'price_level' 'updated' 
'created' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41b1790))= undef at DBI.pm line 702

<- prepare('SELECT a.attnum,t.typname,a.attlen,a.atttypmod,a.attname FROM 
pg_class c,pg_attribute a,pg_type t WHERE c.relname='userdb' AND a.attnum > 
0 AND a.attrelid = c.oid AND a.atttypid = t.oid ORDER BY a.attnum;')= 
DBI::st=HASH(0x41d4bc8) at DBI.pm line 750

<- execute= 47 at DBI.pm line 751

<- fetchrow_array= ( 1 'varchar' -1 68 'username' ) [5 items] row1 at DBI.pm 
line 755

<- finish= 1 at DBI.pm line 781

<- DESTROY(DBI::st=HASH(0x41d0838))= undef at DBI.pm line 741

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM variants WHERE 2 = 1')= DBI::st=HASH(0x41cc028) at 
DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'sku' 'description' 'comment' 'thumb' 'image' 
'image_large' 'price' 'wholesale' 'sale_price' 'weight' 'inactive' ] at 
DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x41c9ac0))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM pay_certs WHERE 2 = 1')= DBI::st=HASH(0x4206ea0) 
at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'date_issued' 'check_value' 'order_number' 
'amount' 'orig_amount' 'ip_addr' 'process_flag' 'date_expires' ] at DBI.pm 
line 1873

<- DESTROY(DBI::st=HASH(0x130cdc0))= undef at DBI.pm line 702

<- FETCH('Driver')= DBI::dr=HASH(0x7bf2b8) at DBI.pm line 677

<- STORE('RaiseError', 1)= 1 at DBI.pm line 692

<- STORE('PrintError', 0)= 1 at DBI.pm line 692

<- prepare('SELECT * FROM orderline WHERE 2 = 1')= DBI::st=HASH(0x130d2b8) 
at DBI.pm line 1863

<- execute= '0E0' at DBI.pm line 1867

<- FETCH('NAME')= [ 'code' 'store_id' 'order_number' 'session' 'username' 
'shipmode' 'sku' 'quantity' 'price' 'subtotal' 'shipping' 'taxable' 'size' 
'color' 'options' 'order_date' 'update_date' 'status' 'parent' 'affiliate' 
'campaign' 'description' ] at DBI.pm line 1873

<- DESTROY(DBI::st=HASH(0x42f9010))= undef at DBI.pm line 702

<- disconnect= 1 at DBI.pm line 806

! <- DESTROY(DBI::db=HASH(0x41bfde8))= undef during global destruction

! <- DESTROY(DBI::db=HASH(0x41bfde8))= undef during global destruction

! <- DESTROY(DBI::db=HASH(0x41bfde8))= undef during global destruction



I am about to pull my hair out which has already turned gray from this.






More information about the interchange-users mailing list