rvm_latin1_to_utf8 (v0.5)

ruud · 2007-12-03 21:02:36

Perhaps you should open a new topic about this, because it’s not really related to the plugin this topic is about. My plugin should be able to convert your tables to use utf8 on Nicola. After that just a matter of migrating the database to a different server and it becomes a PHPmyAdmin export/import question.

Last edited by ruud (2007-12-03 21:03:22)

moslib · 2008-03-26 23:34:28

I get Fatal error: Call to undefined function safe_pfx() in /public_html/textpattern/lib/txplib_misc.php(459) : eval()'d code on line 115 on older Txp sites

ruud · 2008-03-27 09:23:43

First upgrade to a recent TXP version.

colak · 2014-08-18 05:15:27

I am trying to update the character set of an old site using this plugin but it truncates all article bodies.

The site was using txp4.0.3 in joyent and it has now been moved to bluehost where I upgraded it to the latest stable release, 4.5.5.

>Edited to add some diagnostics

Textpattern version: 4.5.5 (r5575)
PHP version: 5.2.17
gd_library: gd_info: bundled (2.0.34 compatible), GIF, JPG, PNG
MySQL: 5.5.38-35.2-log
Locale: en_GB.UTF-8
Server: Apache
php_sapi_mode: cgi-fcgi
rfc2616_headers: 0
os_version: Linux 3.12.26.1406932904
active_plugins: glx_if-0.7m, hak_textile_tags-0.1m, czg_if_comment_cookies-0.1m, ob1_title-2.2, rss_live_search-0.2.2m, zem_article_image-0.1, ob1_googlenav-2.0m, dca_pop-0.1m, walk_qt-0.4.2, zem_contact_lang-4.0.3.6, zem_contact_reborn-4.0.3.20, upm_img_popper-0.9.9m, asy_sitemap-0.7m, rss_admin_db_manager-4.3, smd_where_used-0.30
theme_name: remora 4.5.5

Last edited by colak (2014-08-18 07:03:33)

candyman · 2014-08-18 12:58:14

I’ve missed that, very interesting.
I would need a thing like this to migrate a phpBB forum (collation problem): is there something that could help me?
Any docs?

Thanks in advance.

Last edited by candyman (2014-08-18 12:58:22)

ruud · 2014-08-19 19:58:30

colak wrote #282988:

I am trying to update the character set of an old site using this plugin but it truncates all article bodies.

Only the article bodies… and all the bodies or just a few? Did it completely empty the article body? Could it be that the original articles contained non-utf8 characters?

candyman wrote #283019:

I would need a thing like this to migrate a phpBB forum (collation problem): is there something that could help me? Any docs?

You could have a look at the plugin code. That might get you started. Otherwise ask around on the phpBB forum. Perhaps someone else already wrote something similar.

colak · 2014-08-20 05:21:17

ruud wrote #283061:

Only the article bodies… and all the bodies or just a few? Did it completely empty the article body? Could it be that the original articles contained non-utf8 characters?

It truncated all article bodies without emptying them completely. The original articles contained texts in english copy pasted from word.

ruud · 2014-08-20 17:30:25

How long are the truncated article bodies? The part that remains, I mean, in bytes?

colak · 2014-08-20 18:07:40

I restored the site and it is currently using Latin1 but I can repeat the installation of your plugin tomorrow and answer your question. Is there anything other info you may find helpful and I should look out for?

alesh · 2016-12-30 13:56:46

Hmmmmmm I’m trying this to update an old TXP database mis-restored at some point with some funky encoding. When I activate the plugin I get

The rvm_latin1_to_utf8 plugin has been removed, because your MySQL version is lower than 4.1.

This is Dreamhost, and best as I can tell (title bar in Sequel Pro) MySQL 5.6.25. Any suggestions?

ruud · 2016-12-30 21:37:21

Post your diagnostics please.

phiw13 · 2016-12-31 01:29:38

Ruud, activating this plugin wit TXP 4.6 (debugging enabled), MySql 5.6.x, PHP 5.5.38, and then going to index.php?event=rvm_latin1_to_utf8 I get the following:

8192 "mysql_get_server_info(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead"
in /Users/[username]/Sites/_txp-test/textpattern/lib/txplib_misc.php(1782) : eval()'d code at line 21.
adminErrorHandler()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:21 mysql_get_server_info()
rvm_latin1_to_utf8()
textpattern/lib/txplib_misc.php:1895 call_user_func_array()
textpattern/index.php:214 callback_event()
Warning "mysql_get_server_info(): Access denied for user ''@'localhost' (using password: NO)"
in /Users/[username]/Sites/_txp-test/textpattern/lib/txplib_misc.php(1782) : eval()'d code at line 21.
adminErrorHandler()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:21 mysql_get_server_info()
rvm_latin1_to_utf8()
textpattern/lib/txplib_misc.php:1895 call_user_func_array()
textpattern/index.php:214 callback_event()
Warning "mysql_get_server_info(): A link to the server could not be established"
in /Users/[username]/Sites/_txp-test/textpattern/lib/txplib_misc.php(1782) : eval()'d code at line 21.
adminErrorHandler()
textpattern/lib/txplib_misc.php(1782) : eval()'d code:21 mysql_get_server_info()
rvm_latin1_to_utf8()
textpattern/lib/txplib_misc.php:1895 call_user_func_array()
textpattern/index.php:214 callback_event()

followed by The rvm_latin1_to_utf8 plugin has been removed, because your MySQL version is lower than 4.1.

HTH…
(and happy new year)

Textpattern CMS

Textpattern CMS support forum

#37 2007-12-03 21:02:36

Re: rvm_latin1_to_utf8 (v0.5)

#38 2008-03-26 23:34:28

Re: rvm_latin1_to_utf8 (v0.5)

#39 2008-03-27 09:23:43

Re: rvm_latin1_to_utf8 (v0.5)

#40 2014-08-18 05:15:27

Re: rvm_latin1_to_utf8 (v0.5)

#41 2014-08-18 12:58:14

Re: rvm_latin1_to_utf8 (v0.5)

#42 2014-08-19 19:58:30

Re: rvm_latin1_to_utf8 (v0.5)

colak wrote #282988:

candyman wrote #283019:

#43 2014-08-20 05:21:17

Re: rvm_latin1_to_utf8 (v0.5)

ruud wrote #283061:

#44 2014-08-20 17:30:25

Re: rvm_latin1_to_utf8 (v0.5)

#45 2014-08-20 18:07:40

Re: rvm_latin1_to_utf8 (v0.5)

#46 2016-12-30 13:56:46

Re: rvm_latin1_to_utf8 (v0.5)

#47 2016-12-30 21:37:21

Re: rvm_latin1_to_utf8 (v0.5)

#48 2016-12-31 01:29:38

Re: rvm_latin1_to_utf8 (v0.5)

Board footer