Not showing a 'thanks' page after email triggered

8/02/2011 3:25 pm | #1 PaulBeta Tester

Hi,

I'm using DA and UE4 to insert a new members record and email a confirmation back to the new member on completion.

All works fine right up-until the point where UE sends the email, but hen fails to load my thanks.php page. I just get a blank page as if its stalled.

Attached is the register page.
Would it be possible for you to take a look to see if ive missed something?

Thanks, Paul.

Attached Files

8/03/2011 8:19 am | #2 Jason ByrnesWebAssist

most likely, the problem is the blank lines between code blocks at line 114 and 117. lines 113 - 118 are:

php:

?>



<?php require_once("../webassist/email/mail_php.php"); ?>

<?php require_once("../webassist/email/mailformatting_php.php"); ?>



<?php

it should be:

php:

?>

<?php require_once("../webassist/email/mail_php.php"); ?>

<?php require_once("../webassist/email/mailformatting_php.php"); ?>

<?php

8/03/2011 2:53 pm | #3 PaulBeta Tester

Thanks for your response.

I removed the space, but made no difference.

Prior to using DA to insert a new record, i was using DW's insert script, as per below. That worked fine and returned the 'thanks.php' page fine

php:

<?php
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "WAATKRegistrationForm")) {
  $insertSQL = sprintf("INSERT INTO member_tbl (mem_email, mem_password, mem_app_dated, mem_fname, mem_lname, mem_type, mem_active, mem_conf_id, mem_active_flag, mem_terms, mem_host, mem_browser, mem_referrer, mem_picLimit) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['mem_email'], "text"),
                       GetSQLValueString($_POST['mem_password'], "text"),
                       GetSQLValueString($_POST['mem_app_dated'], "text"),
                       GetSQLValueString($_POST['mem_fname'], "text"),
                       GetSQLValueString($_POST['mem_lname'], "text"),
                       GetSQLValueString($_POST['mem_type'], "int"),
                       GetSQLValueString($_POST['mem_active'], "int"),
                       GetSQLValueString($_POST['mem_conf_id'], "text"),
                       GetSQLValueString($_POST['mem_active_flag'], "int"),
                       GetSQLValueString($_POST['mem_terms'], "int"),
                       GetSQLValueString($_POST['mem_host'], "text"),
                       GetSQLValueString($_POST['mem_browser'], "text"),
                       GetSQLValueString($_POST['mem_referrer'], "text"),
                       GetSQLValueString($_POST['mem_picLimit'], "int"));

  mysql_select_db($database_Crazyhomes, $Crazyhomes);
  $Result1 = mysql_query($insertSQL, $Crazyhomes) or die(mysql_error());
}

mysql_select_db($database_Crazyhomes, $Crazyhomes);
$query_RegType = "SELECT * FROM mem_type WHERE mem_type.active=1";
$RegType = mysql_query($query_RegType, $Crazyhomes) or die(mysql_error());
$row_RegType = mysql_fetch_assoc($RegType);
$totalRows_RegType = mysql_num_rows($RegType);
?>

My initial problem started just as soon as i switched the DW script for the DA version. everything else on the page was untouched

The registration page completes all the tasks right through to sending the email correctly, so i'm puzzled as to why the problem is occurring at some point between the email send and executing the $GoToPage = "thanks.php"; line, when i changed the insert script!

8/04/2011 6:45 am | #4 Jason ByrnesWebAssist

usually, if the redirect is not working it is due to a php error, add the following code at line 1 to turn error reporting on:

php:

<?php

error_reporting(E_ALL);

ini_set('display_errors','on');

?>

8/06/2011 3:56 am | #5 PaulBeta Tester

Jason, thanks for hint.

following is page output:

Fatal error: Cannot redeclare wa_ab_getloopedfieldname() (previously declared in /home/www/crazyplumhomes.co.uk/WA_DataAssist/WA_AppBuilder_PHP.php:11) in /home/www/crazyplumhomes.co.uk/webassist/database_management/wa_appbuilder_php.php on line 19

Im not making much sense of it!
Any ideas?

Thanks, Paul

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Not showing a 'thanks' page after email triggered

8/02/2011 3:25 pm | #1 PaulBeta Tester