[mv] Unable to write to MYSQL database, SOLVED!!!!

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

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

YEHAAA!

I managed to solve my problem, and heres the solution


Database software: MYSQL
Minivend version: 3.14 -5

Database table:
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| code           | varchar(255) |      | PRI |         |       |
| shipping_name  | varchar(255) | YES  |     | NULL    |       |
| shipping_price | varchar(255) | YES  |     | NULL    |       |
+----------------+--------------+------+-----+---------+-------+

Lines in catalog.cfg:

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

Database 	products	COLUMN_DEF	code=varchar(255)
Database 	products	COLUMN_DEF	shipping_name=varchar(255)
Database 	products	COLUMN_DEF	shipping_price=varchar(255)
Database	products	NAME	code shipping_name shipping_price

lines in checkout.html:
[sql type=set base=user_shipping interpolate=1]
replace into user_shipping values ('[data session
id]','[shipping-description]','[shipping]')
[/sql]

In addition you need:
user_shipping.tab -that contains the column names in same fashion as in
products.asc

Or create the table by hand and set the user_shipping to NoImport


Modify this to your needs.


PS.
Jojo, for once I was able to help you, not always the other way around :)

-
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