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

[Hans-Joachim Leidinger <jojo@buchonline.net>]

******    message to minivend-users from Hans-Joachim Leidinger <jojo@buchonline.net>     ******

Eugene Apanasenko schrieb:
[DEL]
> >
> >
> 
> 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.

Maybe this (comming from MV3.14)

	    [tag touch userdb][/tag]
	    [set Change]
	    [tag flag write]userdb[/tag]
	    [userdb change_pass]
	    [/set]

for example cause your problem? If i read this from minivend document

-----snip of the section "The [userdb...] tag -----
There are several global parameters that apply to any use of the userdb
functions. Most importantly, by default the database table is set to be
userdb. If you must
use another table name, then you should include a database=table
parameter with any call to userdb. The global parameters (default in
parens): 

    database     Sets user database table (userdb)
    show         Show the return value of certain functions
                 or the error message, if any (0)
    force_lower  Force possibly upper-case database fields
                 to lower case session variable names (0)
    billing      Set the billing fields (see Accounts)
etc.
-----snip-----

Maybe you have to us this

	    [tag touch members][/tag]
	    [set Change]
	    [tag flag write]members[/tag]
	    [userdb database=members change_pass]
	    [/set]

or 

	    [tag touch members][/tag]
	    [set Change]
	    [tag flag write]members[/tag]
	    [userdb 
                  database=members 
                  function=change_pass
            ]
	    [/set]


? Look at 

	  [set NewAccount]
	  [userdb new_account]
	  [/set]

too.

I hope this helps you!

Regards,

	Joachim

-- 
-------------Hans-Joachim Leidinger---------------------

-
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