No Subject

[Michel Chamberland <crakrjak@xerxes.com>]

******    message to minivend-users from Michel Chamberland <crakrjak@xerxes.com>     ******

hi im having trouble interfacing Oracle with minivend
i installed the DBI and DBD:Oracle modules

i set catalog.cfg to:

Database products products.asc dbi:Oracle:DB01
Database            products USER   myusername
Database            products PASS   mypassword

DB01 is my oracle database instance the login/passwd works perfectly with
sqlplus, im using the latest minivend that i downloaded today. The "make
test" for DBI and DBD work perfectly.

all it does when i start minivend is delete my table called products in
oracle. and give the the following error message

here is the error message i get ...

[oracle@nucleus store]$ /ora/mvend/bin/restart
Sent TERM to server on PID 9778.
MiniVend server stopped.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 280.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 304.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 304.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 5.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 32.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 53.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 65.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 65.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 65.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 65.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 65.
Use of uninitialized value at /usr/lib/perl5/Text/ParseWords.pm line 73,
<GLOBAL> chunk 141.
MiniVend V3.11
Configuring catalog store...store config error: DBI: Create table
'products' failed: ORA-00904: invalid column name (DBD ERROR:
OCIStmtExecute)
 at /ora/mvend/lib/Vend/Data.pm line 419


store: error in configuration. Skipping.
store: config error. Skipping.
MiniVend server started in INET and UNIX mode(s) (process id 9801)
[oracle@nucleus store]$ 


Why is it trying to "create a table"? shouldnt it just read from my
products table on DB01?

if i didnt give enough information, let me know

thanks for any help! :)


-------------------------------------------------------------------------------
  Michel Chamberland      
  mike@xerxes.com        
  XERXES inc.           
  http://www.xerxes.com  


-
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