Re: [mv] SQL Query not Working

[Warren Tokujo <warren@papaya.islandwebstar.com>]

******    message to minivend-users from Warren Tokujo <warren@papaya.islandwebstar.com>     ******

Hi all again,

Joachim, Racke, thanks for responding.

I couldn't find the die log file.  I do not have an SQL database installed, but according to the
documentation, I should be able to do basic SQL statements on the Minivend's native databases.

The error.log in the catalogs directory records the following when I select the Order Status in Minimate:

.../query/check_orders.html Bad SQL, query was: SELECT
                                            code, status, nitems, subtotal, shipping, total_cost,
payment_method, order_date
                                            From transactions
                                            Where username = 'test'
                                            ORDER by code

Now, I also reviewed the installation procedure under "What else do I need to run Minivend?", and it says
that there are extra modules that need to be loaded to use some of  Minimate features.  These are modules
that should've been downloaded from CPAN and installed during the initial installation using ppm.pl, the
ActivePerl package Manager.  Unfortunately, I do recall that I either skipped this portion or it did not
load properly.  Specifically, " perl -MCPAN -e 'install Bundle::Minivend' " failed.  Also, I do not
believe, the following modules have been loaded:

Digest::MD5
MIME::Base64
SQL::Statement
URI:URL
Safe::Hole

The one that sticks out is this "SQL::Statement".  If this module is not installed would it prevent SQL
statements to work on say the "products.txt" datafile?  ( I understand that I may also be using the Query
statement incorrectly) If yes, this  may  in part  be the problem.  A definitive answer would be helpful.

Thanks,

Warren

jojo@buchonline.net wrote:

> ******    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



-
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