[ic] Attempted database update without permission

Alma Nuker interchange-users@icdevgroup.org
Thu Aug 22 19:07:00 2002


Hi list;

I have form which I use to enter data into database as follow:

[update values]
[set mv_data_enable]1[/set]
[tag flag write]partnersdb[/tag]
<FORM ACTION="[process]" METHOD="POST">
<INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="partnersdb">
<INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="partners_id">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="insert">
<INPUT TYPE=HIDDEN NAME="mv_nextpage" VALUE=@@MV_PAGE@@>
<INPUT TYPE=hidden NAME=mv_check VALUE=NewWeb>
<INPUT TYPE=hidden NAME="mv_form_profile" VALUE="partners_profile">
<INPUT TYPE="HIDDEN" NAME="mv_data_fields"
VALUE="partners_id,fname,lname,email,company,address1,city,state,zip,country,partner_type,partners_comments">

[set NewWeb]
[if type=explicit compare="[error all=1 show_var=1 keep=1]"]
mv_nextpage=@@MV_PAGE@@
[else]
mv_nextpage=ord/send_partners
[/else]
[/if]
[/set]
<INPUT TYPE="HIDDEN" NAME="mv_data_return_key" VALUE="partners_id">
<INPUT TYPE=HIDDEN name="partners_id" value="">

................

,,,,,,,,,,,,,, All other fileds here ,,,,,,,,,,,,,,,,,,

<INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
<INPUT TYPE="SUBMIT" VALUE="Register">
<INPUT TYPE="Reset">
</FORM>

I am using mysql database and in dbconfig/mysql I have defined partners
table as follow:

Database  partnersdb  partnersdb.txt   __SQLDSN__
ifdef SQLUSER
Database  partnersdb  USER         __SQLUSER__
endif
ifdef SQLPASS
Database  partnersdb  PASS         __SQLPASS__
endif
Database  partnersdb  KEY          parteners_id
Database  partnersdb  COLUMN_DEF   "parteners_id=INT(9) UNSIGNED
AUTO_INCREMENT PRIMARY KEY"
Database  partnersdb  COLUMN_DEF   "fname=CHAR(30)"
Database  partnersdb  COLUMN_DEF   "lname=CHAR(30)"
Database  partnersdb  COLUMN_DEF   "email=VARCHAR(42)"
Database  partnersdb  COLUMN_DEF   "company=CHAR(30)"
Database  partnersdb  COLUMN_DEF   "address1=CHAR(64)"
Database  partnersdb  COLUMN_DEF   "city=CHAR(30)"
Database  partnersdb  COLUMN_DEF   "state=CHAR(10)"
Database  partnersdb  COLUMN_DEF   "zip=CHAR(10)"
Database  partnersdb  COLUMN_DEF   "country=CHAR(10)"
Database  partnersdb  COLUMN_DEF   "partner_type=CHAR(64)"
Database  partnersdb  COLUMN_DEF   "partners_comments=text"

In catalog.cfg I added following:

Database partnersdb AUTO_SEQUENCE 1

It was working fine for a while but now I am getting following message
in erro.log while trying to add data into db:

/cgi-bin/ic/ya/process.html Attempted database update without
permission, table=pressdb key=.

Do you have any ideas what could be wrong.

I tried redoing tables etc, but no luck always same message appears in
error log.

Thanks in advance.

Alma