[ic] Items Options update in Admin UI fails silently - new error message

[Hillary Corney]

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:

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