Forums

hi,
i am using Chronoform 3.1 RC4 in Joomla 1.5
I have created a form in following ways.
before using RC4, i was using RC2 and i created a form in RC2 and copied the codes, changed the div positions and copied it.

Then, Installed RC4 after clearing cache memory, and after that i took form codes and pasted the codes directly and gave a form name and saved it.

After that, I tried the set up for Adding emails to the form as in the Tutorials But while saving, i get the following error

TableChronoContactEmails::store failed - Unknown column 'replytoname' in 'field list' SQL=INSERT INTO `jos_chrono_contact_emails` ( `formid`,`to`,`dto`,`subject`,`dsubject`,`cc`,`dcc`,`bcc`,`dbcc`,`fromname`, `dfromname`,`fromemail`,`dfromemail`,`replytoname`,`dreplytoname`,`replytoemail`, `dreplytoemail`,`enabled`,`params`,`template` ) VALUES ( '4','test@dreambeansconsultants.com','','Business Visa Assesment','','','','','','Web Master','','webmaster@dreambeansconsultants.com','','','','','','1', 'recordip=1\nemailtype=html\nenabled=1\neditor=1\nenable_attachments=1','

KIndly help me to over come the issue....
Thanks in advance

Hi kannansreenivas,

Looks as though you will need to update your database table a little.

Use PHPMyAdmin to look at jos_chrono_contact_emails and add any fields in the list in your post that aren't in the table.

The full create statement for the current version of the table is:

CREATE TABLE  `joomla15c`.`jos_chrono_contact_emails` (
  `emailid` int(11) NOT NULL AUTO_INCREMENT,
  `formid` int(11) NOT NULL,
  `to` text NOT NULL,
  `dto` text NOT NULL,
  `subject` text NOT NULL,
  `dsubject` text NOT NULL,
  `cc` text NOT NULL,
  `dcc` text NOT NULL,
  `bcc` text NOT NULL,
  `dbcc` text NOT NULL,
  `fromname` text NOT NULL,
  `dfromname` text NOT NULL,
  `fromemail` text NOT NULL,
  `dfromemail` text NOT NULL,
  `replytoname` text NOT NULL,
  `dreplytoname` text NOT NULL,
  `replytoemail` text NOT NULL,
  `dreplytoemail` text NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `params` longtext NOT NULL,
  `template` longtext NOT NULL,
  PRIMARY KEY (`emailid`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;

Bob

Hellow sir,

I have not created any database....
I just created a form only and as second step, i tried to attach a mail.

And I created another test form also, and that too shows same result...

I have never gone to databases.

KIndly check more.. If needed, i shall send a pass and login id

Further, this error came after i upgraded to RC4. The reason for upgradation was as follows.
I was using previous vertion, and i remember you said some bugs in that vertion. and in chronoengine site also, i see kindly do not complain about issues if you are using older vertion and they recoment rc4.
My issue was I set form , set email set up, but i did not receive email.
So I desided to check with RC4 and then complaint if any problem persists.

And In RC4, I could not set up even email and error comes...

This is the Situation
Thank you

Hi kannansreenivas,

Well that's all great - but if that's the error you are getting you still need to update the database table to work with the latest release of ChronoForms.

Bob

Dear Sir,
Kindly mention step by step,
what what i have to do?

Hi kannansreenivas,

Please see my earlier post.

Bob

This is the present stage after i insert the fields that were not in there

-- phpMyAdmin SQL Dump
-- version 2.11.9.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 18, 2009 at 08:39 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `dream_jo151`
--

-- --------------------------------------------------------

--
-- Table structure for table `jos_chrono_contact_emails`
--

CREATE TABLE IF NOT EXISTS `jos_chrono_contact_emails` (
`emailid` int(11) NOT NULL auto_increment,
`formid` int(11) NOT NULL,
`to` text NOT NULL,
`dto` text NOT NULL,
`subject` text NOT NULL,
`dsubject` text NOT NULL,
`cc` text NOT NULL,
`dcc` text NOT NULL,
`bcc` text NOT NULL,
`dbcc` text NOT NULL,
`fromname` text NOT NULL,
`dfromname` text NOT NULL,
`fromemail` text NOT NULL,
`dfromemail` text NOT NULL,
`replytoname` text NOT NULL,
`dreplytoname` text NOT NULL,
`replytoemail` text NOT NULL,
`dreplytoemail` text NOT NULL,
`enabled` tinyint(1) NOT NULL,
`params` longtext NOT NULL,
`template` longtext NOT NULL,
PRIMARY KEY (`emailid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `jos_chrono_contact_emails`
--

I DONT KNOW HOW TO SET AUTO_INCREMENT = 64 AND DEFAULT CHARSET=utf8

KINDLY HELP HOW TO DO THAT TOO... IF THAT NOT DONE WILL IT ADVERSLY EFFECT FORM??

Hi kannansreenivas,

Excellent :-) The autoincrement shouldn't make any difference. It's just the number of records you have in the table at the moment.

Does the form now save OK?

Bob

The Present Situation is as follows.

1. I could save the email set up
2. I set mail sending to yes ( as usual)

But what i see is that
1. Form not validating ( All colums are set as compulsary ) but though not selected, the form get submitted.
2. Mail not receiving on submission.

I checked with completing all fields and completing little fields.

mail ids given are as follows :

to [email]mail1@samedomain.com[/email]
from [email]mail2@samedomain.com[/email]
KIndly help more

Hi kannansreenivas,

Please post a link to the form, and trun DeBug on in the General Tab.

Bob

Result of Debug made after submitting form is as follows.

( i have not entered any field and all kept blank and hit submit) Actually, i might have get validations but didnt came and debug result as follows

1. Form passed first SPAM check OK
2. Form passed the submissions limit (if enabled) OK
3. Form passed the Image verification (if enabled) OK
4. Form passed the server side validation (if enabled) OK
5. $_POST Array: Array ( [bva_select_3] => [bva_text_4] => [bva_text_5] => [bva_select_6] => [select_8] => [select_9] => [bva_select_7] => [bva_select_10] => [bva_text_19] => [bva_text_14] => [bva_text_15] => [bva_text_16] => [bva_text_23] => [bva_text_18] => [bva_text_20] => [bva_text_22] => [bva_select_25] => [bva_select_24] => [bva_select_27] => [bva_select_28] => [bva_text_30] => [bva_text_31] => [bva_text_32] => [bva_text_33] => [bva_text_34] => [bva_text_36] => [bva_text_37] => [bva_text_44] => [bva_text_46] => [bva_text_49] => [fb73ddbe457cb532501b8f2e3156716e] => 1 )
6. $_FILES Array: Array ( )
7. Form passed the plugins step (if enabled) OK
8. An email has been SENT successfully from (Web Master)webmaster@dreambeansconsultants.com to [email]test@dreambeansconsultants.com[/email]
9. Debug End

I am mailing you a superadmin username and pass so that you can check..... i can not waste time on this issue as it may harm me a lot as it may be the couse i could not complete project

Any ways, the form link is also placed here for perusal after keeping debug on
http://dreambeansconsultants.com/index.php?option=com_chronocontact&chronoformname=business_visa

Kindly check your mail and check my site

Thank You

Hi kannansreenivas,

It looks as though you don't have Validation turned on in the Validation tab for your form.

Bob

I turned the validation on....

The result is only first two items came under validation and nothing happened more...

All the fields are required field. but nothing hapens

IMPORTANT MAIL NOT SENDING IN CHRONOFORM . THAT PROBLEM STILL PERSISTS, THOUGH IT SAYS MAIL SEND WHILE DEBUG


KINDLY MAKE A DETAILED CHECK UP NOT THE DEBUG IS OFF BECOUSE TO CHECK MAIL I MADE IT OFF THE PASS AND LOGINS ARE SENT TO YOUR MAIL ALREADY

Hi Kannan,

Your form code has several typos and errors in it (including duplicated ids) and is not valid HTML. One of the results of this is that the <form> tag is not being properly closed.

Please verify your code carefully (HTML Tidy is a good tool to help with this.)

Bob

PS Please do not shout here - all caps are not required.

PPS My role here is to support ChronoForms users - not to debug your coding. If you post in the forums I will try and help - but sending me extra emails and PMs will not get you any more or faster help.

Sorry for the Troubles and inconvenience.. Sorry..

Let me state here the steps followed.
1. I first deleted the entire form and created a new one through wizard.
2. email set ups made, enables mail sending, enables chronoform css, enabled validation.
3. But the Mail Not sending.
4. Checked by keeping dbug on, everything is fine
(Debug Result quoted here for referance )

1. Form passed first SPAM check OK
2. Form passed the submissions limit (if enabled) OK
3. Form passed the Image verification (if enabled) OK
4. Form passed the server side validation (if enabled) OK
5. $_POST Array: Array ( [select_2] => Mr. [text_3] => fghh [text_5] => rtyry [select_7] => 1 [select_8] => Jan [select_9] => 1954 [select_10] => Country1 [select_11] => Country1 [text_12] => rtyry [text_13] => rtyry [text_14] => rtytry [text_15] => 564565 [text_16] => 6476 [text_17] => 456456 [text_18] => 456456 [text_21] => 45646 [select_22] => Single [select_23] => Basic [select_25] => IELTS [select_26] => Academic [text_25] => 455456 [text_26] => 456456 [text_27] => 456456 [text_28] => 456456 [text_29] => 456456 [select_30] => Advanced Diploma [text_31] => [email]ka@kan.com[/email] [text_32] => [radio0] => YES [radio1] => NO [radio2] => YES [radio3] => NO [radio4] => YES [radio5] => NO [radio6] => YES [text_41] => 544 [radio7] => NO [radio8] => YES [text_45] => klkjgkghjkjk [01cdbe477f3502c0ec9aaeed3863e728] => 1 )
6. $_FILES Array: Array ( )
7. Form passed the plugins step (if enabled) OK
8. An email has been SENT successfully from (Web Master)webmaster@dreambeansconsultants.com to [email]test@dreambeansconsultants.com[/email]
9. Debug End

New Form link is given below and now the debug is kept on for checking purpose
http://dreambeansconsultants.com/index.php?option=com_chronocontact&chronoformname=business_visa

( While creating this time, i have not changed any name except lable. When I create another form in same way, in same site, will it effect adversely or not OR can I create many forms in the same way in same domain?)

I have attached the code created by chronoform in a text file[attachment=0]data.txt[/attachment]

I need to create more country names there in. Can I create it thorough coding or am i have to edit wizard and enter separately?

Thanks in advance and sorry for the inconvenience

Hi Kanaan,

That's much better - the form code looks good and the Debug looks exactly as it should.

If you get the message 'Email sent Successfully' then Joomla has told ChronoForms that it has sent the message and received no errors back. There are lots of places that this can go wrong unfortunately :-(

You can create your country lists by pasting in all the options (but make sure that you get the quotes in the correct places). Or you can use PHP to generate the list from an array of country names - this way you can use the same array twice (you can even keep the list in a separate file and include it if you like).
Bob

HI Gray Head,

I checked the same issue posted by another person and you gave some guidelines to check up by giving various ids except hot mail as in case of hot mail some one reported some error.

I took that guidelines and checked with changing to field to my gmail ID

Ohhhhhh !!!! I received the form in the same movement .... and I think i create a gmail id and redirect the mails in that to the customers mail id
But the mail details shows like this

<webmaster@dreambeansconsultants.com>
to [email]kannan.sreenivas@gmail.com[/email]
date Sun, Apr 19, 2009 at 7:56 PM
subject Business Visa Assesment
mailed-by srv2.onetouchsupport.com

What is this srv2.onetouchsupport.com ? Any Idea?

( Iremember before I come to know about Chronoforms, i was using qcontacts, and in that too, if the to field is of the same domain, mail did not sent)
But only One clarification needed.

In the result mail, In case of Radio Buttons, I get the result as follows.

1. Do you have a total of at least four years experience managing one or more business or qualifying investments on a day to day basis?
YES YES
YES NO
2 Do you or your partner own and operate your own business AND possess at least NZD$150,000 to invest?
NO YES
NO NO

Is there any way like that only the what selected appear in mail?

Further I request the developers of this Great Forum and modules to check the issue with the mail id in to field.

Thank you for great support

Hi Kannan,

Great, glad it's working OK.

I don't know what onetouchsupport.com is - perhaps the service your ISP uses for mailing?

Mail behaviour is very dependent on ISP's nto just yours but the recipient's and sometimes places in between too. Most of the time I have no problem mailing from my test site with a local mails erver, or from my live sites to any email address. But many users here report problems with sending to some domains (like hotmail) and sometime same domain addresses. I think this depends mostly on the hosting service - if they have a good reputation most mails get through; if it's a cheap service, or one that has let some spammers use it before, then the filters are much tougher.

For the radio buttons try putting in your email template

2 Do you or your partner own and operate your own business AND possess at least NZD$150,000 to invest? {radio2}

Check the correct number to go with the question.

check the issue with the mail id in to field.

I don't understand this issue - please can you explain?


Bob