[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Problem report
****** message to minivend-users from "kyle@invisio.com" <kyle@invisio.com> ******
I don't know how to help fix what caused this problem, but if you just
want it to get back up and running, you could try removing (or renaming)
the session.db (.gdbm) file in the catalog directory (where catalog.cfg is)
I don't know if it will work, but I have seen some unusual behavior when
this file gets corrupted.
Kyle (KC)
At 02:00 PM 2/21/00 +0000, you wrote:
>****** message to minivend-users from root <root@nova.smartartist.net>
> ******
>
>#### Description of problem
>
>installed the sample catalogue, all was working fine til I tried to save a
>cart (think it was empty). calling reconfig now hangs, and restarting the
>server makes no difference, just getting nothing now but a 500 server error.
>FYI I'm running in INET mode, RH5.2 apache 1.3.9. with suexec enabled. my
>email is webmaster@smartartist.net
>
>
>
>#### Perl version
>Summary of my perl5 (5.0 patchlevel 4 subversion 4) configuration:
> Platform:
> osname=linux, osvers=2.0.34, archname=i386-linux
> uname='linux porky.redhat.com 2.0.34 #1 thu may 7 10:17:44 edt 1998 i686
>unknown '
> hint=recommended, useposix=true, d_sigaction=define
> bincompat3=y useperlio=undef d_sfio=undef
> Compiler:
> cc='cc', optimize='-O2', gccversion=2.7.2.3
> cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include'
> ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include'
> stdchar='char', d_stdstdio=define, usevfork=false
> intsize=4, longsize=4, ptrsize=undef, doublesize=undef
> alignbytes=4, usemymalloc=n, prototype=define
> Linker and Libraries:
> ld='cc', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib
> libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt
> libc=, so=so
> useshrplib=false, libperl=libperl.a
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
> cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
>
>
>Characteristics of this binary (from libperl):
> Locally applied patches:
> MAINT_TRIAL_4 - 5.004_05 maintenance trial 4
> Built under linux
> Compiled at Sep 10 1998 02:16:22
> @INC:
> /usr/lib/perl5/i386-linux/5.00404
> /usr/lib/perl5
> /usr/lib/perl5/site_perl/i386-linux
> /usr/lib/perl5/site_perl
> .
>
>#### OS version
>Linux nova.smartartist.net 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i686 unknown
>
>#### Main server config
>Catalog pshop /home/mvend/pshop /cgi-bin/pshop /pshop
>Variable MV_NO_CRYPT 1
>AdminUser minivend:nevairbe
>AllowGlobal _mv_admin
>GlobalSub sub test_global_sub { return 'Test of global subroutine OK.' }
>HouseKeeping 5
>MaxServers 5
>PIDcheck 300
>TcpMap 7786 -
>TolerateGet Yes
>Variable TEST_VARIABLE Test of global variable OK.
>UserTag loc hasEndTag 1
>UserTag loc Interpolate 1
>UserTag loc Order locale
>UserTag loc Routine <<EOF
>sub {
> my ($locale, $message) = @_;
> return $message unless $Vend::Cfg->{Locale};
> my $ref;
> if($locale) {
> return $message
> unless defined $Vend::Cfg->{Locale_repository}{$locale};
> $ref = $Vend::Cfg->{Locale_repository}{$locale}
> }
> else {
> $ref = $Vend::Cfg->{Locale};
> }
> return defined $ref->{$message} ? $ref->{$message} : $message;
>EOF
>UserTag var Interpolate 1
>UserTag var PosNumber 2
>UserTag var Order name global
>UserTag var Routine <<EOF
>sub {
> $_[1] and return $Global::Variable->{shift @_};
> return $Vend::Cfg->{Variable}{shift @_};
>EOF
>UserTag summary Order amount name currency format total reset hide
>UserTag summary PosNumber 6
>UserTag summary Routine <<EOF
>use vars qw/%summary_hash/;
>sub {
> my ($amount, $name, $currency, $format, $total, $reset, $hide) = @_;
> unless ($name) {
> $name = 'ONLY0000';
> %summary_hash = () if Vend::Util::is_yes($reset);
> else {
> $summary_hash{$name} = 0 if Vend::Util::is_yes($reset);
> $summary_hash{$name} += $amount if length $amount;
> $amount = $summary_hash{$name} if Vend::Util::is_yes($total);
> return '' if defined $hide && Vend::Util::is_yes($hide);
> return sprintf $format, $amount if $format;
> return Vend::Util::currency($amount) if $currency;
> return $amount;
>EOF
>UserTag db-date Order table format
>UserTag db-date PosNumber 2
>UserTag db-date Routine <<EOF
>sub {
> my ($format, $db) = @_;
> $format = '%A %d %b %Y';
> $db = 'products' unless $db;
> my $mtime = (stat($Vend::Cfg->{Database}{'file'}))[9];
> return POSIX::strftime($format, localtime($mtime));
>EOF
>UserTag db-count Order table
>UserTag db-count PosNumber 1
>UserTag db-count Routine <<EOF
>sub {
> my ($db) = @_;
> $db = 'products' unless $db;
> my $ref = Vend::Data::database_exists_ref($db)
> or return "Bad table $db";
> $ref = $ref->ref();
> my $count;
> while ($ref->each_record()) {
> $count++;
> }
> return $count;
>EOF
>UserTag bar-button Order page current
>UserTag bar-button PosNumber 2
>UserTag bar-button HasEndTag 1
>UserTag bar-button Routine <<EOR
>sub {
> use strict;
> my ($page, $current, $html) = @_;
> $current = $Global::Variable->{MV_PAGE}
> if ! $current;
> $html =~ s:\[selected\]([\000-\377]*)\[/selected]::i;
> my $alt = $1;
> return $html if $page ne $current;
> return $alt;
>EOR
>
>#### Catalog config differences
>3,30c3,30
>< Variable SERVER_NAME __MVC_SERVERNAME__
>< Variable CGI_URL __MVC_CGIURL__
>< Variable SECURE_SERVER http://__MVC_SERVERNAME__
>< Variable ORDERS_TO __MVC_MAILORDERTO__
>< Variable IMAGE_DIR __MVC_IMAGEURL__
>< Variable DOCROOT __MVC_DOCUMENTROOT__
>< Variable SAMPLEHTML __MVC_SAMPLEHTML__
>< Variable SAMPLEURL __MVC_SAMPLEURL__
><
>< Variable COMPANY __MVC_COMPANY__
>< Variable ADDRESS __MVC_ADDRESS__
>< Variable CITY __MVC_CITY__
>< Variable PHONE __MVC_PHONE__
>< Variable TOLLFREE __MVC_TOLLFREE__
>< Variable FAX __MVC_FAX__
>< Variable LOGO __MVC_LOGO__
>< Variable SMLOGO __MVC_SMLOGO__
>< Variable HEADERBG __MVC_HEADERBG__
>< Variable TABLEFG __MVC_TABLEFG__
>< Variable HEADERTEXT __MVC_HEADERTEXT__
>< Variable BARBG __MVC_BARBG__
>< Variable BARTEXT __MVC_BARTEXT__
>< Variable BGIMAGE __MVC_BGIMAGE__
>< Variable BGCOLOR __MVC_BGCOLOR__
>< Variable ENCRYPTOR __MVC_ENCRYPTOR__
>< Variable TAXAREA __MVC_TAXAREA__
>< Variable TAXRATE __MVC_TAXRATE__
>< Variable TAXSHIPPING __MVC_TAXSHIPPING__
>---
>> Variable SERVER_NAME 208.231.9.124
>> Variable CGI_URL /cgi-bin/pshop
>> Variable SECURE_SERVER http://208.231.9.124
>> Variable ORDERS_TO physioshop@localhost
>> Variable IMAGE_DIR /pshop/images
>> Variable DOCROOT /home/httpd/html/physioshop
>> Variable SAMPLEHTML /home/httpd/html/physioshop/pshop
>> Variable SAMPLEURL http://208.231.9.124/pshop
>>
>> Variable COMPANY PhysioShop
>> Variable ADDRESS postal address
>> Variable CITY suburb, NSW 2000
>> Variable PHONE 02 5555555
>> Variable TOLLFREE 02 5555555
>> Variable FAX 02 5555555
>> Variable LOGO PhysioShop.jpg
>> Variable SMLOGO PhysioShop.jpg
>> Variable HEADERBG BGCOLOR=#00A6A6
>> Variable TABLEFG BGCOLOR=#EEEEEE
>> Variable HEADERTEXT #000000
>> Variable BARBG #000080
>> Variable BARTEXT #FFFFFF
>> #Variable BGIMAGE blue_pap.gif
>> Variable BGCOLOR #00A6A6
>> Variable ENCRYPTOR none
>> Variable TAXAREA OH IL
>> Variable TAXRATE OH=6, IL=7.25
>> Variable TAXSHIPPING OH
>39c39
>< Variable MV_NO_CRYPT __MVC_NOCRYPT__
>---
>> Variable MV_NO_CRYPT
>258c258
>< # AdminPage config/menu
>---
>> AdminPage config/menu
>1002c1002
>< Password __MVC_SUPASSWD__
>---
>> Password sWbRjRhdHtEec
>1113c1113
>< RemoteUser __MVC_SUPERUSER__
>---
>> RemoteUser physioshop
>
>#### Main MiniVend error.log (last 50 lines)
>> ",'Download' => "
>> mv_nextpage=config/do_download
>> ",'Save cart' => "
>> mv_todo=return
>> mv_nextpage=ord/basket
>> [userdb function=set_cart nickname=\"[value c_nickname]\"]
>> ",'Login' => "
>> [userdb login]
>> ",'arg' => "",'View' => "
>> mv_nextpage=config/do_view
>> ",'total_junk' => "
>>
>>
>>
>> catalog.cfg
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ",'DELETE cart' => "
>> mv_todo=return
>> mv_nextpage=ord/basket
>> [userdb function=delete_cart nickname=\"[value c_nickname]\"]
>> ",'Recall cart' => "
>> mv_todo=return
>> mv_nextpage=ord/basket
>> [userdb function=get_cart nickname=\"[value c_nickname]\"]
>> ",'reconfigured' => "1",},'discount' => {},'accesses' => "0",'referer' =>
>"",'id' => "V6r4NGnt",'time' => "951138785",'prev_url' =>
>"/ord/basket",'rotate01' => "2",'values' => {'related' =>
>"00-0011a",'save_country' => "US",'title' => "Mona Lisa",'mv_username' =>
>"physioshop",'b_state' => "",'image' => "00-0011.jpg",'address' =>
>"",'weight' => "8",'phone_night' => "",'arbitrary_upload' =>
>"",'{'Feb-21-2000'' => "> [],}",'p_nickname' => "",'b_country' =>
>"",'mvc_data_fields' => "",'city' => "",'file_to_download' => "",'b_city' =>
>"",'color' => "",'description' => "MONA LISA, Da Vinci",'mvc_data_table' =>
>"products",'mvc_dbedit_autoshow' => "1",'db_to_upload' => "",'nontaxable' =>
>"no",'address_book' => "",'1' => "",'mv_change_frame' => "",'preferences' =>
>"",'mv_update_empty' => "1",'country' => "",'display' => "The
>Louvre",'mv_todo' => "return",'arbitrary_ascii' => "0",'b_phone' =>
>"",'download_conversion' => "",'mv_nextpage' => "ord/basket",'accounts' =>
>"",'mvc_too_large' !
>!
>=> "",'mv_data_function' => "update",'name' =>
>"Master",'mv_credit_card_info' => "",'email_copy' => "",'b_name' =>
>"",'mv_data_table' => "products",'mv_data_key' =>
>"code",'mvc_spreadsheet_rows' => "10",'b_nickname' => "",'email' =>
>"",'mvc_rotate_spread' => "",'mv_data_fields' => "description
>> title
>> artist
>> comment
>> display
>> image
>> price
>> category
>> nontaxable
>> weight
>> size
>> color
>> related",'mvc_changes_made' => "",'b_zip' => "",'arbitrary_to_upload' =>
>"catalog.cfg",'order_numbers' => "",'mv_verify' => "kinggeorges",'artist' =>
>"Leonardo Da Vinci",'fax_order' => "",'select_code' => "",'size' =>
>"",'category' => "Renaissance",'mvc_spread_size' => "12",'fax' => "",'state'
>=> "",'page_to_upload' => "",'b_address' => "",'mv_credit_card_exp_month' =>
>"",'c_nickname' => "Feb-21-2000",'owner' => "",'mvc_way_too_large' =>
>"",'mv_credit_card_exp_year' => "",'price' => "50000000",'comment' => "What
>was she smiling about?",'mv_password_old' => "nevairbe",'zip' =>
>"",'mv_password' => "kinggeorges",'mv_credit_card_type' => "",'phone_day' =>
>"",'s_nickname' => "",'mv_shipmode' => "",'code' => "",'carts' =>
>"Feb-21-2000",'mv_data_decode' => "",},'rotate23' => "3",'ship_message' =>
>"Nothing to ship!",'success' => "",'latest_subtotal' => "0",'arg' =>
>"",'last_error' => "Safe: syntax error at (eval 134) line 1, near \"02 555\"
>>
>> 02 555-5555
>> ",'override_check' => "951138703",'page' => "ord/basket",'carts' =>
>{'main' => [],},'frames' => "0",'host' => "203.164.8.144",'user' => "",}'
>from session dbm: syntax error at (eval 94) line 137, near "'{'Feb"
>>
>>
>
>#### Catalog error.log (last 50 lines)
>> ",'Download' => "
>> mv_nextpage=config/do_download
>> ",'Save cart' => "
>> mv_todo=return
>> mv_nextpage=ord/basket
>> [userdb function=set_cart nickname=\"[value c_nickname]\"]
>> ",'Login' => "
>> [userdb login]
>> ",'arg' => "",'View' => "
>> mv_nextpage=config/do_view
>> ",'total_junk' => "
>>
>>
>>
>> catalog.cfg
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ",'DELETE cart' => "
>> mv_todo=return
>> mv_nextpage=ord/basket
>> [userdb function=delete_cart nickname=\"[value c_nickname]\"]
>> ",'Recall cart' => "
>> mv_todo=return
>> mv_nextpage=ord/basket
>> [userdb function=get_cart nickname=\"[value c_nickname]\"]
>> ",'reconfigured' => "1",},'discount' => {},'accesses' => "0",'referer' =>
>"",'id' => "V6r4NGnt",'time' => "951138785",'prev_url' =>
>"/ord/basket",'rotate01' => "2",'values' => {'related' =>
>"00-0011a",'save_country' => "US",'title' => "Mona Lisa",'mv_username' =>
>"physioshop",'b_state' => "",'image' => "00-0011.jpg",'address' =>
>"",'weight' => "8",'phone_night' => "",'arbitrary_upload' =>
>"",'{'Feb-21-2000'' => "> [],}",'p_nickname' => "",'b_country' =>
>"",'mvc_data_fields' => "",'city' => "",'file_to_download' => "",'b_city' =>
>"",'color' => "",'description' => "MONA LISA, Da Vinci",'mvc_data_table' =>
>"products",'mvc_dbedit_autoshow' => "1",'db_to_upload' => "",'nontaxable' =>
>"no",'address_book' => "",'1' => "",'mv_change_frame' => "",'preferences' =>
>"",'mv_update_empty' => "1",'country' => "",'display' => "The
>Louvre",'mv_todo' => "return",'arbitrary_ascii' => "0",'b_phone' =>
>"",'download_conversion' => "",'mv_nextpage' => "ord/basket",'accounts' =>
>"",'mvc_too_large' !
>!
>=> "",'mv_data_function' => "update",'name' =>
>"Master",'mv_credit_card_info' => "",'email_copy' => "",'b_name' =>
>"",'mv_data_table' => "products",'mv_data_key' =>
>"code",'mvc_spreadsheet_rows' => "10",'b_nickname' => "",'email' =>
>"",'mvc_rotate_spread' => "",'mv_data_fields' => "description
>> title
>> artist
>> comment
>> display
>> image
>> price
>> category
>> nontaxable
>> weight
>> size
>> color
>> related",'mvc_changes_made' => "",'b_zip' => "",'arbitrary_to_upload' =>
>"catalog.cfg",'order_numbers' => "",'mv_verify' => "kinggeorges",'artist' =>
>"Leonardo Da Vinci",'fax_order' => "",'select_code' => "",'size' =>
>"",'category' => "Renaissance",'mvc_spread_size' => "12",'fax' => "",'state'
>=> "",'page_to_upload' => "",'b_address' => "",'mv_credit_card_exp_month' =>
>"",'c_nickname' => "Feb-21-2000",'owner' => "",'mvc_way_too_large' =>
>"",'mv_credit_card_exp_year' => "",'price' => "50000000",'comment' => "What
>was she smiling about?",'mv_password_old' => "nevairbe",'zip' =>
>"",'mv_password' => "kinggeorges",'mv_credit_card_type' => "",'phone_day' =>
>"",'s_nickname' => "",'mv_shipmode' => "",'code' => "",'carts' =>
>"Feb-21-2000",'mv_data_decode' => "",},'rotate23' => "3",'ship_message' =>
>"Nothing to ship!",'success' => "",'latest_subtotal' => "0",'arg' =>
>"",'last_error' => "Safe: syntax error at (eval 134) line 1, near \"02 555\"
>>
>> 02 555-5555
>> ",'override_check' => "951138703",'page' => "ord/basket",'carts' =>
>{'main' => [],},'frames' => "0",'host' => "203.164.8.144",'user' => "",}'
>from session dbm: syntax error at (eval 94) line 137, near "'{'Feb"
>>
>>
>
>#### DBM Status
>Have GDBM_File.
>Have DB_File.
>
>-
>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