[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