Re: Catalog Corrupts over time...PLZ help

[Viaweb Consultoria Internet <kiko@viaweb.com.br>]

******    message to minivend-users from Viaweb Consultoria Internet <kiko@viaweb.com.br>     ******

Dear Mike,

Thanks again for your help, but it still didn't work....*8((
I'm trying to put up the 3.14 version to see if it stops with the problem,
but this takes me to another old problem, a Userdb problem.

I already changed the tags to the new ones on the login procedure, but it
*always*  gives me the "Passwrd Mismatch" error. The only way it gives me
another error is if I use it like this:

[set Login]
	[userdb function=login crypt=0]
[/set]

[if session failure]
	[data session failure]
[/if]

<FORM ACTION="[process-target]" METHOD=POST target=_self>
<TD WIDTH="145" BACKGROUND="null!!">
<IMG SRC="new/1x1transp.gif" WIDTH=145 HEIGHT=1 ALT="" BORDER="0">
<BR>
<FONT FACE="verdana,arial, geneva, helvetica" COLOR="black" SIZE="-1">
    <INPUT TYPE=hidden NAME=mv_click VALUE=Login>
    <INPUT TYPE=hidden NAME=mv_doit VALUE=return>
    <INPUT TYPE=hidden NAME=mv_nextpage VALUE="catalog">
	<b>Login</b><br>
    <INPUT NAME=mv_username VALUE="[value mv_username]" SIZE=10><br>
	<b>Senha</b><br>
	<INPUT TYPE=password NAME=mv_password VALUE="" SIZE=10><br>
	<INPUT TYPE=submit VALUE="Log in">
</font>
</TD>
</FORM>

The error is an Access error that only appears with the above config and if
the password and login are correct. If I type an incorrect password it
correctly tells me "Password Mismatch". If I type an non-existing user it
also tells me correctly "Uknown User".

This is the MS/Access error: 

[Microsoft][ODBC
         Microsoft Access 97
         Driver] Syntax error in
         UPDATE statement.
         (SQL-37000)(DBD:
         st_prepare/SQLPrepare
         err=-1) 


I also set on the config files the "Variable   MV_NO_CRYPT   1" as you told
me once, but it doesn't work.

Do you know what may be happening?

Thanks again for your great help,

Rodrigo Afonso
Executive Director / Diretor Executivo
kiko@viaweb.com.br
ViaWeb Consultoria Internet
http://www.viaweb.com.br



At 14:46 07/06/99 -0400, you wrote:
>******    message to minivend-users from mikeh@minivend.com     ******
>
>Quoting Viaweb Consultoria Internet (kiko@viaweb.com.br):
>> 
>> I have two catalogs running on the same MV server and after some hours it
>> starts to mix the two catalogs. The searches come with results from the two
>> catalogs and information on the results page and flypage come up
>> mixed...the only way to fix up the problem is restarting MV.
>> 
>> Has someone experienced the same problem or knows what may be happening?
>> 
>> Im runinng MV 3.11 on NT 4.0 server with latest Active Perl (build 517) and
>> using ODBC/Access databases.
>> 
>
>Never heard of this one.
>
>I am guessing that it is due to the single-threaded nature of the NT
>system.  But without more precise information about symptoms there is
>probably not much I can do.
>
>You might try changing in bin/minivend anywhere you see it:
>
>	if($Vend::Save) {
>
>to 
>
>	if (0 and $Vend::Save) {
>
>This is the only place I see potential for trouble...
>
>-- 
>Mike Heins                          http://www.minivend.com/  ___ 
>                                    Internet Robotics        |_ _|____
>                                    131 Willow Lane, Floor 2  | ||  _ \
>It's a little-known fact            Oxford, OH  45056         | || |_) |
>that the Y1K problem caused         <mikeh@minivend.com>     |___|  _ <
>the Dark Ages. -- unknown           513.523.7621 FAX 7501        |_| \_\
>-
>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