td_subtitle database insertion

Hi

I am working in a migration and generating subtitles manually to insert in postmeta table like this:
post_id
td_post_theme_settings
a:1:{s:11:”td_subtitle”;s:10:”AAAAAAAAAA”;}

Unfortunately this only works when I updated through editor even doing same insertion. What am I missing?

• This topic was modified 9 years by gcamara.

well, I should migrate like 8000 posts and if you could do a simple test inserting directly in db and comparing why a dashboard editing has a different effect, that could be a great achievement… Maybe I missed some other table link or similar.

AFAIK wp_postmeta has only relation with wp_post, so thats my problem. I’m stuck

That’s strange, thank you for your test, I’ll keep testing to see what could be failing here.

ok, seems special characters like ñ á é í etc are not compatible when you inserted them through phpmyadmin or command line script. Any advice? Romanian language special characters are also affected as well.

wow, this is extremely strange… seems that every special char count by two in string count parameter, this is one of the most “rarities” i’ve ever seen.

• This reply was modified 9 years by gcamara.
• This reply was modified 9 years by gcamara.

solved, multibyte characters count 1 in char_length but two in length functions in mysql, that was the problem.