Forum OpenACS Q&A: Re: Too stupid to work this out for myself!

Collapse
Posted by Robert Locke on
Hi Richard,

You should also copy the product*.xql files to corresponding me_product*.xql files.

Your new version of product.tcl could not find the proper queries and, as such, was executing the default query within the db_0or1row.  This query is Oracle-specific and I assume you're using Postgres given the ns_pg call in your log snippet.

This is one reason why queries should be separated out into *.xql files and not included within the db_* calls.

Hope this helps...