Re: [mv] MV 4: Some notes on successfully setting up some SQL tables in MV 4.

["Bill Randle" <billr@exgate.tek.com>]

******    message to minivend-users from "Bill Randle" <billr@exgate.tek.com>     ******


Another search problem that could use some better error indication
is the error you get when attempting to search the userdb.

I have some code that searches the userdb for a userid and password,
given some set of unique information such as firt/last name, email
address, zip code, etc. [You should recognize that, Mike. :-)]

My problem was that starting around MV4.0Alpha11 it stopped working.
The error message displayed on the browser was:

	Sorry, there was an error in processing this form action.
	Please report the error or try again later.

There were no error messages in the error.log file to clarify the
problem. After trying various things, I spent quite awhile tracing
the search thru the mvend code. It turns out that the piece of code
that got me was (in _file_security() in Scan.pm):

	$ok &&= $_ !~ /$Vend::Cfg->{NoSearch}/
            if $Vend::Cfg->{NoSearch};

which checks to see if searches are allowed on a particular db. The
default configuration in Config.pm sets {NoSearch} to 'userdb'. This
may have been mentioned in the latest docs or release notes and I
just missed it. In any event, it would be useful to have an error
message printed somewhere saying something to effect that this
database is not searchable.

My solution (there may be better ones) was to add:

	NoSearch	''

to my catalog.cfg file and restart minivend. Works fine now.

	-Bill Randle
	billr@exgate.tek.com
-
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