SQL database order tracking

[William Tan <william@absolutely.com.sg>]

******    message to minivend-users from William Tan <william@absolutely.com.sg>     ******

Hi,

	I'm trying to record orders into mySQL database.  I've split the
order into 2 tables -- orders and orderitems.  So, according to the docs,
I can place them in /etc/report using the [import] directive.

Since my db design is different from GDBM style, i did something like this
for the 'orders' table:

Add main order [value mv_order_number] to orders: 
[import table=orders type=LINE continue=NOTES]
status: 0
code: [value mv_order_number]
shipping_price: [shipping]
session: [data session id]
total: [subtotal noformat=1]
order_date: [value name=order_date set="[tag time]%m-%d-%Y[/tag]"]
order_time: [value name=order_date set="[tag time]%k:%M[/tag]"]
customer_code: [data session username]
[/import]


Minivend dies with an error:

Runtime error: Modification of a read-only value attempted at
/home/mvend/minivend/lib/Vend/Table/DBI.pm line 496, <IN> chunk 1.

I tried looking at the source code, but since I'm such an idiot at Perl I
couldn't make out anything.  I also experimented with lots of different
combinations, the wierdest one happens when I commented out all the fields
except for 'code' and it worked!!!  When I put the rest back in it simply
dies.  Am I missing out on something here?

Has anyone experienced the same problem and managed to work around it?
Any suggestions?  Please help, I'm at a loss here...

My config is Perl 5.004_04 with MV 3.12 on Linux 2.0.36


Thanks in advance.
wil.

-
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