[Interchange-bugs] [Bug 222] New - Crash in wizard when loading product data at final confirmation

[bugzilla-daemon@interchange.redhat.com]

http://developer.akopia.com/bugs/show_bug.cgi?id=222

*** shadow/222	Sat Jun 16 14:33:41 2001
--- shadow/222.tmp.31154	Sat Jun 16 14:33:41 2001
***************
*** 0 ****
--- 1,80 ----
+ Bug#: 222
+ Product: Interchange
+ Version: 4.7.x
+ Platform: PC
+ OS/Version: Windows 2000
+ Status: NEW   
+ Resolution: 
+ Severity: normal
+ Priority: P2
+ Component: UI
+ AssignedTo: __UNKNOWN__                            
+ ReportedBy: craig@cellarcinemas.com               
+ URL: 
+ Cc: 
+ Summary: Crash in wizard when loading product data at final confirmation
+ 
+ See contents of error.log below.
+ 
+ To reproduce this bug:
+ 
+ 1. checkout cvs head (in this case 4.7.5)
+ 2. ./configure
+ 3. makecat (with computers as the foundation store type)
+ 4. start interchange and go to the wizard
+ 5. [entered my store info - let me know if you need more info]
+ 6. At Final Confirmation, click next and the following error is in
+      the error.log
+ 
+ gateway tCco7XGS:gateway - [16/June/2001:13:49:24 -0400] store /cgi-
+ bin/store/ui Error saving matches: 
+ gateway tCco7XGS:gateway - [16/June/2001:13:49:24 -0400] store /cgi-
+ bin/store/ui Safe: Can't call method "query" on an undefined value at (eval 
+ 263) line 10.
+ > 
+ > 
+ > 	my $pdb = $Db{products};
+ > 	my $tdb = $Db{transactions};
+ > 	my $pcount = $pdb->query( 
+ > 					{
+ > 						sql => 'select * from products',
+ > 						row_count => 1,
+ > 					}
+ > 					);
+ > 	my $tcount = $tdb->query( 
+ > 					{
+ > 						sql => 'select * from 
+ transactions',
+ > 						row_count => 1,
+ > 					}
+ > 					);
+ > 	delete $Scratch->{pmessage};
+ > 	delete $Scratch->{pdefault};
+ > 	if($pcount > 0) {
+ > 		$Scratch->{pmessage} = "$pcount products currently in the 
+ database - select Yes to add/replace products";
+ > 		$Values->{sampleproducts} = $Scratch->{pdefault} = '';
+ > 		$Scratch->{pwidget} = "yesno";
+ > 	}
+ > 	else {
+ > 		$Scratch->{pmessage} = "No products currently in the database - 
+ select No to add no products";
+ > 		$Scratch->{pwidget} = "hidden";
+ > 		$Values->{sampleproducts} = $Scratch->{pdefault} = '1';
+ > 	}
+ > 
+ > 	delete $Scratch->{tmessage};
+ > 	delete $Scratch->{tdefault};
+ > 	if($tcount > 0) {
+ > 		$Scratch->{tmessage} = "$tcount orders currently in the 
+ database - select Yes to add/replace orders";
+ > 		$Values->{sampleorders} = $Scratch->{tdefault} = '';
+ > 	}
+ > 	else {
+ > 		$Scratch->{tmessage} = "No orders currently in the database - 
+ select No to leave blank";
+ > 		$Values->{sampleorders} = $Scratch->{tdefault} = '1';
+ > 	}
+ > 	return;
+ > 
+ >