cforms II User Forum » delicious:days

April 29, 2007
6:37 pm

webbite

Guest

1

Quote

In 3.4 version tracking data the admin can view message field.

Now 3.5 version added the new feature than permits selective deletion of submission entries but i can't see the message content too?

thanks

April 29, 2007
6:51 pm

Oliver

Munich, Germany

Admin

Forum Posts: 6398

Member Since:
March 6, 2005

Offline

2

Quote

What do you see instead?

The only other change is, that I included an extra field in the tracking tables, to support MySQL server that wouldn't properly sort the fields.

When you upgraded to 3.5, have you disabled and then re-enabled the plugin? This should have created this extra field – without doing this, you may encounter a SQL and display errors.

If you started the DB tracking from scratch, it should've worked right away.

If it still doesn't show any form fields (and user input), send me a sceenshot.

** FAQS ** cforms home page ** donations

April 29, 2007
7:29 pm

webbite

Guest

3

Quote

This is my screenshot.

this is the sequence of my upgrade 3.4 to 3.5:

1. delete tracking table entries

2. disable tracking feature

3. backup my formdata personalizzation

4. click on "delete *all* form data" button for sicure erase

5. DELETE contactforms directory via ftp

6. upload new contactform (3.5) directory

6bis .$value = $params ['field_' . $i]; line overwriter

7. activate plugin

7bis. ajax disable

7. activate plugin

8. restore personalized formdata backup

9. activate tracking function

Full functionaliting plugin except for this issue. see screenshot

http://www.martinmusic.it/tracking.jpg

[Image Can Not Be Found]

April 29, 2007
8:27 pm

Oliver

Munich, Germany

Admin

Forum Posts: 6398

Member Since:
March 6, 2005

Offline

4

Quote

The steps look mighty fine.

From I can see, I take it that a correct entry is made into $wpdb->cformssubmission, since you've been able to select this specific form subsmission.

What I'd be curious about is, is there any data stored in $wpdb->cformsdata ? Do you have access to your WP tables via phpMyAdmin to look?

** FAQS ** cforms home page ** donations

April 29, 2007
8:33 pm

webbite

Guest

5

Quote

via phpamdin all entries field are correct compiles. see screeshot.

I can't see the "gggggggg" message entries in wp-admincform panel

http://www.martinmusic.it/tracking2.jpg

also, what mean

Include Tracking ID in
form submissions?

and

Additional text for the subject line

in the Database Input Tracking settings?

April 29, 2007
8:41 pm

Oliver

Munich, Germany

Admin

Forum Posts: 6398

Member Since:
March 6, 2005

Offline

6

Quote

I see the problem. It's related to sub_id which should for all entries be "1" (it should have shown at least Nome: though, for this entry). I guess it has to do with the SQL command LAST_INSERT_ID(). It seems that your SQL server get's confused with the two auto_increment fields in the two cforms tables.

I'll send you an email in a few, let's see if we can revert back to the old state which may work better for you.

Include Tracking ID in
form submissions?

Allows the unique form submission ID to be added to the subject line of the auto confirmation or CC: email that goes out to the visitor.

Additional text for the subject line

Let's you configure the looks of it.

** FAQS ** cforms home page ** donations

April 29, 2007
9:01 pm

webbite

Guest

7

Quote

with sub_id manually set to "1" via phpmyadmin i see all correct

my mysql version is 4.0.24

i'm wait for your email.

ps: i try to traslete cforms in Italian via poedit.

1. i create a new catalog loading tha cforms.pot file in poedit.

2. traslate a few line to try functionality in remote

3. load via ftp the .mo file catalog generated under the contactforms directory

4. NO CHANGE NOTHING!

i called the .mo file:

cforms.mo

cforms-it_it.mo

contactforms.mo

but no change anything

I have traslate (in my bad english) some themes but you can show me the way for cforms? thanks a lot.

April 29, 2007
9:16 pm

Oliver

Munich, Germany

Admin

Forum Posts: 6398

Member Since:
March 6, 2005

Offline

8

Quote

The translation file should be named according to the German example: cforms-de_DE.mo. Check your WP_LANG variable in wp-config.php.

Also, have you copied the translation file into your main plugins directory? This is where it should go, not into the cforms directory.

** FAQS ** cforms home page ** donations

April 29, 2007
9:41 pm

webbite

Guest

9

Quote

WOW!!

thanks a lot for support!!!

now the .mo file translate the cforms!!!

and the '$subID' overwrite of LAST_INSERT_ID() resolve my hassle

ALL function correctly work.

for your support my contribute is the italian traslation and i you want a small paypal donation.

send me your paypal-email-accont

:-)

April 29, 2007
9:48 pm

Oliver

Munich, Germany

Admin

Forum Posts: 6398

Member Since:
March 6, 2005

Offline

10

Quote

I'm glad we got it resolved, I'll make sure to add the changes to v.3.6 – this might help more users.

re: paypal – thanks for your kind offer, but your Italian localization of cforms would already be a fine contribution :)

** FAQS ** cforms home page ** donations

April 30, 2007
2:07 am

webbite

Guest

11

Quote

In tracking data can't view message entries?

Oliver solution:

Change these lines (starting both near 531 & 1028) in cforms.php:

before:
        $sql = "INSERT INTO $wpdb->cformsdata
(sub_id,field_name,field_val) VALUES " .
                    "(LAST_INSERT_ID(),'page','$page'),";
after:
        $sql = "INSERT INTO $wpdb->cformsdata
(sub_id,field_name,field_val) VALUES " .
                    "('$subID','page','$page'),";

before:
        foreach ( array_keys($track) as $key )
            $sql .= "(LAST_INSERT_ID(),'$key','$track[$key]'),";

after:
        foreach ( array_keys($track) as $key )
            $sql .= "('$subID','$key','$track[$key]'),";

Essentially, replace LAST_INSERT_ID() with '$subID'.