Forums

Hi
I have been using an older version of ChronoForms earlier and I have never been able to send the results via email. Now, I have decided to upgrade and try again - and: alas - it dues not even save in the database anymore...

Here my data: I am running Joomla 1.0.15, the latest version of Chrono forms for this version. Joomla is configured to use usr/sbin/sendmail
I have had my hosting service checking out the functionality of sendmail, and they claim it's allright.

When I turn debug on, it claims that the message has been sent, but it never arrives...
Unfortunately, as mentionaed above, even the data are not stored in the table anymore. BTW. does ver. 2.3.9 create the results table automatically?

I would appreciate your help,
Thanks
Manfred


This is the code of my form:

*****************************************************
<table border="0" width="90%" id="table1">
<tr>
<td width="14%" bgcolor="#CCCCCC">Name</td>
<td width="77%" bgcolor="#FFFFCC">
<input type="text" name="name" size="57"></td>
</tr>
<tr>
<td width="14%" bgcolor="#CCCCCC">Email</td>
<td width="77%" bgcolor="#FFFFCC">
<input type="text" name="email" size="39"></td>
</tr>
<tr>
<td width="14%" bgcolor="#CCCCCC">Must be received by</td>
<td width="77%" bgcolor="#FFFFCC">
<input type="text" name="received_by" size="20"></td>
</tr>
<tr>
<td width="14%" bgcolor="#CCCCCC">BOOK</td>
<td width="77%">
<table border="0" width="100%" id="table2">
<tr>
<td width="144" bgcolor="#CCCCCC">Author</td>
<td bgcolor="#FFFFCC">
<input type="text" name="book_author" size="45"></td>
</tr>
<tr>
<td width="144" bgcolor="#CCCCCC">Title</td>
<td bgcolor="#FFFFCC">
<input type="text" name="title" size="45"></td>
</tr>
<tr>
<td width="144" bgcolor="#CCCCCC">Place of Publication</td>
<td bgcolor="#FFFFCC">
<input type="text" name="place" size="45"></td>
</tr>
<tr>
<td width="144" bgcolor="#CCCCCC">Publisher</td>
<td bgcolor="#FFFFCC">
<input type="text" name="publisher" size="45"></td>
</tr>
<tr>
<td width="144" bgcolor="#CCCCCC">Year</td>
<td bgcolor="#FFFFCC">
<input type="text" name="book_year" size="5"></td>
</tr>
<tr>
<td width="144" bgcolor="#CCCCCC">ISBN</td>
<td bgcolor="#FFFFCC">
<input type="text" name="ISBN" size="15"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="14%" bgcolor="#CCCCCC">JOURNAL</td>
<td width="77%">
<table border="0" width="100%" id="table3">
<tr>
<td width="18%" bgcolor="#CCCCCC">Journal Title</td>
<td bgcolor="#FFFFCC" width="80%">
<input type="text" name="journal_title" size="45"></td>
</tr>
<tr>
<td width="18%" bgcolor="#CCCCCC">Article or Essay Title</td>
<td bgcolor="#FFFFCC" width="80%">
<input type="text" name="aticle_title" size="45"></td>
</tr>
<tr>
<td width="18%" bgcolor="#CCCCCC">Author</td>
<td bgcolor="#FFFFCC" width="80%">
<input type="text" name="article_author" size="45"></td>
</tr>
<tr>
<td colspan="2">
<table border="1" width="100%" id="table4">
<tr>
<td bgcolor="#CCCCCC">Year  </td>
<td bgcolor="#FFFFCC">
<input type="text" name="journal_year" size="5"></td>
<td bgcolor="#CCCCCC">Volume</td>
<td bgcolor="#FFFFCC">
<input type="text" name="journal_volume" size="5"></td>
<td bgcolor="#CCCCCC">Pages</td>
<td bgcolor="#FFFFCC">
<input type="text" name="journal_pages" size="5"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<p><input type="submit" value="Submit" name="B1"></p>
*****************************

Hi Manfred,

Your form code looks fine, Chronoforms will not save data automatically, you should first create table for the form through the form management, then data will get saved!

if Joomla says email send then it should be sent, I assume that you don't have any data in the Replyto Email or name fields and also nothing in the special fields tab, correct ?

Cheers

Max

Hi Max
thanks for your quick response.
Unfortunately it seems not to be so simple:

When I create the form with a completely new name, filling in all the relevant and required text boxes on the general and special fields tab, I get immediately the "show saved data" link in the overview of forms. When I ask to create the table, it tells me the table has already been created...
But there is nothing...

The debug message tells me still that the mail has been sent:

_POST: Array ( [name] => Name [email] => [email]mlemke@newbold.ac.uk[/email] [received_by] => date [book_author] => [title] => [place] => [publisher] => [book_year] => [ISBN] => [journal_title] => [aticle_title] => [article_author] => [journal_year] => [journal_volume] => [journal_pages] => [B1] => Submit )
Case 1: Use table layout
E-mail: 'Yes' custom
Email sent
E-mail message
From: Name [mlemke@newbold.ac.uk]
To: [email]mlemke@newbold.ac.uk[/email], [email]mlemke@newbold.ac.uk[/email]
Subject: Document Delivery Request

name Name
email [email]mlemke@newbold.ac.uk[/email]
received_by date
book_author
title
place
publisher
book_year
ISBN
journal_title
aticle_title
article_author
journal_year
journal_volume
journal_pages
B1 Submit

Any ideas?

Manfred

Hi manni,

This all looks OK. The 'Email Sent' message says that ChronOforms has passed the email to Joomla and Joomla hasn't returned any error messages. Usually this means that it's been passed to the mailserver OK.

But you have identical 'to' and 'from' addresses and it's quite possible that your ISP has decided that this must be a mistake and dumped the email. Put a different address in one field - a gmail address is usually good for testing.

The 'table already created message may mean just that - check in PHPMyAdmin for a table with a name like jos_chronoforms_N - where N is the id of your form (visible in the Forms Manager). If there is one then drop it from the database.

Bob

Hi manni,

regarding the table, you can also check the form and click "delete table" and see if this fixes it!

Hi guys
Thank you very much for your quick and good responses. Many commercial software provider could learn from you!

Now, for the table. I could resolve the problem by deleting the table and re-creating it. Really strange that it was associating itself with a new form. Anyway, that's done and ok.

Not so for the mailing. I made the changes suggested, sent "from" and "to" to different email addresses, but nothing happens.

Now, I raised one question also with my hosting company, but I'd like to do this here as well: We don't use any email services on the server. I don't know if there is any mail service (like SMTP) running - I have definitely not configured any. I am not aware how sendmail works, therefore, I can't think of any reason.

There may be another way to resolve this. The hosting company offers a range of CGI mailing scripts, such as CGI Email, and Matt's FormMail. Could I use them through ChronoForms?

Cheers
Manni

Hi manni,

FAQ 36 has some suggestions about checking the mail setup. It has to be configured in the Joomla Global Configuration - one of the setups there should work with your ISP. You shouldn't need a mailing script as the Joomla mailer does pretty much the same thing.

Bob