Mailing List Archive

database issue
I’m getting this error message in the log. Any suggestions on what i'm doing wrong here?

[09/February/2017:15:17:54 -0500] deveair /cgi-bin/devair_brad/item-data.html Attempted database update without permission, table=google_feed key=001479-45.

Here is my file:

[set DoSomething]
[perl table=google_feed]
my $db = $Db{google_feed};
my $key = item_id;
my %opt = ( dml => 'update');
my %columns = (title => $CGI->{title},
description => $CGI->{description},
item_condition => $CGI->{item_condition},
price => $CGI->{price},
availability => $CGI->{availability},
link => $CGI->{link},
image_link => $CGI->{image_link},
color => $CGI->{color},
shipping => $CGI->{shipping},
shipping_weight => $CGI->{shipping_weight});
$db->set_slice([\%opt, $key], \%columns);
return;
[/perl]
[/set]

With these as my form variables:

<form method="POST" action="[area item-data]" enctype="multipart/form-data" name="item_editor" autocomplete="off">

<input type="hidden" name="mv_session_id" value="[data session id]">
<input type="hidden" name="mv_click" value="DoSomething">
<input type="hidden" name="mv_nextpage" value="item-data">
<input type="hidden" name="mv_action" value="return">
<input type="hidden" name="itemID" value="[item-pos 0]">

Of course now I cant get the update script to execute.

Steve Bronson
Air Delights, Inc.
http://www.airdelights.com
steve@airdelights.com
Phone: 1-800-440-5556
Fax: 1-503-643-8224

Air Delights, Inc. is a National Distributor of Plumbing Products and Restroom Accessories. Please visit our website at http://www.airdelights.com
Re: database issue [ In reply to ]
http://www.icdevgroup.org/interchange-doc-5.2.0/frames/icupgrade_24.html

http://www.icdevgroup.org/interchange-doc-5.2.0/frames/ictemplates_45.html



You have to set mv_data_enable scratch variable before the operation works.



CU,


Gert





From: interchange-users-bounces@icdevgroup.org [mailto:interchange-users-bounces@icdevgroup.org] On Behalf Of Steve Bronson
Sent: Friday, February 10, 2017 18:40
To: interchange-users@icdevgroup.org
Subject: [ic] database issue





I’m getting this error message in the log. Any suggestions on what i'm doing wrong here?



[09/February/2017:15:17:54 -0500] deveair /cgi-bin/devair_brad/item-data.html Attempted database update without permission, table=google_feed key=001479-45.



Here is my file:



[set DoSomething]

[perl table=google_feed]

my $db = $Db{google_feed};

my $key = item_id;

my %opt = ( dml => 'update');

my %columns = (title => $CGI->{title},

description => $CGI->{description},

item_condition => $CGI->{item_condition},

price => $CGI->{price},

availability => $CGI->{availability},

link => $CGI->{link},

image_link => $CGI->{image_link},

color => $CGI->{color},

shipping => $CGI->{shipping},

shipping_weight => $CGI->{shipping_weight});

$db->set_slice([\%opt, $key], \%columns);

return;

[/perl]

[/set]



With these as my form variables:



<form method="POST" action="[area item-data]" enctype="multipart/form-data" name="item_editor" autocomplete="off">



<input type="hidden" name="mv_session_id" value="[data session id]">

<input type="hidden" name="mv_click" value="DoSomething">

<input type="hidden" name="mv_nextpage" value="item-data">

<input type="hidden" name="mv_action" value="return">

<input type="hidden" name="itemID" value="[item-pos 0]">



Of course now I cant get the update script to execute.

Steve Bronson
Air Delights, Inc.
http://www.airdelights.com
steve@airdelights.com
Phone: 1-800-440-5556
Fax: 1-503-643-8224

Air Delights, Inc. is a National Distributor of Plumbing Products and Restroom Accessories. Please visit our website at http://www.airdelights.com