CMS Adding additional values

10/04/2012 7:15 am | #1 Steve

Hello,
I've added a field 'pcms2_contents.Status' to the basic database
and when working on the update page "contents_update.php" the following errors are encountered. The goal is to add a simple select list and then update the record via the insert behavior but the errors shown on the screen shot surface.

Using Design Extender 1.1.1
New release so newest files being used.

No changes have been made to the update page.

10/04/2012 9:03 am | #4 Steve

Additional Issue

Hello,
The insert behaviour is not showing in the Server Behavior list. Why is this? What needs to change to make it recognized and allow GUI editing?

Here is the code as found. Note I did remove the blank lines as a test and that still did not allow the insert behavior to show in the Server Behavior list...

php:

<?php 

// WA Application Builder Update

if (isset($_POST["Update"])) // Trigger

{

  $WA_connection = $PowerCMSConnection;

  $WA_table = "pcms2_contents";

  $WA_redirectURL = "".(isset($_GET['returnPage'])?$_GET['returnPage']:"index.php");

  $WA_keepQueryString = false;

  $WA_indexField = "ContentID";

  $WA_fieldNamesStr = "ContentGroup|ContentRefID|ContentValue";

  $WA_fieldValuesStr = "".((isset($_POST["ContentGroup"]))?$_POST["ContentGroup"]:"")  ."" . "|" . "".((isset($_POST["ContentRefID"]))?$_POST["ContentRefID"]:"")  ."" . "|" . "".((isset($_POST["ContentValue"]))?$_POST["ContentValue"]:"")  ."";

  $WA_columnTypesStr = "',none,''|',none,''|',none,''";

  $WA_comparisonStr = "=|=|=";

  $WA_fieldNames = explode("|", $WA_fieldNamesStr);

  $WA_fieldValues = explode("|", $WA_fieldValuesStr);

  $WA_columns = explode("|", $WA_columnTypesStr);

  

  $WA_where_fieldValuesStr = "".((isset($_POST["WADAUpdateRecordID"]))?$_POST["WADAUpdateRecordID"]:"")  ."";

  $WA_where_columnTypesStr = "none,none,NULL";

  $WA_where_comparisonStr = "=";

  $WA_where_fieldNames = explode("|", $WA_indexField);

  $WA_where_fieldValues = explode("|", $WA_where_fieldValuesStr);

  $WA_where_columns = explode("|", $WA_where_columnTypesStr);

  $WA_where_comparisons = explode("|", $WA_where_comparisonStr);

  

  $WA_connectionDB = $database_PowerCMSConnection;

  mysql_select_db($WA_connectionDB, $WA_connection);

  if (!session_id()) session_start();

  $updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);

  $WhereObj = WA_AB_generateWhereClause($WA_where_fieldNames, $WA_where_columns, $WA_where_fieldValues,  $WA_where_comparisons );

  $WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";

  $MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

  if ($WA_redirectURL != "")  {

    if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {

      $WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];

    }

    header("Location: ".$WA_redirectURL);

  }

}

?>

10/04/2012 9:17 am | #5 Steve

I did a comparison of a new Insert against the one that does not show in the Server Behaviors panel:

php:

// WA DataAssist Insert

if (isset($_POST["Update"]) || isset($_POST["Update_x"])) // Trigger

{

  $WA_connection = $PowerCMSConnection;

  $WA_table = "pcms2_contents";

  $WA_sessionName = "SGDinsertID";

  $WA_redirectURL = "";

  if (function_exists("rel2abs")) $WA_redirectURL = $WA_redirectURL?rel2abs($WA_redirectURL,dirname(__FILE__)):"";

  $WA_keepQueryString = false;

  $WA_fieldNamesStr = "ContentGroup|ContentRefID|ContentValue|Status";

  $WA_fieldValuesStr = "".((isset($_POST["ContentGroup"]))?$_POST["ContentGroup"]:"")  ."" . $WA_AB_Split . "".((isset($_POST["ContentRefID"]))?$_POST["ContentRefID"]:"")  ."" . $WA_AB_Split . "".((isset($_POST["ContentValue"]))?$_POST["ContentValue"]:"")  ."" . $WA_AB_Split . "".((isset($_POST["selStatus"]))?$_POST["selStatus"]:"")  ."";

  $WA_columnTypesStr = "',none,''|',none,''|',none,''|none,none,NULL";

  $WA_fieldNames = explode("|", $WA_fieldNamesStr);

  $WA_fieldValues = explode($WA_AB_Split, $WA_fieldValuesStr);

  $WA_columns = explode("|", $WA_columnTypesStr);

  $WA_connectionDB = $database_PowerCMSConnection;

  mysql_select_db($WA_connectionDB, $WA_connection);

  @session_start();

  $insertParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);

  $WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";

  $MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

  $_SESSION[$WA_sessionName] = mysql_insert_id($WA_connection);

  if ($WA_redirectURL != "")  {

    $WA_redirectURL = str_replace("[Insert_ID]",$_SESSION[$WA_sessionName],$WA_redirectURL);

    if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {

      $WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];

    }

    header("Location: ".$WA_redirectURL);

  }

}

?>

Is there added functionality in the default that is hand coded and not recognized by the current version of Data Bridge?

I can manually transfer the new Status insert value etc but it would be nice if all the files were editable in the various behaviors.

10/04/2012 10:44 am | #6 Jason ByrnesWebAssist

it's the line for the redirect URL causing the issue.

change:

php:

$WA_redirectURL = "".(isset($_GET['returnPage'])?$_GET['returnPage']:"index.php");

to:

php:

$WA_redirectURL = "".(isset($_GET['returnPage'])?$_GET['returnPage']:"index.php")."";

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

CMS Adding additional values

10/04/2012 7:15 am | #1 Steve