Re: database issue

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: [email protected] [mailto:[email protected]] On Behalf Of Steve Bronson
Sent: Friday, February 10, 2017 18:40
To: [email protected]
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
[email protected]
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

_______________________________________________
interchange-users mailing list
[email protected]
http://www.icdevgroup.org/mailman/listinfo/interchange-users