[ic] database issue

[Gert van der Spoel]

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 at icdevgroup.org [mailto:interchange-users-bounces at icdevgroup.org] On Behalf Of Steve Bronson
Sent: Friday, February 10, 2017 18:40
To: interchange-users at 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 at 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.icdevgroup.org/pipermail/interchange-users/attachments/20170211/0a220537/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ~WRD000.jpg
Type: image/jpeg
Size: 823 bytes
Desc: not available
URL: <http://www.icdevgroup.org/pipermail/interchange-users/attachments/20170211/0a220537/attachment.jpg>