problem with french caracter

Problem still here too.
If a need to see a message with caracter I export to Google Spreadsheet live data

Thanks for your help Michael.

It’s me again. I’m sorry to bother you again with this problem, Michael.

This issue is driving me nuts. And I do not really know if its a problem caused by a routine in your plugin or by a change in the core of wordpress. I will post this text hier also in the wordpress support forums. But maybe you can find the solution faster?! I really appreciate your help!

Please have a look at these JPGs I’ve uploaded to my webspace.

1. With Version 3.8.3 my PhpMyAdmin shows this about collation of the cfdb table: latin1_swedish_ci.

2. I query my example data with Version 3.8.3 and the result looks like that.

3. I’ve added some code on line 234 of your file CFDBQueryResultIterator.php to show the data of the mysql query which gets the data out of my mysql-database into the shortcode I use to display the data:

echo '<pre>';
		echo print_r($this->row); //debug CFDBQueryResultIterator.php Zeile 235
		echo '</pre>';

The results are shown in this image.

4. I then use the [cfdb-datatable] shortcode to show the data on my page. The Table looks like that.

5. I’ve made a separate page to show the details of the entry. A part of this page also shows the correct german umlauts. Have a look her.

6. After the submit of the data I’ve shown above I’ve received a email from my system which I show here.

7. The admin page of your plugin looks like that.

As you can see … in WordPress Version 3.8.3 everything looks nice and german umlauts are properly displayed.

Now the weird part takes place. I’ve upgraded to WordPress 3.9.1 via the WordPress Dashboard auto update function. After that I’ve upgraded nothing else.

1. Database Collation shown by PhpMyAdmin.

2. Detail of the database entry shown by PhpMyAdmin.

3. Array echoed by print_r. There the issue occurs!.

4. Output of the shortcode on my page.

5. Output of my detail page.

6. Same email like before with Version 3.8.3.. The issue occurs with old and new entries!

7. Output of the admin page of your plugin.

After upgrade to WordPress 3.9.1. the german umlauts are shown with those questionmarks. Regardless if I use the unbuffered or the buffered output.

Thanks for investigating. I plan to take a longer look at this problem this weekend.

Good morning, Michael,

no problem. ??

Just trying to find a solution for this problem without bothering you with support requests.

And just a few moments ago I think I find the cause of the problem: please have a look at wp-db.php in the wp-includes folder. Around line 590 there is a check on the php-version which then sets use_mysqli to true. If I change this value (the value of the checked php-version) from 5.5 to 7.0 my problem is solved. All german umlauts are then properly displayed.

I’ve found that by comparing the wp-db.php from version 3.8.3 with the new one in 3.9.1.

Is this something which could be corrected by you by changing something in the plugin?

I updated the code to support MySqli but I can’t test it. Would you download the development version and install that on your WP 3.9.1 and test?

Hi Michael,

thanks for your work!

I’ve downloaded the development version (RC3) and deinstalled the actual used version of your plugin. After that I’ve installed the RC3 Version and activated it. After activation it states:

The plugin generated 744 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin.

The plugin stays activated. But it didn’t shows any entries out of my database. I’ve checked my database and the table is still there. Also my data is still in the table.

Ok sounds like there was an error connecting to the DB. I need to find a mysqli to test against.

Please download and install from that link again (Version: 2.8RC5) and let me know…

Hi Michael,

sorry for my late response. This week I’m on a seminar to prepare for a Citrix certification and I’ve got only time late in the evening.

I’ve tested RC5 … same error message while activating the plugin.

I’m sorry.

Hi Michael,
I have test 2.8RC5 and it work for me.
I have desactived old version, rename folder on ftp
and active RC5 version

All look good now, On my old form, text with french caracter are ok!!!!

@initiateur thank you for testing!

@markusfrenzel because it is exactly 744 character, I think it is this issue where the plugin is trying to create the table but cannot or the table is already there. I don’t know why it would do that unless it thinks it is not already installed. Easiest thing to do is probably to rename the wp_cf7dbplugin_submits table in the DB to something else, install the plugin, then drop the new wp_cf7dbplugin_submits table, and rename the old table back to wp_cf7dbplugin_submits

I have forked original plugin (development one) and added support for Galician language and Twitter Bootstrap into Datatable.
You can check it at https://github.com/fricolab/contact-form-7-to-database-extension-galician-bootstrap

How can I get a diff to see your changes?

https://github.com/fricolab/contact-form-7-to-database-extension-galician-bootstrap/compare/wp-plugins:master…master

??

Would you please upload your translation files?

contact-form-7-to-database-extension-gl_ES.po and contact-form-7-to-database-extension-gl_ES.mo here

gl_ES.json here