>>>> Hillary Corney wrote:
>>>>>>>>> Hi all,
>>>>>> Debian Woody non-threaded perl
>>>>>> When I upgraded from 4.8 to 5.2 I lost all the options in the
>>> product Items list even the options column disappeared.
>>>>>> Tying to recover the situation is proving very frustrating :-(
>>>>>> I have searched the FAQ's and this list without finding any
>>> useful info except that I was using the Admin UI as intended.
>>>>>> The options TAB brings up a menu which has radio buttons for
>>>>>> None
>>> Matrix
>>> old 4.8 options
>>> simple
>>>>>> Update
>>>>>> selecting any of these buttons and clicking update has no effect
>>> the form blinks and reappears with the same radio buttons with
>>> "None" selected
>>>>>> There are no errors in any of the the logs at all,
>>>>>> The only thing that has happened is the options column has
>>> appeared in the items list with every option for every item set
>>> at none and clicking it brings you back to the failing options
>>> update page.
>>>>>> Can anyone suggest what I should look for as I cannot see where
>>> the problem lies.
>>>>>>>>>>> I have similar problems, reported in this list some 4 weeks ago. I
>> have not managed to fix the problem, and eventually in desperation
>> reworked my site not to use options. I likewise got no errors in
>> any log. I'm pleased to see someone else getting the same problem,
>> as I thought I was going mad.
>>>> I too would welcome suggestions.
>>>> Nigel
>> _______________________________________________
>> interchange-users mailing list
>>interchange-users at icdevgroup.org>>http://www.icdevgroup.org/mailman/listinfo/interchange-users>>>>>>>> _______________________________________________
> interchange-users mailing list
>interchange-users at icdevgroup.org>http://www.icdevgroup.org/mailman/listinfo/interchange-users>>
>
On 2 Nov 2005, at 10:50 pm, Hillary Corney wrote:
> Hi Nigel,
>> Sorry you are having problems too. I have at least at last managed
> to get an error message which might help point someone better at
> SQL than me in the right direction:
>> table options: set_slice error as called by Vend::Interpolate:
> DBD::mysql::st execute failed: You have an error in your SQL syntax
> near 'WHERE code = '00025'' at line 1 at /usr/local/interchange/lib/
> Vend/Table/DBI.pm line 1251. query was:update options SET WHERE
> code = '00025' values were:''
>> This appeared in the browser when attempting to click the radio
> button to insert an option into a new item on a new catalog.
> Interestingly the option to use old 4.8 options did not appear in
> the radio buttons list so something was detecting the fact that
> this catalog was new.
>> I am now looking at /usr/local/interchange/lib/Vend/Table/DBI.pm
> line 1251 for clues as unfortunately options are an essential part
> of this catalog as is a working Admin UI
>> Cheers
>> Hillary
>>> On 2 Nov 2005, at 9:06 pm, Nigel Titley wrote:
HI Again Nigel,
I uncommented the debug comments either side of the block of perl in /
usr/local/interchange/lib/Vend/Table/DBI.pm around line 1251 and got
the following error log entry can anyone help to decipher where the
problems lie now?
> query was:update options SET WHERE code = '00025'
> values were:''
82.69.222.70 YLKTNCt6:82.69.222.70 - [02/November/2005:23:17:27
+0000] ng /cgi-bin/ng/admin/item_option_old.html bad field o_modular
in record update, value=1
82.69.222.70 YLKTNCt6:82.69.222.70 - [02/November/2005:23:17:27
+0000] ng /cgi-bin/ng/admin/item_option_old.html bad field o_master
in record update, value=1
82.69.222.70 YLKTNCt6:82.69.222.70 - [02/November/2005:23:17:27
+0000] ng /cgi-bin/ng/admin/item_option_old.html bad field o_enable
in record update, value=1
82.69.222.70 YLKTNCt6:82.69.222.70 - [02/November/2005:23:17:27
+0000] ng /cgi-bin/ng/admin/item_option_old.html bad field o_matrix
in record update, value=0
82.69.222.70 YLKTNCt6:82.69.222.70 - [02/November/2005:23:17:27
+0000] ng /cgi-bin/ng/admin/item_option_old.html set_slice error as
called by Vend::Interpolate: DBD::mysql::st execute failed: You have
an error in your SQL syntax near 'WHERE code = '00025'' at line 1 at /
usr/local/interchange/lib/Vend/Table/DBI.pm line 1251.
>
Cheers and Thanks
Hillary