Re: [mv] SQL Problem..

[Art <asl@bacolod.worldtelphil.com>]

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