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,

Having a deeper look at the problem with Userdb, it seems a problem on line
570 on the DBI.PM. It can't update the user database when UserDB.pm calls
set_field to update the time field on it. The line goes like this:

$s->[$DBI]->do("update $s->[$TABLE] SET $column = $value where $s->[$KEY] =
$key")

It keeps saying "Syntax Error at string...". The values of the variables
are being passed correctly...I just can't figure out why it doesn't update
that field...I removed the call from UserDB.pm and it worked fine. The line
on UserDb is like this:

		$self->{DB}->set_field( 	$self->{USERNAME},
					$self->{LOCATION}{LAST},
					time()
				        );

Do you see anything wrong with it? Hope so...*8)

Best regards,

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