Re: [mv] database permission troubles with mv4.0

[Jonathan <jrs@abhost.net>]

******    message to minivend-users from Jonathan <jrs@abhost.net>     ******

> ******    message to minivend-users from Jonathan <jrs@abhost.net>     ******
> 
> Hi.
> 
> I'm in the process of moving a site from mv3.14-5 to mv4.0 and I've
> having some difficulty
> with a few things.
> I've got my userdb in sql.  I've got a form that looks like:
> 
> <form action="[process-target]" method="post">
> <input type="hidden" name="mv_data_table" value="userdb">
> <input type="hidden" name="mv_data_key" value="code">
> <input type="hidden" name="mv_data_function" value="insert">
> <input type="hidden" name="mv_data_fields" value="firstname, lastname">
> <input type="hidden" name="mv_nextpage" value="@@MV_PAGE@@">
> <input type="hidden" name="mv_todo" value="set">
> [loop arg="[value update-code]"]
> <input type="hidden" name="code" value="[loop-code]">
> <input type="text" name="firstname" value="[loop-field firstname]"
> size="30">
> <input type="text" name="lastname" value="[loop-field lastname]"
> size="30">
> [/loop]
> <input type="submit" name="submit" value="Update Database">
> </form>
> 
> The form queries the database and the values are filled correctly.
> 
> When I submit however I get the following message in error.log:
> 
> 24.12.224.116 LHVDVwxi:24.12.224.116 - [01/March/2000:05:57:59 -0800]
> abhost /mvend-bin/abhost/process.html Attempted database update without
> permission, table=userdb key=test.

For the archives, the (partial) solution to this problem is to add
[set mv_data_enable]1[/set]
to the page with the form.

I no longer get the "without permission" error.  Unfortunatly I still
get an Error:

24.12.224.116 fV2QeuZ2:24.12.224.116 - [01/March/2000:18:48:44 -0800]
abhost /mvend-bin/abhost/process.html No key 'code' found for
function='insert' table='userdb' key='test'

in mysql.userdb I have:
Database  userdb  COLUMN_DEF   "code=char(20) NOT NULL PRIMARY KEY"

and just to be sure that everything matches, I've even done:
mysql> alter table userdb change code code char(20) NOT NULL PRIMARY
KEY;

can anybody tell me what "No key 'code' found for function='insert'
table='userdb' key='test'"
means and what I can do about it?

As always, thanks a lot for any help.
 
-- Jonathan
-
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