[ic] A cry for help...

[Andrew McBeath]

Ok guys,  heres a curly one:

I just moved a new catalog off our dev server onto the production
server.  URL changes aside, everything dropped perfectly into place and
seemed to run fine.  However, one bug has surfaced... when trying to
edit items with the admin (submitting item_edit.html), it throws the
following error:

Sorry, there was an error in processing this form action. Please
report the error or try again later.
(DBD::Pg::st execute failed: ERROR:  parse error at or near "(" at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 986.)

No error is posted in the error logs, but I have turned on debugging and
put some debug statements in DBI.pm.  These produce the debug log below.

As this does not occur on the dev server, I tried copying
/usr/local/interchange from the dev server on to the production server.
Still no dice...

So to sum up, I have copied:
/usr/local/interchange,  /var/lib/interchange, and the database.

It works on one machine, but not the other.
Other details are the same for both machines:
Interchange 4.8.3, Postgresql 7.2.1, Perl 5.6.0, Apache 1.3.26...

The one thing I can see may be different is the perl DBD::Pg.pm module,
as that is the one common thing which has not been copied... but on
inspection they are the same versions and appear the same.

Any ideas?  I'm fast approaching a deadend... :-(

-----DEBUG OUTPUT------
NOTE: the embedded backslashes are from being copy/pasted from emacs
-----------------------

Vend::Table::DBI:debug: tkey now '4401-340009'
Vend::Table::DBI:debug: set_slice query: update products SET 
freight=?,prod_group=?,calcfob=?,option2title=?,techni\caldetails=?,option2value=?,calcfis=?,category=?,subcategory=?,thumb=?,nontaxable=?,brochure=?,comment=?,fob=?,calc\warranty=?,calcduty=?,description=?,disc=?,margin=?,option1title=?,prod_currency=?,image=?,option1value=?,supplier_\no=?,notes=?,price=?,warranty=?,calcfinance=?,option3title=?,weight=?,option3value=?,finance=?,supplier=?,calcfreig\ht=?,duty=? 
WHERE sku = '4401-340009'
Vend::Table::DBI:debug: set_slice key/fields/values:
key=4401-340009
[
   'freight',
   'prod_group',
   'calcfob',
   'option2title',
   'technicaldetails',
   'option2value',
   'calcfis',
   'category',
   'subcategory',
   'thumb',
   'nontaxable',
   'brochure',
   'comment',
   'fob',
   'calcwarranty',
   'calcduty',
   'description',
   'disc',
   'margin',
   'option1title',
   'prod_currency',
   'image',
   'option1value',
   'supplier_no',
   'notes',
   'price',
   'warranty',
   'calcfinance',
   'option3title',
   'weight',
   'option3value',
   'finance',
   'supplier',
   'calcfreight',
   'duty'
]
[
   '30.000000',
   'X-Ray Acessories 
                                             \                ',
   undef,
   'Size (cms)',
   'X-ray protection gloves made of very supple and flexible material 
with a coating kind to the skin. Because they \are manufactured without 
seams, they offer perfect radiation protection all round.<br><br>^M^M
The slightly curved shape of the fingers increases the freedom of 
movement, the cut also makes them easy to put on \and take off. The 
length of the gloves also provides radiation protection to a large part 
of the lower arm. The rol\led edge on the glove shaft prevents tearing.',
   '90Lx60W',
   undef,
   'Protective Clothing',
   'Double Sided:Shoulder Clip',
   'photo1.gif',
   undef,
   undef,
   'X-ray protection gloves made of very supple and flexible material 
with a coating kind to the skin. Because they \are manufactured without 
seams, they offer perfect radiation protection all round.<br><br>^M^M
The slightly curved shape of the fingers increases the freedom of 
movement, the cut also makes them easy to put on \and take off. The 
length of the gloves also provides radiation protection to a large part 
of the lower arm. The rol\led edge on the glove shaft prevents tearing.',
   '171.000000',
   undef,
   undef,
   'Double sided shoulder clip',
   '40.000000',
   '30.000000',
   'Length (mm)',
   'GBP',
   'photo1.gif',
   '0.50LE',
   'SC590',
   'testsa',
   undef,
   '2.500000',
   undef,
   undef,
   '0.1',
   undef,
   '1.830000',
   '',
   undef,
   '0.000000'
]

Vend::Table::DBI:debug: set_slice execute: 30.000000 X-Ray Acessories 
                                            \ 
                                          Size (cms) X-ray protection 
gloves made of very\ supple and flexible material with a coating kind to 
the skin. Because they are manufactured without seams, they of\fer 
perfect radiation protection all round.<br><br>^M^M
The slightly curved shape of the fingers increases the freedom of 
movement, the cut also makes them easy to put on \and take off. The 
length of the gloves also provides radiation protection to a large part 
of the lower arm. The rol\led edge on the glove shaft prevents tearing. 
90Lx60W  Protective Clothing Double Sided:Shoulder Clip photo1.gif 
\X-ray protection gloves made of very supple and flexible material with 
a coating kind to the skin. Because they are\ manufactured without 
seams, they offer perfect radiation protection all round.<br><br>^M^M
The slightly curved shape of the fingers increases the freedom of 
movement, the cut also makes them easy to put on \and take off. The 
length of the gloves also provides radiation protection to a large part 
of the lower arm. The rol\led edge on the glove shaft prevents tearing. 
171.000000   Double sided shoulder clip 40.000000 30.000000 Length (m\m) 
GBP photo1.gif 0.50LE SC590 testsa  2.500000   0.1  1.830000   0.000000

Bareword found where operator expected at (eval 784) line 1, near "q{}  new"
Bareword found where operator expected at (eval 786) line 1, near "q{} 
exchange"

------END DEBUG------




-- 
Andrew McBeath
System Admin / Senior Developer
Zeald Ltd
ICQ: 53879543
Ph: +64 9 4157575
Mob: +64 21 434104

-------
Maybe in order to understand mankind, we have to look at the
word itself: "Mankind".
Basically, it's made up of two separate words - "mank" and "ind".

What do these words mean?
It's a mystery, and that's why so is mankind.

Jack Handy
-------