[ic] Loading of SQL table failing
Barry Treahy, Jr.
interchange-users@icdevgroup.org
Sun Sep 15 23:47:00 2002
Barry Treahy, Jr. wrote:
> Ed LaFrance wrote:
>
>> At 06:34 PM 9/14/2002 -0700, you wrote:
>>
>>> I'm having roubles converting from dbm to MySQL. I have managed to
>>> bring up a smaller table without any issue, but the products table
>>> will not load. I had added the additional fields, and double
>>> checked them against my original products.txt, and it is perfect.
>>> Where I may be running into problems is the lack of documentation on
>>> all of the fields used in the .mysql file. Anyway, I'm stuck...
>>>
>>> I have the debugging enabled, if you need to see all of the
>>> details... BTW, this is 4.8.6...
>>>
>>> Barry
>>>
>>> [snip]
>>>
>>> - - - [14/September/2002:21:15:50 -0400] - - table 'products'
>>> failed: products import failed: You have an error in your SQL syntax
>>> near ' '', '', '', 'X', 'X', 'X', 'X', '', '098.pdf', 'T3')' at line 1
>>>
>>
>> MySQL is definitely gaging on the import data step here. Perhaps you
>> a trying to import empty data into a field which is defined as NOT
>> NULL, or maybe there is an errant carriage return somewhere in the
>> file, breaking a single row into two pieces.
>
Ok, I believe I've isolated what appears to be the problem but it makes
no senese. The import is choking on a field named 'phase' which is not
a MySQL reserved word nor it is documented as an IC reserved word. Why
is this happening? I can do the obvious, changing the name, but I
don't want to do a guessing game on what others undocumented reserved
words exist...
Barry
>
>
> Auh, I had hoped that was it, the NOT NULL!, but it wasn't... I
> removed all but the ones on SKU and DESCRIPTION and it still blew up.
> Others commented that it could be extra quoting in the input stream
> but I've confirmed that no quotes, apostrophes, or carriage returns
> exist. There are a total of 50 columns, many which are null for
> numerous records.
>
> Here are the debug details from the most recent setup/import attempt.
> I've tried to fix the wrap from my cut/paste on the telnet session,
> but if I missed something, please do not hold that against me :-)
>
> [root@mml2 mmb2c]# /etc/init.d/interchange restart
> $Stopping interchange: [ OK ]
> $Starting interchange: bash: /home/treahy/.bashrc: Permission denied
> The Interchange server was not running
> (/ibin/interchange/etc/interchange.pid).
> Sending debug to /tmp/icdebug.
> Low traffic settings.
> Calling UI......UI is loaded...
> Interchange V4.8.6
> Configuring catalog mmb2c...Using MySQL,
> DSN=dbi:mysql:mmb2c...Vend::Table::DBI:debug: out# = 5
> Vend::Table::DBI:debug: area find_dsn dump= [
> 'dbi:mysql:mmb2c',
> 'XXXXXX',
> 'YYYYYY',
> {
> 'RaiseError' => 1,
> 'PrintError' => 0
> },
> {
> 'RaiseError' => 1,
> 'PrintError' => 0
> }
> ]
>
> Vend::Table::DBI:debug: bad= connecting to dbi:mysql:mmb2c
> Vend::Table::DBI:debug: area: DBI didn't die, bad=
> Vend::Table::DBI:debug: area connected to dbi:mysql:mmb2c_XXXXXXX_YYYYYY
> Vend::Table::DBI:debug: checking mysql cap ALTER_CHANGE: ALTER TABLE
> _TABLE_ CHANGE COLUMN _COLUMN_ _COLUMN_ _DEF_
> Vend::Table::DBI:debug: checking mysql cap UPPER_COMPARE:
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_KEY: INT PRIMARY
> KEY AUTO_INCREMENT
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_NO_EXPLICIT:
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_GET:
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_LAST_FUNCTION:
> select last_insert_id()
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_VAL:
> Vend::Table::DBI:debug: checking mysql cap AUTO_INDEX_PRIMARY_KEY:
> Vend::Table::DBI:debug: checking mysql cap ALTER_ADD: ALTER TABLE
> _TABLE_ ADD COLUMN _COLUMN_ _DEF_
> Vend::Table::DBI:debug: checking mysql cap HAS_TRANSACTIONS:
> Vend::Table::DBI:debug: checking mysql cap ALTER_DELETE: ALTER TABLE
> _TABLE_ DROP _COLUMN_
> Vend::Table::DBI:debug: checking mysql cap HAS_LIMIT: 1
> Vend::Table::DBI:debug: checking mysql cap ALTER_INDEX: CREATE
> _UNIQUE_ INDEX $TABLE$_$COLUMN$ ON _TABLE_ (_COLUMN_)
> Vend::Table::DBI:debug: connect count open: 1
> Vend::Table::DBI:debug: trying create table products
> Vend::Table::DBI:debug: out# = 5
> Vend::Table::DBI:debug: products find_dsn dump= [
> 'dbi:mysql:mmb2c',
> 'XXXXXX',
> 'YYYYYY',
> undef,
> undef
> ]
>
> Vend::Table::DBI:debug: checking mysql cap ALTER_CHANGE: ALTER TABLE
> _TABLE_ CHANGE COLUMN _COLUMN_ _COLUMN_ _DEF_
> Vend::Table::DBI:debug: checking mysql cap UPPER_COMPARE:
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_KEY: INT PRIMARY
> KEY AUTO_INCREMENT
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_NO_EXPLICIT:
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_GET:
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_LAST_FUNCTION:
> select last_insert_id()
> Vend::Table::DBI:debug: checking mysql cap SEQUENCE_VAL:
> Vend::Table::DBI:debug: checking mysql cap AUTO_INDEX_PRIMARY_KEY:
> Vend::Table::DBI:debug: checking mysql cap ALTER_ADD: ALTER TABLE
> _TABLE_ ADD COLUMN _COLUMN_ _DEF_
> Vend::Table::DBI:debug: checking mysql cap HAS_TRANSACTIONS:
> Vend::Table::DBI:debug: checking mysql cap ALTER_DELETE: ALTER TABLE
> _TABLE_ DROP _COLUMN_
> Vend::Table::DBI:debug: checking mysql cap HAS_LIMIT: 1
> Vend::Table::DBI:debug: checking mysql cap ALTER_INDEX: CREATE
> _UNIQUE_ INDEX $TABLE$_$COLUMN$ ON _TABLE_ (_COLUMN_)
> Vend::Table::DBI:debug: columns coming in: sku description title
> template_page comment thumb image price wholesale prod_group category
> tax_category nontaxable weight size color gift_cert related featured
> download dl_type dl_location inactive url sale_price image_large
> delivery oldsku prefix body vswr genders interfaces contact cable
> power dbranges freqmin freqmax phase length xfersku security allow_us
> allow_uk allow_intl allow_disty wirecatpage stdcatpage tier
> Vend::Table::DBI:debug: checking column 'sku'
> Vend::Table::DBI:debug: checking column 'description'
> Vend::Table::DBI:debug: checking column 'title'
> Vend::Table::DBI:debug: checking column 'template_page'
> Vend::Table::DBI:debug: checking column 'comment'
> Vend::Table::DBI:debug: checking column 'thumb'
> Vend::Table::DBI:debug: checking column 'image'
> Vend::Table::DBI:debug: checking column 'price'
> Vend::Table::DBI:debug: checking column 'wholesale'
> Vend::Table::DBI:debug: checking column 'prod_group'
> Vend::Table::DBI:debug: checking column 'category'
> Vend::Table::DBI:debug: checking column 'tax_category'
> Vend::Table::DBI:debug: checking column 'nontaxable'
> Vend::Table::DBI:debug: checking column 'weight'
> Vend::Table::DBI:debug: checking column 'size'
> Vend::Table::DBI:debug: checking column 'color'
> Vend::Table::DBI:debug: checking column 'gift_cert'
> Vend::Table::DBI:debug: checking column 'related'
> Vend::Table::DBI:debug: checking column 'featured'
> Vend::Table::DBI:debug: checking column 'download'
> Vend::Table::DBI:debug: checking column 'dl_type'
> Vend::Table::DBI:debug: checking column 'dl_location'
> Vend::Table::DBI:debug: checking column 'inactive'
> Vend::Table::DBI:debug: checking column 'url'
> Vend::Table::DBI:debug: checking column 'sale_price'
> Vend::Table::DBI:debug: checking column 'image_large'
> Vend::Table::DBI:debug: checking column 'delivery'
> Vend::Table::DBI:debug: checking column 'oldsku'
> Vend::Table::DBI:debug: checking column 'prefix'
> Vend::Table::DBI:debug: checking column 'body'
> Vend::Table::DBI:debug: checking column 'vswr'
> Vend::Table::DBI:debug: checking column 'genders'
> Vend::Table::DBI:debug: checking column 'interfaces'
> Vend::Table::DBI:debug: checking column 'contact'
> Vend::Table::DBI:debug: checking column 'cable'
> Vend::Table::DBI:debug: checking column 'power'
> Vend::Table::DBI:debug: checking column 'dbranges'
> Vend::Table::DBI:debug: checking column 'freqmin'
> Vend::Table::DBI:debug: checking column 'freqmax'
> Vend::Table::DBI:debug: checking column 'phase'
> Vend::Table::DBI:debug: checking column 'length'
> Vend::Table::DBI:debug: checking column 'xfersku'
> Vend::Table::DBI:debug: checking column 'security'
> Vend::Table::DBI:debug: checking column 'allow_us'
> Vend::Table::DBI:debug: checking column 'allow_uk'
> Vend::Table::DBI:debug: checking column 'allow_intl'
> Vend::Table::DBI:debug: checking column 'allow_disty'
> Vend::Table::DBI:debug: checking column 'wirecatpage'
> Vend::Table::DBI:debug: checking column 'stdcatpage'
> Vend::Table::DBI:debug: checking column 'tier'
> table products created: create table products (
> sku char(64) NOT NULL PRIMARY KEY,
> description VARCHAR(128) DEFAULT '',
> title VARCHAR(128) DEFAULT '',
> template_page VARCHAR(64),
> comment TEXT,
> thumb VARCHAR(64),
> image VARCHAR(64),
> price DECIMAL(12,2) NOT NULL,
> wholesale DECIMAL(12,2),
> prod_group VARCHAR(64) DEFAULT '',
> category VARCHAR(64) DEFAULT '',
> tax_category VARCHAR(64),
> nontaxable CHAR(3),
> weight VARCHAR(12),
> size VARCHAR(96),
> color VARCHAR(96),
> gift_cert VARCHAR(3),
> related text,
> featured VARCHAR(32),
> download VARCHAR(64),
> dl_type VARCHAR(8),
> dl_location VARCHAR(64),
> inactive VARCHAR(3),
> url VARCHAR(128),
> sale_price DECIMAL(12,2),
> image_large VARCHAR(64),
> delivery VARCHAR(32),
> oldsku VARCHAR(18),
> prefix VARCHAR(8),
> body VARCHAR(8),
> vswr VARCHAR(4),
> genders VARCHAR(8),
> interfaces VARCHAR(16),
> contact VARCHAR(8),
> cable VARCHAR(128),
> power decimal(5,1),
> dbranges VARCHAR(8),
> freqmin decimal(8,2),
> freqmax decimal(8,2),
> phase char(4),
> length VARCHAR(8),
> xfersku char(128),
> security VARCHAR(4),
> allow_us VARCHAR(1),
> allow_uk VARCHAR(1),
> allow_intl VARCHAR(1),
> allow_disty VARCHAR(1),
> wirecatpage VARCHAR(8),
> stdcatpage VARCHAR(8),
> tier VARCHAR(4)
> )
>
> Vend::Table::DBI:debug: Running: CREATE INDEX products_title ON
> products (title)
> Vend::Table::DBI:debug: Running: CREATE INDEX products_price ON
> products (price)
> Vend::Table::DBI:debug: Running: CREATE INDEX products_prod_group ON
> products (prod_group)
> Vend::Table::DBI:debug: Running: CREATE INDEX products_category ON
> products (category)
> Vend::Table::DBI:debug: Running: CREATE INDEX products_allow_us ON
> products (allow_us)
> Vend::Table::DBI:debug: Running: CREATE INDEX products_allow_uk ON
> products (allow_uk)
> Vend::Table::DBI:debug: Running: CREATE INDEX products_allow_intl ON
> products (allow_intl)
> Vend::Table::DBI:debug: Running: CREATE INDEX products_allow_disty ON
> products(allow_disty)
> Vend::Table::DBI:debug: set_row fields='CPL-5027-5P-SMA-79,5 Port
> Multi-Coupler,21,22,30,20,20 dB 3.5-4.5 Ghz 5 Port Multi-Coupler
> Female SMA 50 watt
> Painted,,,CPL-5212-06-TNC-79_icon.jpg,CPL-5212-06-TNC-79_small.jpg,1161.30
> ,,Couplers,Special Multi-Couplers & Monitor
> Couplers,,,,,Painted,,,,,,,,,,CPL-5212-06-TNC-79.jpg,90
> days,,CPL,STD,1.25 ,F,SMA,,,50 ,21,22,30,20,20 dB,3.5 ,4.5
> ,,,,,X,X,X,X,,098.pdf,T3'
> Vend::Table::DBI:debug: set_row popkey= query=INSERT INTO products
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?)
> Vend::Table::DBI:debug: set_row fields='CPL-5027-5P-SMA-79,5 Port
> Multi-Coupler,21,22,30,20,20 dB 3.5-4.5 Ghz 5 Port Multi-Coupler
> Female SMA 50 watt
> Painted,,,CPL-5212-06-TNC-79_icon.jpg,CPL-5212-06-TNC-79_small.jpg,1161.30
> ,,Couplers,Special Multi-Couplers & Monitor
> Couplers,,,,,Painted,,,,,,,,,,CPL-5212-06-TNC-79.jpg,90
> days,,CPL,STD,1.25 ,F,SMA,,,50 ,21,22,30,20,20 dB,3.5 ,4.5
> ,,,,,X,X,X,X,,098.pdf,T3'
> Vend::Table::DBI:debug: bind_entire_row=[
> bless( [
> {
> 'ALTER_CHANGE' => 'ALTER TABLE _TABLE_ CHANGE COLUMN _COLUMN_
> _COLUMN_ _DEF_',
> 'PASS' => 'YYYYYY',
> 'SEQUENCE_KEY' => 'INT PRIMARY KEY AUTO_INCREMENT',
> 'DIR' => '/mv_catalogs/mmb2c/products',
> 'file' => 'products.txt',
> 'DELIMITER' => ' ',
> 'ALTER_ADD' => 'ALTER TABLE _TABLE_ ADD COLUMN _COLUMN_ _DEF_',
> 'COLUMN_INDEX' => {
> 'delivery' => 26,
> 'inactive' => 22,
> 'oldsku' => 27,
> 'thumb' => 5,
> 'stdcatpage' => 48,
> 'power' => 35,
> 'genders' => 31,
> 'url' => 23,
> 'weight' => 13,
> 'category' => 10,
> 'wholesale' => 8,
> 'wirecatpage' => 47,
> 'image_large' => 25,
> 'cable' => 34,
> 'xfersku' => 41,
> 'sale_price' => 24,
> 'description' => 1,
> 'allow_uk' => 44,
> 'tier' => 49,
> 'related' => 17,
> 'security' => 42,
> 'vswr' => 30,
> 'price' => 7,
> 'title' => 2,
> 'dl_type' => 20,
> 'download' => 19,
> 'sku' => 0,
> 'contact' => 33,
> 'size' => 14,
> 'body' => 29,
> 'color' => 15,
> 'featured' => 18,
> 'interfaces' => 32,
> 'phase' => 39,
> 'freqmax' => 38,
> 'dl_location' => 21,
> 'freqmin' => 37,
> 'dbranges' => 36,
> 'gift_cert' => 16,
> 'prod_group' => 9,
> 'image' => 6,
> 'length' => 40,
> 'comment' => 4,
> 'allow_us' => 43,
> 'template_page' => 3,
> 'allow_disty' => 46,
> 'nontaxable' => 12,
> 'allow_intl' => 45,
> 'tax_category' => 11,
> 'prefix' => 28
> },
> 'INDEX' => [
> 'title',
> 'price',
> 'prod_group',
> 'category',
> 'allow_us',
> 'allow_uk',
> 'allow_intl',
> 'allow_disty'
> ],
> 'ALTER_DELETE' => 'ALTER TABLE _TABLE_ DROP _COLUMN_',
> '_Checked_capability' => 1,
> 'COLUMN_DEF' => {
> 'delivery' => 'VARCHAR(32)',
> 'inactive' => 'VARCHAR(3)',
> 'oldsku' => 'VARCHAR(18)',
> 'thumb' => 'VARCHAR(64)',
> 'stdcatpage' => 'VARCHAR(8)',
> 'power' => 'decimal(5,1)',
> 'genders' => 'VARCHAR(8)',
> 'url' => 'VARCHAR(128)',
> 'weight' => 'VARCHAR(12)',
> 'category' => 'VARCHAR(64) DEFAULT \'\'',
> 'wholesale' => 'DECIMAL(12,2)',
> 'wirecatpage' => 'VARCHAR(8)',
> 'image_large' => 'VARCHAR(64)',
> 'cable' => 'VARCHAR(128)',
> 'sale_price' => 'DECIMAL(12,2)',
> 'description' => 'VARCHAR(128) DEFAULT \'\'',
> 'allow_uk' => 'VARCHAR(1)',
> 'tier' => 'VARCHAR(4)',
> 'related' => 'text',
> 'security' => 'VARCHAR(4)',
> 'vswr' => 'VARCHAR(4)',
> 'price' => 'DECIMAL(12,2) NOT NULL',
> 'title' => 'VARCHAR(128) DEFAULT \'\'',
> 'dl_type' => 'VARCHAR(8)',
> 'download' => 'VARCHAR(64)',
> 'sku' => 'char(64) NOT NULL PRIMARY KEY',
> 'contact' => 'VARCHAR(8)',
> 'size' => 'VARCHAR(96)',
> 'body' => 'VARCHAR(8)',
> 'color' => 'VARCHAR(96)',
> 'featured' => 'VARCHAR(32)',
> 'interfaces' => 'VARCHAR(16)',
> 'xrefsku' => 'VARCHAR(128)',
> 'phase' => 'char(4)',
> 'freqmax' => 'decimal(8,2)',
> 'dl_location' => 'VARCHAR(64)',
> 'freqmin' => 'decimal(8,2)',
> 'dbranges' => 'VARCHAR(8)',
> 'gift_cert' => 'VARCHAR(3)',
> 'prod_group' => 'VARCHAR(64) DEFAULT \'\'',
> 'image' => 'VARCHAR(64)',
> 'length' => 'VARCHAR(8)',
> 'comment' => 'TEXT',
> 'allow_us' => 'VARCHAR(1)',
> 'template_page' => 'VARCHAR(64)',
> 'allow_disty' => 'VARCHAR(1)',
> 'nontaxable' => 'CHAR(3)',
> 'allow_intl' => 'VARCHAR(1)',
> 'tax_category' => 'VARCHAR(64)',
> 'prefix' => 'VARCHAR(8)'
> },
> 'included_from' => 'dbconf/mysql/products.mysql',
> 'EXTENDED' => '',
> 'delimiter' => ' ',
> 'db_file_extended' => '/mv_catalogs/mmb2c/products/products.sql',
> 'USER' => 'XXXXXX',
> 'ALTER_INDEX' => 'CREATE _UNIQUE_ INDEX $TABLE$_$COLUMN$ ON
> _TABLE_ (_COLUMN_)',
> 'KEY_INDEX' => 0,
> 'KEY' => 'sku',
> 'NAME' => [
> 'sku',
> 'description',
> 'title',
> 'template_page',
> 'comment',
> 'thumb',
> 'image',
> 'price',
> 'wholesale',
> 'prod_group',
> 'category',
> 'tax_category',
> 'nontaxable',
> 'weight',
> 'size',
> 'color',
> 'gift_cert',
> 'related',
> 'featured',
> 'download',
> 'dl_type',
> 'dl_location',
> 'inactive',
> 'url',
> 'sale_price',
> 'image_large',
> 'delivery',
> 'oldsku',
> 'prefix',
> 'body',
> 'vswr',
> 'genders',
> 'interfaces',
> 'contact',
> 'cable',
> 'power',
> 'dbranges',
> 'freqmin',
> 'freqmax',
> 'phase',
> 'length',
> 'xfersku',
> 'security',
> 'allow_us',
> 'allow_uk',
> 'allow_intl',
> 'allow_disty',
> 'wirecatpage',
> 'stdcatpage',
> 'tier'
> ],
> '_Numeric_ary' => [
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> 4,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> 4,
> undef,
> 4,
> 4,
> 4,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef,
> undef
> ],
> 'DSN' => 'dbi:mysql:mmb2c',
> 'NUMERIC' => {
> 'phase' => undef,
> 'freqmin' => undef,
> 'power' => undef,
> 'freqmax' => undef,
> 'price' => undef
> },
> 'name' => 'products',
> '_Insert_h' => bless( {}, 'DBI::st' ),
> 'SEQUENCE_LAST_FUNCTION' => 'select last_insert_id()',
> 'HAS_LIMIT' => 1,
> 'Clean_start' => 1,
> 'Class' => 'DBI',
> 'type' => 8,
> '_Auto_number' => undef,
> 'ObjectType' => 'Vend::Table::DBI'
> },
> 'products',
> 'sku',
> [
> 'sku',
> 'description',
> 'title',
> 'template_page',
> 'comment',
> 'thumb',
> 'image',
> 'price',
> 'wholesale',
> 'prod_group',
> 'category',
> 'tax_category',
> 'nontaxable',
> 'weight',
> 'size',
> 'color',
> 'gift_cert',
> 'related',
> 'featured',
> 'download',
> 'dl_type',
> 'dl_location',
> 'inactive',
> 'url',
> 'sale_price',
> 'image_large',
> 'delivery',
> 'oldsku',
> 'prefix',
> 'body',
> 'vswr',
> 'genders',
> 'interfaces',
> 'contact',
> 'cable',
> 'power',
> 'dbranges',
> 'freqmin',
> 'freqmax',
> 'phase',
> 'length',
> 'xfersku',
> 'security',
> 'allow_us',
> 'allow_uk',
> 'allow_intl',
> 'allow_disty',
> 'wirecatpage',
> 'stdcatpage',
> 'tier'
> ],
> undef,
> bless( {}, 'DBI::db' )
> ], 'Vend::Table::DBI' ),
> bless( {}, 'DBI::st' ),
> undef,
> 'CPL-5027-5P-SMA-79',
> '5 Port Multi-Coupler',
> '21,22,30,20,20 dB 3.5-4.5 Ghz 5 Port Multi-Coupler Female SMA 50
> watt Painted
> ',
> '',
> '',
> 'CPL-5212-06-TNC-79_icon.jpg',
> 'CPL-5212-06-TNC-79_small.jpg',
> '1161.30 ',
> '',
> 'Couplers',
> 'Special Multi-Couplers & Monitor Couplers',
> '',
> '',
> '',
> '',
> 'Painted',
> '',
> '',
> '',
> '',
> '',
> '',
> '',
> '',
> '',
> 'CPL-5212-06-TNC-79.jpg',
> '90 days',
> '',
> 'CPL',
> 'STD',
> '1.25 ',
> 'F',
> 'SMA',
> '',
> '',
> '50 ',
> '21,22,30,20,20 dB',
> '3.5 ',
> '4.5 ',
> '',
> '',
> '',
> '',
> 'X',
> 'X',
> 'X',
> 'X',
> '',
> '098.pdf',
> 'T3'
> ]
>
> Vend::Table::DBI:debug: bind_entire_row=[
> 'CPL-5027-5P-SMA-79',
> '5 Port Multi-Coupler',
> '21,22,30,20,20 dB 3.5-4.5 Ghz 5 Port Multi-Coupler Female SMA 50
> watt Painted
> ',
> '',
> '',
> 'CPL-5212-06-TNC-79_icon.jpg',
> 'CPL-5212-06-TNC-79_small.jpg',
> '1161.30 ',
> '',
> 'Couplers',
> 'Special Multi-Couplers & Monitor Couplers',
> '',
> '',
> '',
> '',
> 'Painted',
> '',
> '',
> '',
> '',
> '',
> '',
> '',
> '',
> '',
> 'CPL-5212-06-TNC-79.jpg',
> '90 days',
> '',
> 'CPL',
> 'STD',
> '1.25 ',
> 'F',
> 'SMA',
> '',
> '',
> '50 ',
> '21,22,30,20,20 dB',
> '3.5 ',
> '4.5 ',
> '',
> '',
> '',
> '',
> 'X',
> 'X',
> 'X',
> 'X',
> '',
> '098.pdf',
> 'T3'
> ]
>
> Vend::Table::DBI:debug: bind 1=CPL-5027-5P-SMA-79
> Vend::Table::DBI:debug: bind 2=5 Port Multi-Coupler
> Vend::Table::DBI:debug: bind 3=21,22,30,20,20 dB 3.5-4.5 Ghz 5 Port
> Multi-Couple
> r Female SMA 50 watt Painted
> Vend::Table::DBI:debug: bind 4=
> Vend::Table::DBI:debug: bind 5=
> Vend::Table::DBI:debug: bind 6=CPL-5212-06-TNC-79_icon.jpg
> Vend::Table::DBI:debug: bind 7=CPL-5212-06-TNC-79_small.jpg
> Vend::Table::DBI:debug: bind 8=1161.30
> Vend::Table::DBI:debug: bind 9=
> Vend::Table::DBI:debug: bind 10=Couplers
> Vend::Table::DBI:debug: bind 11=Special Multi-Couplers & Monitor Couplers
> Vend::Table::DBI:debug: bind 12=
> Vend::Table::DBI:debug: bind 13=
> Vend::Table::DBI:debug: bind 14=
> Vend::Table::DBI:debug: bind 15=
> Vend::Table::DBI:debug: bind 16=Painted
> Vend::Table::DBI:debug: bind 17=
> Vend::Table::DBI:debug: bind 18=
> Vend::Table::DBI:debug: bind 19=
> Vend::Table::DBI:debug: bind 20=
> Vend::Table::DBI:debug: bind 21=
> Vend::Table::DBI:debug: bind 22=
> Vend::Table::DBI:debug: bind 23=
> Vend::Table::DBI:debug: bind 24=
> Vend::Table::DBI:debug: bind 25=
> Vend::Table::DBI:debug: bind 26=CPL-5212-06-TNC-79.jpg
> Vend::Table::DBI:debug: bind 27=90 days
> Vend::Table::DBI:debug: bind 28=
> Vend::Table::DBI:debug: bind 29=CPL
> Vend::Table::DBI:debug: bind 30=STD
> Vend::Table::DBI:debug: bind 31=1.25
> Vend::Table::DBI:debug: bind 32=F
> Vend::Table::DBI:debug: bind 33=SMA
> Vend::Table::DBI:debug: bind 34=
> Vend::Table::DBI:debug: bind 35=
> Vend::Table::DBI:debug: bind 36=50
> Vend::Table::DBI:debug: bind 37=21,22,30,20,20 dB
> Vend::Table::DBI:debug: bind 38=3.5
> Vend::Table::DBI:debug: bind 39=4.5
> Vend::Table::DBI:debug: bind 40=
> Vend::Table::DBI:debug: bind 41=
> Vend::Table::DBI:debug: bind 42=
> Vend::Table::DBI:debug: bind 43=
> Vend::Table::DBI:debug: bind 44=X
> Vend::Table::DBI:debug: bind 45=X
> Vend::Table::DBI:debug: bind 46=X
> Vend::Table::DBI:debug: bind 47=X
> Vend::Table::DBI:debug: bind 48=
> Vend::Table::DBI:debug: bind 49=098.pdf
> Vend::Table::DBI:debug: bind 50=T3
> Vend::Table::DBI:debug: last bind 51=
> table 'products' failed: products import failed: You have an error in
> your SQL syntax near ' '', '', '', 'X', 'X', 'X', 'X', '', '098.pdf',
> 'T3')' at line 1
>
> mmb2c config error: products not a database, cannot use as products file
>
>
> mmb2c: error in configuration. Skipping.
> mmb2c: config error. Skipping.
> Interchange server started in INET and UNIX mode(s) (process id 22732)
>
> [root@mml2 mmb2c]# /etc/init.d/interchange stop
> $Stopping interchange: [ OK ]
> [root@mml2 mmb2c]#
>
> BTW, It does appear that the 4.8.5 ICDATABASE docs are sorely out of
> date... While I'm hoping that IC Hoss's can see the problem through
> this debug, does anyone have a summary tech spec on the .mysql files
> that discusses the various database definitions? For example, I see
> CHAR and VARCHAR but haven't a clue as to the difference just as I've
> seen Decimal(x,y) but haven't found if the x,y combination is handled
> like the old Fortran style where the decimal is counted, or not, and
> what the difference between a DECIMAL(4,0) versus just an INT
> regarding performance, format, query hits (ie 3.999 vs 4), etc...
> Also, with numerical definitions, is the manual 'NUMERIC' really
> needed then? These are pretty basic questions that I simply have not
> found answers to in the 4.8.5 docset...
>
> Thanks again!
>
> Barry
>
--
Barry Treahy, Jr * Midwest Microwave * Vice President & CIO
E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028