cforms II User Forum

Registration is currently disabled.
Guest

FAQs

Login form protected by Login LockDown.


Lost password?
Advanced Search

— Forum Scope —

  

— Match —

   

— Forum Options —

    

Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
Database Tracking Error
April 19, 2007
4:48 pm
Dave
Guest

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?

April 19, 2007
5:31 pm
Oliver
Munich, Germany
Admin
Forum Posts: 6400
Member Since:
March 6, 2005
Offline

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

Forum Timezone: Europe/Berlin

Most Users Ever Online: 959

Currently Online:
49 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

tracedef: 43

mores: 21

Gyrus: 20

frozenwaste: 18

asuffredini: 15

photoworks: 14

Member Stats:

Guest Posters: 3732

Members: 1463

Moderators: 3

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 5333

Posts: 18693

Newest Members: juredujmovic, dreamkeeper, rajattyagi, wrokaa, lukass

Moderators: Paul (421), cnymike (8), sonika (95)

Administrators: Oliver (6400), Nicky (3)