[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Checkout generates "query was: 7" error after Minivend to Interchange migration
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