Hi,
I'm trying to make FormAuto work, but somehow i keep getting this error:
I've made several forms already like described in the manual, but no luck.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}
MySQL:
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?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 ;
Anything i'm missing? I'm not an expert in PHP / Databases.
Thanks in advance!
Cheers,
Xs.