Stored Data

I can't get data to show up in the Table I created for a form. The emails are showing up fine.

My form is located here

When I created the table all of the fields showed up and I checked the relevant boxes.

Here is the AutoGenerated information:

<?php 
	global $database;
	
$database->setQuery( "INSERT INTO #__chronoforms_1 VALUES  (
'' , '". date('Y-m-d')." - ".date("H:i:«»s"«»)."', '".$_SERVER['REMOTE_ADDR']."' , '".$_POST['FName']."' , '".$_POST['LName']."' , '".$_POST['email']."' , '".$_POST['Seminar']."' , '".$_POST['Church']."');" );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>
";
}
?>

Hope there is enough information here, but I would be happy to email you any login information that would help as well.

Thanks!
Bart<br><br>Post edited by: GreyHead, at: 2008/01/03 18:43

Hi Bart,

I wonder if this is the addslashes problem that I encountered yesterday (see a post in the Suggestions forum).

Please will you click the #Backup Form' icon in the Form Manager and send me the cfbak copy of your form so that I can have a closer look.

Bob

Where should I send the file?

Thanks!<br><br>Post edited by: mediaphish, at: 2008/01/03 18:45

Hi Bart,

You should be able to attach it here or send it to the email address in my sig.

Bob

Email sent. 😉

Hi Bart,

Hmmm form saves OK for me.

One more thing to try, please delete your table (assuming that there's no critical data in it yet). The remove the AutoGenerated text field and recreate the table setting the fields to VarChar rather than LongText. That will be plenty big enough for your table and there is a problem if all the fields are LongText.

If this doesn't work then we'll need to take a closer look at the MySQL that's being generated.

Bob

You'll have to forgive me. How do I delete the table? Do I need to go into MySQL? If so, what am I looking for?

Found it, deleted it and am rebuilding the table. Will attempt another submission and let you know what happens.

Thanks!

Here are the results of the debug. Not sure if it helps at this point?

_POST: Array ( [FName] => Bart (Test 3) [LName] => Paden [email] => [email]bart@softwarepartners.biz[/email] [Seminar] => THE GIFT OF LEADERSHIP [Church] => Joplin, MO - Christ's Church [submit] => send )
Case 1: Use table layout
E-mail: 'Yes' custom
Email sent
E-mail message

From: Bart (Test 3) [bart@softwarepartners.biz]
To: [email]info@jubileestl.org[/email], [email]admin@jubileestl.org[/email]
Subject: Clear Vision Seminar Signup
FName Bart (Test 3)
LName Paden
email [email]bart@softwarepartners.biz[/email]
Seminar THE GIFT OF LEADERSHIP
Church Joplin, MO - Christ's Church

It didn't work. Even built the form again from scratch. I'm emailing you login information for Joomla as well as MySQL. If there is anything more you can do I would really appreciate it.

Hi Bart,

Just emailed you - seems to be working OK now.

Bob

Thanks again Bob!