Save Failed! alert showing even after data is saved

[prasanthkc]

SAVE Failed!
Exception:

Shows above alert while i am saving data. The data is saved, but showing alert. Where can i edit the function gives the alert msg, i tried editing saveFailure() in gt_grid.js included in the plugin module, but nothing happens. Pls help me to resolve the issue asap!!

[onyx]

I am getting this too...

but  just started with this code. However I do know how to modify the Javascript to make it readable.

So replace the gt_grid_all.js with your own uncompacted version may help you to then track and debug, by changing it to be : console.log(function(E,I,A,D,J,K,L,H) at the start, then using Chrome's console to select and copy the entire dump of the file to your own new file, then include that instead.


Specifically, the block calling out this error condition is:
exportGrid:function(A,F,B,C,E){var $=this;if(Sigma.$invoke($,"beforeExport",[A,F,B,C,E,$])!==false){try{A=A||this.exportType;F=F||this.exportFileName;B=B||this.exportURL;C=C||this.jsonParamName||(this.ajax?this.ajax.jsonParamName:Sigma.AjaxDefault.paramName);E="export";if(this.html2pdf&&A=="pdf"){this.gridFormTextarea.name="__gt_html";var _=["<style type=\"text/css\">",this.Ie8("exportable"),"</style>"];this.gridFormTextarea.value=_.join("\n")+"\n"+this.yt2(true)}else{var G=this.getLoadParam();G[this.CONST.action]=E;G[this.CONST.exportType]=A;G[this.CONST.exportFileName]=F;this.gridFormTextarea.name=C;this.gridFormTextarea.value=Sigma.$json(G)}this.gridForm.action=B+(B.indexOf("?")>=0?"&":"?")+"exportType="+A+"&exportFileName="+F;B&&(this.gridForm.submit());this.gridFormTextarea.value=""}catch(D){this.exportFailure({type:A,fileName:F},D)}}},loadFailure:function(A,_){var $=A[this.CONST.exception]||(_?(_.message||""):"");alert(" LOAD Failed! "+"\n Exception : \n"+$)},saveFailure:function(A,_){var $=A[this.CONST.exception]||(_?(_.message||""):"");alert(" SAVE Failed! "+"\n Exception : \n"+$)},exportFailure:function(A,_){var $=A[this.CONST.exception]||(_?(_.message||""):"");alert(" Export "+A.type+" ( "+A.fileName+" ) Failed! "+"\n Exception : \n"+$)}

Godspeed tracking this down!

[onyx]

Found that there is actually no bug in the javascript, but you must be VERY careful about the Controller.php. In particular, wrap each $json-> data in a check, so you are not invalidating the results.

My current working Controller.php follows, but is heavily customised to suit my app.
<?php include_once('mysql.class.php'); // http://www.phpclasses.org/ultimatemysql header('Content-type:text/javascript;charset=UTF-8'); $json=json_decode(stripslashes($_POST["_gt_json"])); $db= new MySQL(true) or die('Cannot connect to MySQL server. Please check settings in mysql.class.php'); global $table; $pars= $json->{'parameters'}; $table_key=''; if (!empty($pars)){ // from the menu links menu.php switch ($pars){ case 'master': include_once('master.php'); $table_key='uid'; break; case 'seeding': include_once('seeding.php'); $table_key='uid'; break; case 'shipping': include_once('shipping.php'); $table_key='uid'; break; case 'growers': include_once('growers.php'); $table_key='code'; break; case 'crops': include_once('crops.php'); $table_key='code'; break; case 'trays': include_once('trays.php'); $table_key='code'; break; default: break; } } else { //default include_once('master.php'); } if($json->{'action'} == 'load'){   $sql = "select * from ".$table ;   //print $sql;   if($db->Query($sql)==FALSE){     $errors .= mysql_error();     print $errors;   }   $handle = $db->Query($sql);   $retArray = array();   while ($row = $db->Row()) {     $retArray[] = $row;   }   $data = json_encode($retArray);   $ret = "{data:" . $data .",\n";   $ret .= "recordType : 'object'}"; //$ret .= $sql; }else if($json->{'action'} == 'save'){   $sql = "";   $params = array();   $errors = "";   if ($json->{'deletedRecords'}){   //deal with those deleted   $Records = $json->{'deletedRecords'};     $deletedRecords = objectToArray2($Records);     foreach ($deletedRecords as $value){     $params[] = $value[$table_key];   }   $sql = "delete from ".$table." where ".$table_key." in (" . join(",", $params) . ")";   if($db->Query($sql)==FALSE){     $errors .= mysql_error();      print $errors;   } } if($json->{'updatedRecords'}){   //deal with those updated   $sql = "";   $updatedRecords = objectToArray2($json->{'updatedRecords'});   foreach ($updatedRecords as $value){    $newarr = $value;      $newarrk = array_keys($newarr);     $last = array_pop($newarrk);   $first = array_shift($newarrk);       $sql = "update ".$table." set ";     foreach($value as $key => $val){ // step thru each  updated record row   if ($key != $first){ // match the key db and input $sql .= " ".$key." = ".MySQL::SQLValue($val, MySQL::SQLVALUE_TEXT)." ";//cleanup for valid sql if ($key != $last) $sql.=", "; } } $sql .=" where ".$first." =".MySQL::SQLValue($value[$first], MySQL::SQLVALUE_TEXT)." "; //echo "Update SQL: $sql";       if($db->Query($sql)==FALSE){         $errors .= $db->Error();          print $errors;       }   } } if ($json->{'insertedRecords'}){   //deal with those inserted   $sql = "";   $insertedRecords = objectToArray2($json->{'insertedRecords'});   foreach ($insertedRecords as $value){     $sql = "insert into ".$table." (";     $count = count($dbfields);     foreach ($dbfields as $key=>$val){ $sql .= " `".$val."` ";//must be single back tick for valid sql if ($key != $count -1) $sql.=","; //misses the last item } $sql .= ") VALUES ("; $count = count($value); if ($count > count($dbfields)) array_shift($value); // remove the first column in the instance there are more values than dbfields - that will happen when there is a $newarr = array_keys($value); $last = array_pop($newarr);     foreach ($value as $key=>$val){ $sql .= MySQL::SQLValue($val, MySQL::SQLVALUE_TEXT);//cleanup for valid sql if ($key != $last) $sql.=","; //misses the last item } $sql .= ")";     if($db->Query($sql)==FALSE){       $errors .= "oops...".$db->Error();       print " SQL:".$sql;     }   }     $ret = "{success : true}"; } } // we could do some checking of the return value here first echo $ret;   function objectToArray2( $object )     {         if( !is_object( $object ) && !is_array( $object ) )         {             return $object;         }         if( is_object( $object ) )         {             $object = get_object_vars( $object );         }         return array_map( 'objectToArray2', $object );     } ?>