MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

Why does MiniVend sometimes not find the database ?



Hello,
	I've hit a stone wall again.  Does where or how you access certain
MiniVend pages  or is there certain code that forces it to look for a database
besides the product database in ...../products ?

	Reason being,  I have SQL databases set up.  All the SQL databases are
in the Postgres directory and not the MiniVend .../products/ directory.  I have
had NO problem accessing the products database/table.  There are additional
tables that are not product tables  One is set up for links.  No problem.   I
can display links on a results page from a search.  There is a temp links table
set up for people to add their own link.   After we check it out it will be
added to the main links table.   I can write to this temp database from
MiniVend with no problem using the form entry code

	Here is the problem.  I have another table for product reviews.  I
added a "Reviews" button to the index page.  This button is a one click scan
SQL search.  Each item on the index page has this button.  I have it displaying
all review text files for that product when this button is clicked.  I'm using a
modified results page for this display. That part works.  Now I want to add a
section to allow someone to add their own review.  I have the form code set up
like I did with the links entry however when I click on the "Set" for submit, I
get an error message that it can't find the table in ..../products/.   I know
it's not in .../products/.   None of SQL databases are in the ..../products/
directory.  In fact the code above the form code reads from this table just
fine.  It finds it then when I use an [sql type=list..........].   

	So why does it find tables sometimes and other times it doesn't ?  What
am I doing wrong ?  Any help will be appreciated.  I will check the archieves
again but so far I've missed it if it's there.

I've got
MV 3.14-3
Postgres 6.5.1
DBD 0.92
DBI 1.13

Thanks
Karl





Search for: Match: Format: Sort by: