Re: [mv] q: Can't use userdb as sql-table.. ANSWER

[Eugene Apanasenko <evlap@mail.ru>]

******    message to minivend-users from Eugene Apanasenko <evlap@mail.ru>     ******



Jim Balster wrote:

> ******    message to minivend-users from Jim Balster <jbalster@dmat.com>     ******
>
> I have my userdb in an SQL database, but I did it by changing the table
> name:
> In catalog.cfg:
> (I don't remember how many of these 4 are necessary - if any)
> Variable      MV_USERDB            member
> Variable      MV_USERDB_ACL_TABLE  member
> Variable      MV_USERNAME          MemberID
> Variable      MV_PASSWORD          password
>
> Database member   member.asc        SQL
> Database member   DSN               dbi:mSQL:__SERVER_BASE__
> Database member   NUMERIC    MemberID      integer
> Database member   COLUMN_DEF password      CHAR(32)
> Database member   COLUMN_DEF Title         CHAR(10)
> Database member   COLUMN_DEF First         CHAR(32)
> Database member   COLUMN_DEF Last          CHAR(32)
> Database member   COLUMN_DEF name          CHAR(64)
> Database member   COLUMN_DEF address1      CHAR(64)
> Database member   COLUMN_DEF address2      CHAR(64)
> Database member   COLUMN_DEF address3      CHAR(64)
> Database member   COLUMN_DEF City          CHAR(40)
> Database member   COLUMN_DEF State         CHAR(40)
> Database member   COLUMN_DEF Zip           CHAR(16)
> Database member   COLUMN_DEF Country       CHAR(40)
> . . . and so on
>
> Then I call USERDB as follows:
> [userdb function="new_account" database="member" username="[value
> new_username]" password="[value mv_password]" verify="[value mv_verify]"
> KEY=MemberID]
>
> The KEY here is database="member" which is a different name from userdb
> and
> matches the name in the SQL database.
>
>

Hi!
Thanks for reply.
I have done the modifications you tell me, but I didnt describe mebers table structure and set
"NoImport members" as I've already got it. The problem is how should I specify to use members table
instead of userdb standart table? The example
[userdb function="new_account" database="member" username="[value
new_username]" password="[value mv_password]" verify="[value mv_verify]"
KEY=MemberID]
works great but when I try to modify new_account.html (from demo) adding
line: <INPUT TYPE=hidden NAME=database  VALUE=members>
to the code below
 <FORM ACTION="[process-target]" METHOD=POST>
 <INPUT TYPE=hidden NAME=mv_click VALUE=NewAccount>
 <INPUT TYPE=hidden NAME=mv_doit  VALUE=return>
 <INPUT TYPE=hidden NAME=function  VALUE=new_account>
  <INPUT TYPE=hidden NAME=mv_nextpage VALUE=ord/basket>
I get an error message:  Runtime error: user database userdb does not exist.
Any help will be appreciated.

Regards, Eugene

-
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