[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
RE: [mv] SQL Problem..
****** message to minivend-users from "Eran Binyamin Zeitoun" <eran_zeitoun@karmail.com> ******
Hi...
Well i forgot to mention but no errors on logs....,
But Artuhur's answer solved the problem....
the question is, is there any special modifcation i need to do on other
minivend tags to support SQL?...
I know MV4 is SQL friendly..., and i bet that my next project will be on
MV4... but currently i need to finish a 3.14 site...
Thanks for the answers,
Eran.
-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Art
Sent: Sunday, March 19, 2000 3:36 PM
To: minivend-users@minivend.com
Subject: Re: [mv] SQL Problem..
****** message to minivend-users from Art <asl@bacolod.worldtelphil.com>
******
Eran Binyamin Zeitoun wrote:
>
> ****** message to minivend-users from "Eran Binyamin Zeitoun"
<eran_zeitoun@karmail.com> ******
>
> Hi....
>
> I recently moved my test store to work sith SQL... installtion went almost
> smooth...
> i had some problems i had to solve my self since no one answered here...
but
> now the system
> works great... But... (there is always but...)
>
> Whenever i am searching for a product or just simply whant to display the
> products
> with results.html... i get an empty list..., when i am checking the SQL
> table its with
> all the products....
>
> My products.asc does not contains any record beside the table headers...,
i
> assume that the
> search do the search in products.asc and does not found there a thing and
> return nada to me.
>
> As readed in the couments nothing should be changed in the search string
for
> any type of
> database..., anyone have any idea?
Try specifying your search type as sql: HREF="[area scan st=sql
se=Renaissance ..... ]"
Check results.html too, maybe you'll need to change a few things
there...
I'm currently running the Simple store of MV 4.0 with the products in an
mSQL database and 4.0 is I think more SQL-friendly than MV 3.x; just
read the WHATSNEW of 4.x and you'll surely be impressed...
Arthur Lluisma
>
> this is happening only with products.asc file since when logging to the
> system it founds the
> user and the password correct (which those resides inside the userdb sql
> table...)
>
> I included here the catalog.cfg database settings...
> ####################DATABASES
> DECLERATIONS############################################
> Database products products.asc
> dbi:mysql:estore:212.143.86.234:3306
> Database transactions transactions.asc
> dbi:mysql:estore:212.143.86.234:3306
> Database userdb userdb.asc
> dbi:mysql:estore:212.143.86.234:3306
> Database pricing pricing.asc
> dbi:mysql:estore:212.143.86.234:3306
> Database groups groups.asc
> dbi:mysql:estore:212.143.86.234:3306
> ####################DATABASES
> DECLERATIONS############################################
> NoImport products transactions userdb pricing groups
> ####################DATABASES
> DECLERATIONS############################################
> Database products USER root
> Database transactions USER root
> Database groups USER root
> Database userdb USER root
> Database pricing USER root
>
> am i missing somthing ?
> Please try to help guys...
> [i am using mv3.14.5]
>
> Thanks in advance,
> Eran Binyamin Zeitoun.
>
> -
> 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
-
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
