AutoForm Fatal Error

Hi,

I'm trying to make FormAuto work, but somehow i keep getting this error:

Code:

---

Fatal error: Uncaught exception Exception with message Query error: Unknown column 'Naam' in 'field list' (INSERT INTO Contact_Form (tstamp, Naam, Email) VALUES (1254157378, 'Myname', 'myEmail@email.com')) thrown in /usr/local/www/vhosts/mano-id.com/httpdocs/system/libraries/Database.php on line 519

#0 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/Form.php(408): Database_Statement->execute()
#1 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/Form.php(201): Form->processFormData(Array)
#2 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/Hybrid.php(151): Form->compile()
#3 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/Form.php(72): Hybrid->generate()
#4 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/ContentModule.php(70): Form->generate()
#5 /usr/local/www/vhosts/mano-id.com/httpdocs/system/libraries/Controller.php(362): ContentModule->generate()
#6 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/ModuleArticle.php(156): Controller->getContentElement('90')
#7 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/Module.php(126): ModuleArticle->compile()
#8 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/ModuleArticle.php(69): Module->generate()
#9 /usr/local/www/vhosts/mano-id.com/httpdocs/system/libraries/Controller.php(295): ModuleArticle->generate(false)
#10 /usr/local/www/vhosts/mano-id.com/httpdocs/system/libraries/Controller.php(182): Controller->getArticle('50', false, false, 'main')
#11 /usr/local/www/vhosts/mano-id.com/httpdocs/system/modules/frontend/PageRegular.php(68): Controller->getFrontendModule('0', 'main')
#12 /usr/local/www/vhosts/mano-id.com/httpdocs/index.php(187): PageRegular->generate(Object(DB_Mysql_Result))
#13 /usr/local/www/vhosts/mano-id.com/httpdocs/index.php(288): Index->run()
#14 {main}

---

I've made several forms already like described in the manual, but no luck.

MySQL:

Code:

---

CREATE TABLE `tl_form_contact` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `Naam` varchar(255) NOT NULL default '',
  `Email` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

---

I've looked at the database and it seems to look al fine. The table is created and has the proper fields, but somehow it doesn't write the form input to the database. Maybe some wrong definition somewhere?

Anything i'm missing? I'm not an expert in PHP / Databases.

Thanks in advance!

Cheers,
Xs.

I've not used Form Auto, but

Quote:

---

INSERT INTO Contact_Form

---

You're inserting data to a table called Contact_Form.
Does such a table exist? Maybe this is part of FormAutos workings.

Also, the database is saying it cannot find the field 'Naam' in a table called 'field list'

Quote:

---

Unknown column 'Naam' in 'field list'

---

, yet your sql table is called 'tl_form_contact', which doesn't match.

Where does the name 'field list' come from?

Sorry, my mistake, got confused with the forms. Added quite a few already to see if some format works or not. so it's 2 different logs ;)

And just when i was typing my whole story i got it figured out.

It was a little confusing in the manual. I added the Form first, added the fields, then set to auto form, which doesn't seem to work ;) FIRST set it to Auto, then add the fields. Got confused because i wasn't able to add the "required" email field to the reply email settings, since i didn't add any fields yet. But i need to add that later.

Also in the manual it says:

Quote:

---

Use the Form Generator and create a Registration Form using the form generator
* Change the Form Type to [Automatic Form]

---

Which made me think, first make the form, then set it to Auto.

Thanks anyway, it did help my personal process i guess ;)

The tags for the email confirmation don't seem to work though. They just print nothing.

I'm using the EFG module, which seem to work fine. Too bad about the filter options though.

But i've read on this forum i'm not the only one where this is an issue. So maybe it's solved in a future release?

what do you mean "tags" for the e-mail confirmation? Of course it works, I use it every single day. I include 2 confirmation e-mail samples, but you have to use the EXACT fields of your form, e.g. {{form::firstname}}

Also, when you change the form AFTERWARDS to automatic form, you will be required to save the form again, because at that point it stores the fields into the database table.

There is also a BUG that I have been unable to trace, where you copy a field and then it doesn't do it right and renames/copies a field but keeps a copy of the old field in the database. You can also save each field again and then it will ensure all the fields are properly created.

Quote:

---

Originally Posted by thyon

what do you mean "tags" for the e-mail confirmation? Of course it works, I use it every single day. I include 2 confirmation e-mail samples, but you have to use the EXACT fields of your form, e.g. {{form::firstname}}

---

Hi Thyton,

I've used the exact templates at the start to keep things save, i also understand to use the exact name (firstname, email, company etc). But no luck. Maybe it's a local conflict (probably, since it works for other users). But i've not been able to fix it yet.

Will let you know if i found the bug, but it works with the EFG module as well now using the tags.

just remember that formauto and EFG are incompatible and should never be installed on the same installation.