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.
Bookmarks