[ic] Checkout generates "query was: 7" error after Minivend to Interchange migration

[interchange-users@icdevgroup.org]

On Mon, Nov 18, 2002 at 11:58:33AM -0800, Scott B. Gale wrote:
> Hello Mark,
> 
> I came across a posting of yours to the interchange-users mail list from
> a couple of years ago.  You were having exactly the same problem then as I
> am having today with "query was: 7" messages being generated when loading
> checkout.html.  Typically, three related lines are produced 7 times on
> each page load.  It not only fills up log files but all those failed
> queries create quite a performance hit too I'm sure.  I too am migrating a
> Minivend store to Interchange.  
> 
> [snip]
> 
> On my page multi/checkout.html, I started getting internal server errors
> with this in the error logs when I submit the page:
> 
> ######################################
> 208.196.32.195 w9TYiy8o:nobody - [19/September/2000:19:54:38 -0500] ssp
> /~softskul/cgi-bin/ssp.cgi/process.html Bad SQL statement: Parse error
> near 7 at /usr/local/mvend/lib/Vend/Scan.pm line 579.
> >
> > Query was: 7.

The layout for scan urls changed.  What was it, scan/ now is supposed
to be scan asdf?  (I THINK).  Look for that in docs.  I'm pretty sure
it was in changelog somewhere.

You are getting 7 because an array is being converted to scalar context.
Add some debugging to the logGlobal function to convert that otherwise
you'll find it hard to trace back.



> >
> 208.196.32.195 w9TYiy8o:nobody - [19/September/2000:19:54:38 -0500] ssp
> /~softskul/cgi-bin/ssp.cgi/process.html Bad SQL, query was: 7
> 208.196.32.195 w9TYiy8o:nobody - [19/September/2000:19:54:38 -0500] ssp 
> /cgi-bin/ssp.cgi/process.html Runtime error: Can't use an undefined
> value as an ARRAY reference at /usr/local/mvend/lib/Vend/Interpolate.pm
> line 4774.
> >
> ######################
> 
> I looked through the source code at these lines, as well as analyzing
> the code on the page, and I could not figure this out. Does anyone know
> what possible causes for this are? Whatever I was doing was valid with
> MV 4.04. :) 
> 
> [snip]
> 
> Thanks!
> 
>   -mark
> 
> personal website             }      Summersault Website Development
> http://mark.stosberg.com/    {      http://www.summersault.com/
> 
> [/quote from past posting]
> 
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
> 

-- 

Christopher F. Miller, Publisher                               cfm@maine.com
MaineStreet Communications, Inc           208 Portland Road, Gray, ME  04039
1.207.657.5078                                         http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux