[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] SQL question
****** message to minivend-users from "Christian J. =?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch> ******
Brian Hanley wrote:
>
> ****** message to minivend-users from "Brian Hanley" <hanley@parrett.net> ******
>
> List:
>
> I'm working on upgrading to Minivend 4.02, and I have a few issues. This is
> running on glibc Linux 2.0.6 w/ the newest stable versions of: Perl, DBI,
> and the Mysql DBD. The machine is running a fairly new version of mysql
> which works just fine...
>
> Right now, I'm just screwing around w/ the new 'simple' demo, and I can't
> seem to get SQL to work correctly. It seems like its half SQL and half text
> file. If I delete the products/products.txt file, the system doesn't work
> anymore, but when I edit the SQL products table, and change a price, that
> change shows up on the page immediately. It seems like its searching
> through the text database, and then looking in SQL. I wouldn't think this
> would be very efficient.
You can either use an ASCII file or not. MV does certain functions (like
[search ..] or pure text searches) on the text file. If you only want to
use the SQL DB, you keep an empty ASCII file with only the field names
and set the NoImport directive to products.txt or whatever that file is.
In this case, you cannot change the contents of your DB by editing the
ASCII file, as you can, if you keep the ASCII file populated. Also
mv_searchtype can never be "text" ("st=test") or Glipms.
This is essentially the same behaviour as with GDM or GDBM.
I am sorry, but I do not have an answer for the second question.
Chris
>
> Second, Minimate is refusing to authenticate me. Where does that program
> store passwords? I saw the minimate file in the products/ directory, but it
> didn't have the passwords.
>
> Thanks,
>
> Brian Hanley
> Parrett Internet Technologies
>
> -
> 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
