[ic] undefined carts on upgrade

[David Etheredge]

I think I Found where the cart keeps hanging on interchange startup.

The databases for variable and locale process just fine and the .gdbm files 
get built but the next file is tree and this is where the errors occur:



_______________

Vend::Table::DBI:debug: DBI trying create table tree

Vend::Table::DBI:debug: DBI out# = 5

Vend::Table::DBI:debug: DBI tree find_dsn dump= [

'dbi:Pg:dbname=ezclark',

undef,

undef,

{

'AutoCommit' => 0

},

{

'AutoCommit' => 0

}

]

Vend::Table::DBI:debug: DBI create_sql called, tablename=tree 
config=HASH(0x4be33a8) columns=ARRAY(0x32a9f78)

table tree created: create table tree (

code INT NOT NULL PRIMARY KEY,

parent_fld varchar(20),

mgroup varchar(255),

msort varchar(8),

page varchar(255),

form varchar(255),

name varchar(255),

description varchar(255),

inactive int not null default 0,

extended text,

next_line varchar(255),

indicator varchar(255),

exclude_on varchar(255),

depends_on varchar(255),

super varchar(255),

help_name varchar(255),

img_dn varchar(255),

img_up varchar(255),

img_sel varchar(255),

img_icon varchar(255),

url varchar(255),

member varchar(1)

)

Vend::Table::DBI:debug: Running: CREATE INDEX tree_parent_fld ON tree 
(parent_fld)

Vend::Table::DBI:debug: Running: CREATE INDEX tree_mgroup ON tree (mgroup)

Vend::Table::DBI:debug: Running: CREATE INDEX tree_msort ON tree (msort)

Vend::Table::DBI:debug: DBI connect count close: -1

Vend::Table::DBI:debug: DBI out# = 5

Vend::Table::DBI:debug: DBI tree find_dsn dump= [

'dbi:Pg:dbname=ezclark',

undef,

undef,

{

'AutoCommit' => 0,

'RaiseError' => 1,

'PrintError' => 0

},

{

'AutoCommit' => 0,

'RaiseError' => 1,

'PrintError' => 0

}

]

Vend::Table::DBI:debug: DBI opening table class=Vend::Table::DBI 
tablename=tree config={

'PRINTERROR' => 0,

'PASS' => undef,

'SEQUENCE_KEY' => 'INT NOT NULL PRIMARY KEY',

'AUTO_SEQUENCE_DROP' => '1',

'NO_ASCII_INDEX' => '1',

'file' => 'tree.txt',

'HAS_DESCRIBE' => 0,

'DELIMITER' => ' ',

'AUTO_NUMBER_FILE' => 
'/home/ezclark/catalogs/ezclark/products/.tree.autonumber',

'KEY_DEF' => 'char (16) NOT NULL',

'HIDE_FIELD' => 'inactive',

'INDEX' => [

'parent_fld',

'mgroup',

'msort'

],

'HAS_TRANSACTIONS' => 1,

'_Checked_capability' => 2,

'COLUMN_DEF' => {

'member' => 'varchar(1)',

'inactive' => 'int not null default 0',

'msort' => 'varchar(8)',

'parent_fld' => 'varchar(20)',

'extended' => 'text'

},

'included_from' => 'dbconf/pgsql/tree.pgsql',

'db_text' => '/home/ezclark/catalogs/ezclark/products/tree.txt',

'EXTENDED' => '',

'delimiter' => ' ',

'MAX_FIELD_LENGTH' => 'SELECT 
a.attnum,t.typname,a.attlen,a.atttypmod,a.attname FROM pg_class 
c,pg_attribute a,pg_type t WHERE c.relname=\'_TABLE_\' AND a.attnum > 0 AND 
a.attrelid = c.oid AND a.atttypid = t.oid ORDER BY a.attnum;',

'USER' => undef,

'HIDE_AUTO_FILES' => '1',

'ALTER_INDEX' => 'CREATE _UNIQUE_ INDEX $TABLE$_$COLUMN$ ON _TABLE_ 
(_COLUMN_)',

'KEY' => 'code',

'TABLE_COMMENT_SQL' => 'COMMENT ON _TABLE_ IS _COMMENT_',

'Exists_handle' => undef,

'Update_handle' => undef,

'name' => 'tree',

'_Insert_h' => undef,

'SEQUENCE_VALUE_FUNCTION' => 'SELECT currval(\'_SEQUENCE_NAME_\')',

'HAS_LIMIT' => 1,

'dsn_id' => undef,

'Class' => 'DBI',

'type' => 8,

'RAISEERROR' => 1,

'_Auto_number' => 'tree_seq',

'ObjectType' => 'Vend::Table::DBI',

'ALTER_CHANGE' => 'ALTER TABLE _TABLE_ CHANGE COLUMN _COLUMN_ _COLUMN_ 
_DEF_',

'db_file' => 'tree',

'UPPER_COMPARE' => 1,

'DIR' => '/home/ezclark/catalogs/ezclark/products',

'ALTER_ADD' => 'ALTER TABLE _TABLE_ ADD COLUMN _COLUMN_ _DEF_',

'COLUMN_INDEX' => {

'page' => 4,

'inactive' => 8,

'msort' => 3,

'form' => 5,

'parent_fld' => 1,

'img_dn' => 16,

'exclude_on' => 12,

'url' => 20,

'img_sel' => 18,

'img_icon' => 19,

'depends_on' => 13,

'code' => 0,

'help_name' => 15,

'member' => 21,

'name' => 6,

'super' => 14,

'next_line' => 10,

'description' => 7,

'indicator' => 11,

'img_up' => 17,

'mgroup' => 2,

'extended' => 9

},

'db_file_extended' => '/home/ezclark/catalogs/ezclark/products/.tree.sql',

'DEFAULT_TYPE' => 'varchar(255)',

'KEY_INDEX' => 0,

'AUTOCOMMIT' => 0,

'DESCRIBE_TABLE' => 0,

'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'

],

'_Numeric_ary' => [

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef,

undef

],

'DSN' => 'dbi:Pg:dbname=ezclark',

'NUMERIC' => {},

'AUTO_SEQUENCE' => 'tree_seq',

'SEQUENCE_CREATE' => 'CREATE SEQUENCE _SEQUENCE_NAME_',

'SEQUENCE_QUERY' => 'SELECT nextval(\'_SEQUENCE_NAME_\')'

}

call=dbi:Pg:dbname=ezclark HASH(0x5fcaa58)

Vend::Table::DBI:debug: DBI bad= connecting to dbi:Pg:dbname=ezclark

Vend::Table::DBI:debug: tree: DBI didn't die, bad= 
db=DBI::db=HASH(0x5fc8a68) !

Vend::Table::DBI:debug: DBI tree connected to dbi:Pg:dbname=ezclark__ !!



_________________

The tree file is the original that comes with the dist files.



What is wrong here?