[ic] [table-editor] not updating mysql

[Zack Johnson]

I copied ship_addresses.html to foo.html.  I created a new table called
'foo', and modified my new file to use it.  This new page gets it's key from
a field I added in 'userdb'.  This information works as expected.

All is well.

I log in as a customer and open add_foo.html.  Good.  I enter a new record,
noticing that my key (which is visible) is correctly set.  Great.  I hit
okay.  Excellent!  I view the mysql table--no change.

I'm thoroughly stumped.  I'm using the [table-editor] tag to accomplish this
feat.  In fact, I'm basing as close as possible to the code found in
shipping_addresses.  I copied it, after all.  I've also compared this to the
code in several of the UI tables.  Some of the relevant information follows:

<FORM METHOD=GET ACTION="http://localhost/cgi-bin/foundation/add_foo">
<INPUT TYPE=hidden NAME=mv_todo VALUE="set">
<INPUT TYPE=hidden NAME=mv_click VALUE="process_filter">
<INPUT TYPE=hidden NAME=mv_nextpage VALUE="add_foo">
<INPUT TYPE=hidden NAME=mv_data_table VALUE="foo">
<INPUT TYPE=hidden NAME=mv_data_key VALUE="foo_id">
<INPUT TYPE=hidden NAME=ui_hide_key VALUE="0">
<INPUT TYPE=hidden NAME=mv_update_empty VALUE="1">
<INPUT TYPE=hidden NAME=mv_data_function VALUE="update">
<INPUT TYPE=hidden NAME="mv_action" VALUE="back">
<INPUT TYPE=hidden NAME="mv_form_profile" VALUE="ui_profile">

    [table-editor
     href="@@MV_PAGE@@"
     no_top=1
     hidden.mv_action=back
     ui_hide_key=0
     table=foo
     table_width="95%"
     auto_secure=1
     reload=1
     all_errors=1

     check.foo_id="required We need a foo_id...."
     check.field1="required We need a field1...."
     check.field2="required We need a field2...."
     get=1
     ui_data_fields="foo_id field1 field2"
     key="[scratch foo_id]"]

The db_acl for this customer includes only 'foo'.

Nothing show up in the error logs.

TIA!

Zack Johnson
Internet Manager
Standard Printing & Web Center
St. Augustine, FL 32084
phone (904) 829-6488
fax (904) 824-2959
www.standardprinting.net