[ic] Loading of SQL table failing
Barry Treahy, Jr.
interchange-users@icdevgroup.org
Sun Sep 15 16:59:00 2002
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.
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