cforms II User Forum

Registration is currently disabled.
Guest

FAQs

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
In tracking data can't view message entries?
April 29, 2007
6:37 pm
webbite
Guest

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: 6400
Member Since:
March 6, 2005
Offline

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.

April 29, 2007
7:29 pm
webbite
Guest

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: 6400
Member Since:
March 6, 2005
Offline

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?

April 29, 2007
8:33 pm
webbite
Guest

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: 6400
Member Since:
March 6, 2005
Offline

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.

April 29, 2007
9:01 pm
webbite
Guest

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: 6400
Member Since:
March 6, 2005
Offline

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.

April 29, 2007
9:41 pm
webbite
Guest

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: 6400
Member Since:
March 6, 2005
Offline

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

April 30, 2007
2:07 am
webbite
Guest

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

 

Forum Timezone: Europe/Berlin

Most Users Ever Online: 959

Currently Online:
29 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: 3708

Members: 1463

Moderators: 3

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 5307

Posts: 18665

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

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

Administrators: Oliver (6400), Nicky (3)