Entering french characters in custom fields

Hi Tom, I split your topic from https://wpgeodirectory.com/support/topic/creating-a-new-custom-post-type-bug

I alerted Stiofan for you.

Hi Tom,

I tested and it seemed to work fine, see here: http://ppl.directory/places/united-kingdom/dumfries-and-galloway/thornhill/attractions/boite-a-biere/

Can you let me know a way i can replicate you problem.

Thanks,

Stiofan

Tom, if you are worried, just backup your database first. Then you can go back.

I attach a screenshot of my test site, and have a look at this URL as well:
http://goldroo.net/kolacica/australia/queensland/brisbane/health/bolgen-moi-hovikodden/

ok found the problem, it was % were not being escaped before wpbd->prepare and breaking things.

I have added the fix and it will be in the next version.
to fix now please edit geodirectory-functions/post_functions.php line 444

Add this:

$post_meta_set_query = str_replace('%', '%%',  $post_meta_set_query);// escape %

so the surrounding lines are this:

$post_meta_set_query = trim($post_meta_set_query,", ");

		$post_meta_set_query = str_replace('%', '%%',  $post_meta_set_query);// escape %
		
		do_action('geodir_before_save_listinginfo',$postinfo_array, $post_id);

Thanks,

Stiofan

You are welcome! 🙂