Textpattern CMS support forum

You are not logged in. Register | Login | Help

#21 2018-08-03 07:37:12

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 1,723
Website

Re: Odd Characters, Blank Templates

jrmartin wrote #313232:

All the articles look good, only the languages page looks screwed up, like this:

?????? ???? Install 23 Mar 2018 06:50:39 AM – -
????????? Install 09 Oct 2017 09:04:03 AM – -
Bosanski Install 09 Oct 2017 09:04:03 AM – -
Catal Install 09 Oct 2017 09:04:03 AM

That is strange. Can you have a look at the database, in the txp-lang table, search for entries in the name column for e.g. el-gr -> Ελληνικά (Greek), or fa-ir -> فارسی (farsi), or bg-bg -> български (Bulgarian), which is one of the languages you list with ?? marks.

On the other hand, I’m not sure it is a big issue prior to updating, as in TXP 4.7 the languages part has changed a lot, and the new files should be read, and the DB updated to match (I think …).

Offline

#22 2018-08-03 14:00:11

jrmartin
Member
Registered: 2013-03-07
Posts: 75

Re: Odd Characters, Blank Templates

colak wrote #313233:

Can you post your diagnostics?

Textpattern version: 4.6.2 (8412e32468526e075446b881d13bd9ce)
Last update: 2016-11-08 08:57:07/2016-11-05 06:13:11
Document root: /home/wanderi2/marthasitaly.com
$path_to_site: /home/wanderi2/marthasitaly.com
Textpattern path: /home/wanderi2/marthasitaly.com/textpattern
Article URL pattern: section_id_title
Temporary directory path: /home/wanderi2/marthasitaly.com/textpattern/tmp
Site URL: www.marthasitaly.com
PHP version: 7.0.31
GD Graphics Library: bundled (2.1.0 compatible); supported formats: GIF, JPG, PNG.
Server TZ: America/New_York
Server local time: 2018-08-03 09:56:54
Daylight Saving Time enabled?: 1
Automatically adjust Daylight Saving Time setting?: 1
Time zone (GMT offset in seconds): America/Los_Angeles (-28800)
MySQL: 10.1.31-MariaDB-cll-lve
Database server time: 2018-08-03 09:56:54
Database server time offset: 0 s
Database server timezone: SYSTEM
Database session timezone: SYSTEM
Locale: en_US.UTF-8
Server: LiteSpeed
PHP server API: litespeed
RFC 2616 headers:
Server OS: Linux 2.6.32-896.16.1.lve1.4.54.el6.x86_64
Active plugins: smd_lately-0.31, upm_textile_toggle-0.5, arc_meta-1.4.2, smd_article_stats-0.40
Admin-side theme: classic 4.6.2

Pre-flight check:
————————————
New Textpattern version 4.7.0 available for download.
Clean URLs are only supported on Apache, use at your own risk.
————————————

.htaccess file contents: ————————————
  1. BEGIN Textpattern
    #DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes
#ErrorDocument 403 default

<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/

RewriteCond %{HTTPS} !=on
RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$
RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$
RewriteCond %{REQUEST_URI} !^/\.well-known/acme-challenge/[0-9a-zA-Z_-]+$
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

RewriteCond %{HTTP_HOST} !^www\.
RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$
RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$
RewriteCond %{REQUEST_URI} !^/\.well-known/acme-challenge/[0-9a-zA-Z_-]+$
RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$ RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$ RewriteCond %{REQUEST_URI} !^/\.well-known/acme-challenge/[0-9a-zA-Z_-]+$ RewriteRule ^(.+) – [PT,L] RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$ RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$ RewriteCond %{REQUEST_URI} !^/\.well-known/acme-challenge/[0-9a-zA-Z_-]+$ RewriteRule ^(.*) index.php RewriteCond %{HTTP:Authorization} !^$ RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$ RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$ RewriteCond %{REQUEST_URI} !^/\.well-known/acme-challenge/[0-9a-zA-Z_-]+$ RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}] </IfModule>

#php_value register_globals 0

<IfModule mod_mime.c> AddType image/svg+xml svg svgz AddEncoding gzip svgz </IfModule>
  1. END Textpattern

————————————

Charset (default/config): latin1/utf8
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_filesystem: binary
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
17 Tables: textpattern is utf8, txp_category is utf8, txp_css is utf8, txp_discuss is utf8, txp_discuss_nonce is utf8, txp_file is utf8, txp_form is utf8, txp_image is utf8, txp_lang is utf8, txp_link is utf8, txp_log is utf8, txp_page is utf8, txp_plugin is utf8, txp_prefs is utf8, txp_section is utf8, txp_token is utf8, txp_users is utf8

10 Custom fields: custom_1, custom_2, custom_3, custom_4, custom_5, custom_6, custom_7, custom_8, custom_9, custom_10 (10)

