Re: [mv] SQL Problem..

[Hans-Joachim Leidinger <jojo@buchonline.net>]

******    message to minivend-users from Hans-Joachim Leidinger <jojo@buchonline.net>     ******

Eran Binyamin Zeitoun schrieb:
> 
> ******    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]

Maybe this

# Not needed unless your database requires a login
#Database            products USER   you
#Database            products PASS   XXXXXX
                              ^^^^

Any informations in your error.log? In your SQL-Log file?

Regards,

	Joachim
-- 
-------------Hans-Joachim Leidinger---------------------

-
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