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

[Hillary Corney <suppressed>]

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
> suppressed
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users