[mv] Unable to write to MYSQL database

[Jarno Niemelä <jargon@iki.fi>]

******    message to minivend-users from Jarno =?iso-8859-1?Q?Niemel=E4?= <jargon@iki.fi>     ******

Hello everyone.

I've created an user shipping database with MYSQL,
and I'd like to be able to write to it from minivend
(from checkout.html to be precise).

The problem is that when I try to insert into the database with 
[sql] tag I get internal server error.

Heres the database table I've created

Database:minivend

table user_shipping
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| session_id     | varchar(255) |      | PRI |         |       |
| shipping_name  | varchar(255) | YES  |     | NULL    |       |
| shipping_price | varchar(255) | YES  |     | NULL    |       |
+----------------+--------------+------+-----+---------+-------+

Heres the rows that declare it in catalog.cfg

#Shipping database
Database	user_shipping		user_shipping.tab	dbi:mysql:minivend:webshop:3306
Database	user_shipping		USER	XX
Database	user_shipping		PASS	XXXX

the user_shipping.tab is an empty file, because I dont want to import
anything to there.

So
NoImport	user_shipping


And heres the tag that I use in trying to write to the database

[sql type=set base=user_shipping interpolate=1]
replace into shipping_values 
('[value mv_order_number]',
'[value shipping-description]',
'[value shipping]'
)
[/sql]

When I load the page that has this tag, I get the standard internal server
error page.

I created a dummy 'products' (actually foobar) table with 
Database .. definition in catalog.cfg so I know that the connection
to database works as it should.
But I am unable to insert anything to the database using SQL tags.

could someone please point to my what I am doing wrong?

Jarno Niemela





-
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