Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: NON-ASCII obfuscated since MySQL/PHP "upgrade"
Yes, I’m fine with “just” utf8.
Now i set up a test site to see, what txp 4.6.2 initially sets up:
Upon running setup i get
“Warning: mysqli_real_connect(): Headers and client library minor version mismatch. Headers:50630 Library:100028 in /home/kliklak/public_html/mysqltest/textpattern/setup/txpsql.php on line 56”
and
“That went well! Textpattern database tables were created …“ etc.
Diagnostics show no errors, and these further details:
Charset (default/config): latin1/utf8mb4
character_set_client: latin1
character_set_connection: latin1
character_set_database: utf8
character_set_filesystem: binary
character_set_results: latin1
character_set_server: utf8
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
17 Tables: textpattern is utf8mb4, txp_category is utf8mb4, txp_css is utf8mb4, txp_discuss is utf8mb4, txp_discuss_nonce is utf8mb4, txp_file is utf8mb4, txp_form is utf8mb4, txp_image is utf8mb4, txp_lang is utf8mb4, txp_link is utf8mb4, txp_log is utf8mb4, txp_page is utf8mb4, txp_plugin is utf8mb4, txp_prefs is utf8mb4, txp_section is utf8mb4, txp_token is utf8mb4, txp_users is utf8mb4
the complete database reports simply utf8 on collation, not utf8mb4.
So there we have a mix of collation again. Grmph.
I think a big part of my problems is related already to different older textpattern versions already. I guess i can somehow minimize trouble, when the first thing i do, is update them all to 4.6.2.
A hole turned upside down is a dome, when there’s also gravity.
Offline