Re: [mv] SQL Query not Working

[jojo@buchonline.net]

******    message to minivend-users from jojo@buchonline.net     ******

On  9 Aug, Warren Tokujo wrote:
> ******    message to minivend-users from Warren Tokujo <warren@papaya.islandwebstar.com>     ******
> 
> Hi all,
> 
> I've installed Minivend 4.03 on Linux 6.0 and have basically the simple
> catalog using the default database running okay on it.  But do have
> problems getting any of the SQL Query commands to work.  They are of the
> form:
> 
> [query sql="select * from products"][/query]
> 
> Very basic, but this command returns nothing.  I'm assuming that it
> should return all the records in the product.txt database.
> 
> To add to that,  I also have a problem getting the Order Status to work
> in Minimate.  It always say "No pending orders for <whatever user>" even
> when I create a pending order situation- order is in the basket, but not
> yet checked out.. I checked into the check_orders.html, and found that
> it uses an SQL Query  in there as well.  Slightly different and it looks
> like
> 
> [query st=db arrayref=orders
>   sql="SELECT
> 
> code,status,nitems,subtotal,shipping,handling,total_cost,payment_method,order_date
> 
>    FROM transactions
>    WHERE username = '[data base=session field=username filter=sql]'
>    ORDER by code
>   "][/query]
> 
> So I'm thinking that the problems are related.  I cannot seem to run SQL
> Queries.  I have not check all of the pages for other SQL Queries, but
> it does seem curious that I am having problems with the basic command
> and a page which uses it.
> 
> My suspicion now is that for some reason, I do not have support for SQL
> Query commands.  Could there be support module that I may have missed
> during the installation? Or is there a module that needs to be installed
> to support SQL queries? Or am I off-base and just not using it right?
> 
> Any assistance or pointers would be appreciated.  Thanks in advance.
> 
> Warren

Watch the error.log _and_ die log file of your SQL program.

Joachim

-- 
Hans-Joachim Leidinger
buch online                 jojo@buchonline.net
Munscheidstr. 14            FAX: +49 209 1671449
45886 Gelsenkirchen         FAX: 0209 1671449

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list