[mv] SQL Problem..

["Eran Binyamin Zeitoun" <eran_zeitoun@karmail.com>]

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

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