When I try to enable Database tracking (using cForms 3.22 with WordPress 2.1.2, PHP 4.4.2 and mySQL 4.0.18) I get the following error trying to enable it.
"WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP, email varchar(40) default '', ]
CREATE TABLE wp_cformssubmissions ( id int(11) unsigned auto_increment, form_id varchar(3) default '', date timestamp NOT NULL default CURRENT_TIMESTAMP, email varchar(40) default '', ip varchar(15) default '', PRIMARY KEY (id) )"
Will Database Tracking capture all the data submitted on a Form?
Can I manualy create the tables that cForms is trying to make to get this to run?
March 6, 2005
I think that's already covered in either the FAQs or the comments section on the main plugin page.
Essentially, if your MySQL server complains about the syntax, remove the "default CURRENT_TIMESTAMP" in cforms-global-settings.php (~132) and it should work.
Yes, the tracking feature tracks all fields, except any uploaded files (so far).
Most Users Ever Online: 959
Currently Browsing this Page:
Guest Posters: 3757
Newest Members: juredujmovic, dreamkeeper, rajattyagi, wrokaa, lukass
Moderators: Paul (421), cnymike (8), sonika (95)
Administrators: Oliver (6400), Nicky (3)