cforms II Support Forum
 
Current User: Guest Login Register
Please consider registering


Register? | Lost Your Password?

Search Forums:


 






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

cforms II Support Forum Troubleshooting cformssubmissions & cformsdata are not created

cformssubmissions & cformsdata are not created
Print this Post
Page:   1   Add a New Topic Reply to Post
Post
Guest

M3

9:06 pm May 24, 2008
  Quote and Reply
1
    • The browser used: Mozilla Firefox
  • cforms version: 8.4.2
  • Your WordPress version: 2.5.1

[desc]: Hi,

Thanks for this plugin. It is great.

For a special application, I want to use the data. Unfortunately, i can't get them through the tracking. I think the tracking doesn't work and I checked my database : the tables cformssubmissions & cformsdata are not created. Even after validating the data tracking option.

Can you help me to solve this problem ?

Thanks

M3
_
Admin

Oliver

Munich, Germany

posts 6002

9:56 pm May 24, 2008
  Quote and Reply
2

If the tracking tables are not created, you can copy the two CREATE TABLE SQL statements from cforms-global-settings.php and create them in your DB manually.

Sometimes this part can cause issues: DEFAULT CHARSET=utf8you can also try removing it…

** cforms home page   ** donations
Guest

M3

2:10 pm May 25, 2008
  Quote and Reply
3

It works fine ! I created manually the tables wp_cformssubmissions and wp_cformsdata as you suggested in my DB.

Thanks thanks Oliver
Guest

Bridget

11:22 am May 29, 2008
  Quote and Reply
4

Hi, I have also been unable to create these tracking tables.

I am using cforms v8.4.1 and MySQL client version: 4.1.22 (and WordPress 2.5.1)

I managed to create the wp_cformsdata table manually via PHPMyAdmin but when trying to create the wp_cformssubmissions table I get the following MySQL 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 on update CURRENT_TIMESTAMP,
`email` varch

Can anyone give me some pointers?

Cheers.
Admin

Oliver

Munich, Germany

posts 6002

6:30 pm May 29, 2008
  Quote and Reply
5

You can copy & paste the CREATE TABLE construct from cforms-global-settings.php and create the tables manually in your DB/SQL admin area.

There are also other threads covering this.

** cforms home page   ** donations
Guest

Bridget

1:20 am June 2, 2008
  Quote and Reply
6

Thanks Oliver, that is what I tried, and recieved the above SQL error message… Im afraid I don't know much about SQL so am not so good at creating tables manually. I am wondering if there is a conflict with the Create tables construct and the version of MySQL I am running…
Admin

Oliver

Munich, Germany

posts 6002

7:14 am June 2, 2008
  Quote and Reply
7

You may be right, try this or this (removing the evil part).

** cforms home page   ** donations
Guest

Bridget

8:10 am June 2, 2008
  Quote and Reply
8

Thanks for those pointers Oliver – managed to manually add tables and all looks to be working!

Thanks very much for this plugin! :)
No Tags
Page:   1   Reply to Post

Reply to Topic:
cformssubmissions & cformsdata are not created

PLEASE READ THE FAQs FIRST! THANK YOU.

Guest Name (Required):

Guest Email (Required):

NOTE: New Posts are subject to administrator approval before being displayed

Smileys
lol offended sad ??? yell cry frown kiss surprised wink innocent smile oops cool
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
4 + 8    



About the delicious:days Forum

Forum Timezone: Europe/Berlin

Currently Online:
29 Guests

Currently Browsing this Topic:
1 Guest

Membership:

There are 1121 Members
There have been 2266 Guests

There is 1 Admin
There are 3 Moderators

Recent New Members: bbm, gustalves, sgc_02, Menucha, nylandit, pbaerveldt