[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] UserDB -> MySQL Issue.
****** message to minivend-users from Mark Stosberg <mark@summersault.com> ******
Try something like the below configuration. This is taken from the 4.0
beta 2 distribution, which includes this as part of the 'simple' store.
You'll need to replace the variables like __SQLDSN__ with something
works for you.
-mark
atabase userdb userdb.txt __SQLDSN__
#ifdef SQLUSER
Database userdb USER __SQLUSER__
#endif
#ifdef SQLPASS
Database userdb PASS __SQLPASS__
#endif
Database userdb COLUMN_DEF "code=char(20) NOT NULL PRIMARY KEY"
Database userdb COLUMN_DEF "password=CHAR(20) NOT NULL"
Database userdb COLUMN_DEF "acl=text"
Database userdb COLUMN_DEF "mod_time=timestamp"
Database userdb COLUMN_DEF "s_nickname=text"
Database userdb COLUMN_DEF "company=CHAR(30)"
Database userdb COLUMN_DEF "fname=CHAR(20)"
Database userdb COLUMN_DEF "lname=CHAR(30)"
Database userdb COLUMN_DEF "address1=CHAR(64)"
Database userdb COLUMN_DEF "address2=CHAR(64)"
Database userdb COLUMN_DEF "address3=CHAR(64)"
Database userdb COLUMN_DEF "city=CHAR(30)"
Database userdb COLUMN_DEF "state=CHAR(10)"
Database userdb COLUMN_DEF "zip=CHAR(10)"
Database userdb COLUMN_DEF "country=CHAR(10)"
Database userdb COLUMN_DEF "phone_day=CHAR(20)"
Database userdb COLUMN_DEF "mv_shipmode=CHAR(64)"
Database userdb COLUMN_DEF "b_nickname=text"
Database userdb COLUMN_DEF "b_fname=CHAR(20)"
Database userdb COLUMN_DEF "b_lname=CHAR(30)"
Database userdb COLUMN_DEF "b_address1=CHAR(64)"
Database userdb COLUMN_DEF "b_address2=CHAR(64)"
Database userdb COLUMN_DEF "b_address3=CHAR(64)"
Database userdb COLUMN_DEF "b_city=CHAR(30)"
Database userdb COLUMN_DEF "b_state=CHAR(10)"
Database userdb COLUMN_DEF "b_zip=CHAR(10)"
Database userdb COLUMN_DEF "b_country=CHAR(10)"
Database userdb COLUMN_DEF "b_phone=CHAR(20)"
Database userdb COLUMN_DEF "mv_credit_card_type=CHAR(16)"
Database userdb COLUMN_DEF "mv_credit_card_exp_month=CHAR(2)"
Database userdb COLUMN_DEF "mv_credit_card_exp_year=CHAR(4)"
Database userdb COLUMN_DEF "mv_credit_card_info=blob"
Database userdb COLUMN_DEF "p_nickname=text"
Database userdb COLUMN_DEF "email=VARCHAR(42)"
Database userdb COLUMN_DEF "fax=CHAR(20)"
Database userdb COLUMN_DEF "phone_night=CHAR(20)"
Database userdb COLUMN_DEF "fax_order=CHAR(2)"
Database userdb COLUMN_DEF "address_book=BLOB"
Database userdb COLUMN_DEF "accounts=BLOB"
Database userdb COLUMN_DEF "preferences=BLOB"
Database userdb COLUMN_DEF "carts=BLOB"
Database userdb COLUMN_DEF "owner=char(20)"
Database userdb COLUMN_DEF "file_acl=BLOB"
Database userdb COLUMN_DEF "db_acl=BLOB"
Database userdb COLUMN_DEF "order_numbers=TEXT"
Database userdb COLUMN_DEF "email_copy=char(1)"
Database userdb COLUMN_DEF "mail_list=varchar(64)"
Database userdb COLUMN_DEF "project_id=char(20)"
Database userdb COLUMN_DEF "account_id=char(20)"
Database userdb COLUMN_DEF "order_dest=char(32)"
"Jason M. Korkin" wrote:
>
> ****** message to minivend-users from "Jason M. Korkin" <jkorkin@korksoft.com> ******
>
> Hi All,
> I have a quick question... I'm having problems getting MV to insert items into the
> UserDB right now. I basically took the stock configuration from MV for the UserDB, and
> made it SQL instead of ASCII... Now its not even inserting anything into the fields.
> Any ideas?
>
> In the catalog.cfg file I have the following:
>
> Database country country.asc TAB
> Database products products.asc dbi:mysql:uname:localhost:3333
> Database userdb userdb.asc dbi:mysql:uname:localhost:3333
> Database products ChopBlanks 1
> Database products USER uname
> Database products PASS here
> Database userdb USER uname
> Database userdb PASS here
> Database products WRITE_ALWAYS 1
> Database userdb WRITE_ALWAYS 1
>
> Any ideas?
>
> Thanks,
>
> Jason Korkin.
>
> -
> 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
--
<<-------------------------------------------------------------->>
personal website < Summersault Website Design
http://mark.stosberg.com/ > http://www.summersault.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