PHP extensions: Core/7.0.31, date/7.0.31, libxml/7.0.31, openssl/7.0.31, pcre/7.0.31, sqlite3/7.0.31, zlib/7.0.31, bz2/7.0.31, calendar/7.0.31, ctype/7.0.31, curl/7.0.31, hash/1.0, filter/7.0.31, ftp/7.0.31, gettext/7.0.31, gmp/7.0.31, SPL/7.0.31, iconv/7.0.31, pcntl/7.0.31, readline/7.0.31, Reflection/7.0.31, session/7.0.31, standard/7.0.31, shmop/7.0.31, SimpleXML/7.0.31, mbstring/7.0.31, tokenizer/7.0.31, xml/7.0.31, litespeed, bcmath/7.0.31, dom/20031129, fileinfo/1.0.5, gd/7.0.31, imap/7.0.31, intl/1.1.0, json/1.4.0, exif/7.0.31, mcrypt/7.0.31, mysqli/7.0.31, PDO/7.0.31, pdo_mysql/7.0.31, pdo_pgsql/7.0.31, pdo_sqlite/7.0.31, pgsql/7.0.31, Phar/2.0.2, posix/7.0.31, soap/7.0.31, sockets/7.0.31, tidy/7.0.31, xmlreader/7.0.31, xmlrpc/7.0.31, xmlwriter/7.0.31, xsl/7.0.31, zip/1.13.5, Zend OPcache/7.0.31

Apache modules: mod_rewrite, mod_mime, mod_headers, mod_expires, mod_auth_basic

pretext_data: array ( ‘status’ => ‘200’, ‘id’ => ‘’, ‘s’ => ‘’, ‘c’ => ‘’, ‘context’ => ‘’, ‘q’ => ‘’, ‘m’ => ‘’, ‘pg’ => ‘’, ‘p’ => ‘’, ‘month’ => ‘’, ‘author’ => ‘’, ‘request_uri’ => ‘/3a48fe000e68415f5d5db57c403e69e7/?txpcleantest=1’, ‘qs’ => ‘txpcleantest=1’, ‘subpath’ => ‘\\/’, ‘req’ => ‘/3a48fe000e68415f5d5db57c403e69e7/?txpcleantest=1’,
)

Offline

#23 2018-08-03 14:40:35

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 7,344
Website

Re: Odd Characters, Blank Templates

I guess that ruud’s latin1 to utf8 plugin did not work. Back up your db first.

Then you can use some mysql in phpMyadmin or similar.

Before you do that, check the charset in your /textpattern/config.pho file. Is it $txpcfg['dbcharset'] = 'utf8'; or latin1?


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github

Offline

#24 2018-08-03 14:53:08

jrmartin
Member
Registered: 2013-03-07
Posts: 75

Re: Odd Characters, Blank Templates

$txpcfg[‘dbcharset’] = ‘utf8’;

Offline

#25 2018-08-03 15:13:58

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 7,344
Website

Re: Odd Characters, Blank Templates

can you change it to latin1 and see what happens?


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github

Offline

#26 2018-08-10 23:27:39

jrmartin
Member
Registered: 2013-03-07
Posts: 75

Re: Odd Characters, Blank Templates

colak wrote #313241:

can you change it to latin1 and see what happens?

I did change it to latin1 and it now reports:

Charset (default/config): latin1/latin1
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_filesystem: binary
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/

So it works just the same. Right now the only trouble we seem to be having is that the language pages are still screwed up and, more importantly, a paragraph that begins and ends with single or double quotes typed from the keyboard doesn’t display.

Offline

#27 2018-08-11 00:46:58

bici
Member
From: vancouver
Registered: 2004-02-24
Posts: 1,510
Website

Re: Odd Characters, Blank Templates

i know i had a devil of a time in getting my old EEcms site updated from Latin-1 to UTF-8.
i ended up having manually change the odd characters one-by-one.

Odd that MySQL itself can’t repair its character sets via some script.


…. texted postive

Offline

#28 2018-08-11 01:08:55

jrmartin
Member
Registered: 2013-03-07
Posts: 75

Re: Odd Characters, Blank Templates

Yeah, the characters are all fixed and the site seems to be working well. It’s the problem with the typed quotes that’s driving me crazy. My big site Wandering Italy has the same database coding and has worked fine for years and years. Strange.

Offline

#29 2018-08-11 04:46:18

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 7,344
Website

Re: Odd Characters, Blank Templates

The characters look like they are fixed because the database tables are now called correctly from textpattern because of your change to the config file.

I would still try to convert the database to utf8.


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github

Offline

#30 2018-08-18 20:25:00

jrmartin
Member
Registered: 2013-03-07
Posts: 75

Re: Odd Characters, Blank Templates

jakob wrote #313108:

I read you did a database upgrade on this thread but saw no difference in the files. You can check if that is really the case by exporting your updated database and then comparing the old and new using a diff tool.

One further idea – do you have the line:

$txpcfg['dbcharset'] = 'utf8';...

as shown here in your config.php file?

If you want some off-forum assistance, send me an email…

Thanks Jakob. I used the database you provided me and I had the same problems. Same database diagnostics, same dropping of paragraphs with quotes.

BUT, then I looked at the languages page again and it said I was using US English. So I downloaded EN-GB and switched to British English and…everything is displaying fine again, even the languages page. I can also use special characters. Diagnostics on the database haven’t changed, but I’m happy it’s fixed.

Thanks again.

Offline

Board footer

Powered by FluxBB