Go to main content

Navigation menu

Textpattern CMS support forum

You are not logged in. Register | Login | Help

  1. Index
  2. » Archives
  3. » Strange bug after moving database

Pages: 1

#1 2007-07-02 16:37:17

FireFusion
Member
Registered: 2005-05-10
Posts: 698

Strange bug after moving database

Some of the text in the admin area has been replaced with odd characters. It seems to be anywhere where there are normally quotation marks or other entities. Few examples…

Require user’s e-mail address? 	
…or publish at

The language panel is worst hit. Other wise everything else seems fine. We moved the database to a site on the same server as the other one.

Offline

#2 2007-07-02 21:31:54

Sencer
Archived Developer
From: cgn, de
Registered: 2004-03-23
Posts: 1,803
Website

Re: Strange bug after moving database

Please post your high-level diagnostics, it looks like you borked the characterset either during backup or during import.
It would also help if you had the high level diagnostics from the old site as well (and your old config.php).

Offline

#3 2007-07-03 06:28:00

FireFusion
Member
Registered: 2005-05-10
Posts: 698

Re: Strange bug after moving database

Seemed to just be the language file. I switched the language to en-gb and everything was fine again. I can still post the high level diagnostics if you like.

Offline

#4 2007-07-03 06:40:06

FireFusion
Member
Registered: 2005-05-10
Posts: 698

Re: Strange bug after moving database

The first site…

Textpattern version: 4.0.5 (r2466)
Last Update: 2007-07-02 09:59:42/2007-07-02 09:58:22
Document root: /home/user/public_html
$path_to_site: /home/user/public_html
Textpattern path: /home/user/public_html/textpattern
Permanent link mode: section_title
Temporary directory path: /tmp
Site URL: www.mysite.org
PHP version: 5.2.1
Register globals: 1
GD Image Library: bundled (2.0.28 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2007-07-03 02:38:55
MySQL: 5.0.27-standard
Locale: en_GB.UTF-8
Server: Apache/1.3.37 (Unix) PHP/5.2.1 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
Apache version: Apache/1.3.37 (Unix) PHP/5.2.1 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
PHP Server API: apache
RFC 2616 headers: 
Server OS: Linux 2.6.9-34.ELsmp
Active plugins: upm_img_popper-1.3.4, rss_article_edit-0.1m, rss_admin_db_manager-4.3, ras_if_dates-4.0.4.2, asy_wondertag-0.5, glx_hl_current-0.3, zem_redirect-1.2

Pre-flight check: 
------------------------
Old placeholder file is in the way: /home/kmc/public_html/events
Some Textpattern files are out of date: 
	/lib/class.thumb.php
Some Textpattern files have been modified: 
	/lib/admin_config.php
------------------------

.htaccess file contents: 
------------------------
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
Options -Indexes

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

	RewriteCond %{REQUEST_FILENAME} -f [OR]
	RewriteCond %{REQUEST_FILENAME} -d
	RewriteRule ^(.+) - [PT,L]

	RewriteRule ^(.*) index.php
</IfModule>

#php_value register_globals 0
------------------------

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/
21 Tables: OK

PHP extensions: xmlwriter/0.1, libxml, dom/20031129, xmlreader/0.1, xml, tokenizer/0.1, session, pcre, SimpleXML, SPL, PDO, sockets, SQLite, standard/5.2.1, Reflection, posix, pdo_sqlite/1.0.1, mysqli/0.1, mysql/1.0, mhash, json/1.2.1, iconv, hash/1.0, gd, ftp, filter/0.11.0, date/5.2.1, ctype, calendar, bcmath, zlib/1.1, openssl, apache, Zend Optimizer

Apache modules: http_core, mod_env, mod_log_config, mod_mime, mod_negotiation, mod_status, mod_include, mod_autoindex, mod_dir, mod_cgi, mod_asis, mod_imap, mod_actions, mod_userdir, mod_alias, mod_access, mod_auth, mod_so, mod_setenvif, mod_ssl, mod_frontpage, mod_rewrite, mod_expires, mod_bwlimited, mod_log_bytes, mod_auth_passthrough, mod_security, mod_php5

pretext_data: array (
  'id' => '',
  's' => '',
  'c' => '',
  'q' => '',
  'pg' => '',
  'p' => '',
  'month' => '',
  'author' => '',
  'request_uri' => '/9b93d8a46ac336efe9c5715ae2dc991a/?txpcleantest=1',
  'qs' => 'txpcleantest=1',
  'subpath' => '\\/',
  'req' => '/9b93d8a46ac336efe9c5715ae2dc991a/?txpcleantest=1',
)

/include/txp_category.php: r2243 (3706fea923cd77f7053f7803de169df4)
/include/txp_plugin.php: r1917 (c63f72f33986c08367672fc9fe7b42dd)
/include/txp_auth.php: r2356 (33255ec1ea1a825163c78272496d8783)
/include/txp_form.php: r1913 (ecea3fecf9d7d1f8088cda67f097eceb)
/include/txp_section.php: r1891 (1f0121b3e2969d94bc8a7fb98bfdfbd5)
/include/txp_tag.php: r2260 (1bd67bdb9dcfb72e34ea967e39406216)
/include/txp_list.php: r2450 (997a3b1bec7115bf49b76f62b28da146)
/include/txp_page.php: r2099 (56bde34b6c7bcb9123ac91e73065e894)
/include/txp_discuss.php: r2451 (91e0b29ef39a9471ae5c78d0b1bba086)
/include/txp_prefs.php: r2405 (a4b76476930b2376199f23fbfd5f1ac9)
/include/txp_log.php: r2439 (16730c34e2a437dd88b8f5cc7eff8218)
/include/txp_preview.php: r1238 (696728f35f3557b648c011bb4d6496c3)
/include/txp_image.php: r2439 (9fac6ed0d9d4c3d8196492051f38dc9a)
/include/txp_article.php: r2453 (bdac8fcac5df2f93f10afa7e50c3fb6f)
/include/txp_css.php: r2403 (4e8c52bb1cf5bfe2e2f0640892f9b92e)
/include/txp_admin.php: r2403 (f8700a3d453ece08e7f137b47c967eda)
/include/txp_link.php: r2463 (0a0171bf606296106332d3fdcb83a678)
/include/txp_diag.php: r2361 (dccf3269049dd25e59afdd7ad8d235cd)
/include/txp_file.php: r2403 (e62abd5fcadabe629322ed17135d89eb)
/include/txp_import.php: r1238 (70a6207c0f3604ecfc4b20369986c4d7)
/lib/admin_config.php: r1747 (c2ff7bd57742e260a4e0cc0d21dd2add)
/lib/txplib_misc.php: r2464 (615afd44a10311f1c0b7852d9bc15d24)
/lib/taglib.php: r1535 (9b519f9dc88791e5ee8eacc029dd6975)
/lib/txplib_head.php: r2404 (2e067b25997cf67cddbdd365570e69d5)
/lib/classTextile.php: r2462 (a031e2ea894e339711c601f230c5ee71)
/lib/txplib_html.php: r2403 (97e173da3058b438513df67fd7d1ceca)
/lib/txplib_db.php: r2406 (5ed67642f805639b54e381fb22efd208)
/lib/IXRClass.php: r765 (137b91497628f0058a2fca9eba5c3b7f)
/lib/txplib_forms.php: r2403 (438a734b52acef40b36d8a3ba23987e8)
/lib/class.thumb.php: r1955 (12961180eee3add5096e69e0a154284e)
/lib/constants.php: r2361 (ab6d51668fab1e3c98e7d520b1a59f0f)
/lib/txplib_update.php: r1239 (10f28a986d23187b436369dc29ab552f)
/lib/txplib_wrapper.php: r2286 (419125ec74a17a70bf1e86ebfcd45253)
/publish/taghandlers.php: r2444 (cc9de8f2018b01398a2ba542c5f5bdc6)
/publish/atom.php: r2402 (46c4402717f695fde0d49d806adfa4c4)
/publish/log.php: r1637 (5254d0f3942086bc55723923307a51db)
/publish/comment.php: r2460 (2d1ae1dec0784f044e7005fa5ed50930)
/publish/search.php: r1748 (8c86ebcb5be08e214d81ca15a32164ca)
/publish/rss.php: r2393 (09aac29bf22ffa71c1e118e851cff3c3)
/publish.php: r2436 (7087864f1e7c6efe096d3b8e07c350b1)
/index.php: r2466 (30ecf35de5c1edc6ef68e780c8c79daa)
/css.php: r944 (8beba8f83a091068723435cdcdc02f2f)

The site we moved it to 

Textpattern version: 4.0.5 (r2466)
Last Update: 2007-07-02 09:59:42/2007-07-02 20:07:54
Document root: /home/user/public_html/kmd
$path_to_site: /home/user/public_html/kmd
Textpattern path: /home/user/public_html/kmd/textpattern
Permanent link mode: section_title
Temporary directory path: /tmp
Site URL: myothersite.com
PHP version: 5.2.1
Register globals: 1
GD Image Library: version bundled (2.0.28 compatible), supported formats: GIF, JPG, PNG
Server Local Time: 2007-07-03 02:36:09
MySQL: 5.0.27-standard
Locale: en_US.UTF-8
Server: Apache/1.3.37 (Unix) PHP/5.2.1 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
Apache version: Apache/1.3.37 (Unix) PHP/5.2.1 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
PHP Server API: apache
RFC 2616 headers: 
Server OS: Linux 2.6.9-34.ELsmp
Active plugins: upm_img_popper-1.3.4, rss_article_edit-0.1m, rss_admin_db_manager-4.3, ras_if_dates-4.0.4.2, asy_wondertag-0.5, glx_hl_current-0.3, zem_redirect-1.2

.htaccess file contents: 
------------------------
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
Options -Indexes

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

	RewriteCond %{REQUEST_FILENAME} -f [OR]
	RewriteCond %{REQUEST_FILENAME} -d
	RewriteRule ^(.+) - [PT,L]

	RewriteRule ^(.*) index.php
</IfModule>

#php_value register_globals 0
------------------------

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

PHP extensions: xmlwriter/0.1, libxml, dom/20031129, xmlreader/0.1, xml, tokenizer/0.1, session, pcre, SimpleXML, SPL, PDO, sockets, SQLite, standard/5.2.1, Reflection, posix, pdo_sqlite/1.0.1, mysqli/0.1, mysql/1.0, mhash, json/1.2.1, iconv, hash/1.0, gd, ftp, filter/0.11.0, date/5.2.1, ctype, calendar, bcmath, zlib/1.1, openssl, apache, Zend Optimizer

Apache modules: http_core, mod_env, mod_log_config, mod_mime, mod_negotiation, mod_status, mod_include, mod_autoindex, mod_dir, mod_cgi, mod_asis, mod_imap, mod_actions, mod_userdir, mod_alias, mod_access, mod_auth, mod_so, mod_setenvif, mod_ssl, mod_frontpage, mod_rewrite, mod_expires, mod_bwlimited, mod_log_bytes, mod_auth_passthrough, mod_security, mod_php5

pretext_data: array (
  'id' => '',
  's' => '',
  'c' => '',
  'q' => '',
  'pg' => '',
  'p' => '',
  'month' => '',
  'author' => '',
  'request_uri' => '/1953cea9d205621ea97167e58afd9bbc/?txpcleantest=1',
  'qs' => 'txpcleantest=1',
  'subpath' => '\\/',
  'req' => '/1953cea9d205621ea97167e58afd9bbc/?txpcleantest=1',
)

/include/txp_category.php: r2243 (3706fea923cd77f7053f7803de169df4)
/include/txp_plugin.php: r1917 (c63f72f33986c08367672fc9fe7b42dd)
/include/txp_auth.php: r2356 (33255ec1ea1a825163c78272496d8783)
/include/txp_form.php: r1913 (ecea3fecf9d7d1f8088cda67f097eceb)
/include/txp_section.php: r1891 (1f0121b3e2969d94bc8a7fb98bfdfbd5)
/include/txp_tag.php: r2260 (1bd67bdb9dcfb72e34ea967e39406216)
/include/txp_list.php: r2450 (997a3b1bec7115bf49b76f62b28da146)
/include/txp_page.php: r2099 (56bde34b6c7bcb9123ac91e73065e894)
/include/txp_discuss.php: r2451 (91e0b29ef39a9471ae5c78d0b1bba086)
/include/txp_prefs.php: r2405 (a4b76476930b2376199f23fbfd5f1ac9)
/include/txp_log.php: r2439 (16730c34e2a437dd88b8f5cc7eff8218)
/include/txp_preview.php: r1238 (696728f35f3557b648c011bb4d6496c3)
/include/txp_image.php: r2439 (9fac6ed0d9d4c3d8196492051f38dc9a)
/include/txp_article.php: r2453 (bdac8fcac5df2f93f10afa7e50c3fb6f)
/include/txp_css.php: r2403 (4e8c52bb1cf5bfe2e2f0640892f9b92e)
/include/txp_admin.php: r2403 (f8700a3d453ece08e7f137b47c967eda)
/include/txp_link.php: r2463 (0a0171bf606296106332d3fdcb83a678)
/include/txp_diag.php: r2361 (dccf3269049dd25e59afdd7ad8d235cd)
/include/txp_file.php: r2403 (e62abd5fcadabe629322ed17135d89eb)
/include/txp_import.php: r1238 (70a6207c0f3604ecfc4b20369986c4d7)
/lib/admin_config.php: r1747 (a2eb09f94d7902a6e95750fc4abcea17)
/lib/txplib_misc.php: r2464 (615afd44a10311f1c0b7852d9bc15d24)
/lib/taglib.php: r1535 (9b519f9dc88791e5ee8eacc029dd6975)
/lib/txplib_head.php: r2404 (2e067b25997cf67cddbdd365570e69d5)
/lib/classTextile.php: r2462 (a031e2ea894e339711c601f230c5ee71)
/lib/txplib_html.php: r2403 (97e173da3058b438513df67fd7d1ceca)
/lib/txplib_db.php: r2406 (5ed67642f805639b54e381fb22efd208)
/lib/IXRClass.php: r765 (137b91497628f0058a2fca9eba5c3b7f)
/lib/txplib_forms.php: r2403 (438a734b52acef40b36d8a3ba23987e8)
/lib/class.thumb.php: r2329 (b2a2fda54371dbd6c40ba553941f090e)
/lib/constants.php: r2361 (ab6d51668fab1e3c98e7d520b1a59f0f)
/lib/txplib_update.php: r1239 (10f28a986d23187b436369dc29ab552f)
/lib/txplib_wrapper.php: r2286 (419125ec74a17a70bf1e86ebfcd45253)
/publish/taghandlers.php: r2444 (cc9de8f2018b01398a2ba542c5f5bdc6)
/publish/atom.php: r2402 (46c4402717f695fde0d49d806adfa4c4)
/publish/log.php: r1637 (5254d0f3942086bc55723923307a51db)
/publish/comment.php: r2460 (2d1ae1dec0784f044e7005fa5ed50930)
/publish/search.php: r1748 (8c86ebcb5be08e214d81ca15a32164ca)
/publish/rss.php: r2393 (09aac29bf22ffa71c1e118e851cff3c3)
/publish.php: r2436 (7087864f1e7c6efe096d3b8e07c350b1)
/index.php: r2466 (30ecf35de5c1edc6ef68e780c8c79daa)
/css.php: r944 (8beba8f83a091068723435cdcdc02f2f)

Offline

#5 2007-07-03 06:46:12

Sencer
Archived Developer
From: cgn, de
Registered: 2004-03-23
Posts: 1,803
Website

Re: Strange bug after moving database

FireFusion wrote:

Charset (default/config): latin1/ latin1
21 Tables: OK

Good. Tables use the charset that is configured.

Charset (default/config): latin1/ utf8
21 Tables: textpattern is latin1, txp_category is latin1, txp_css is latin1, txp_discuss is latin1, txp_discuss_ipban is latin1, txp_discuss_nonce is latin1, txp_file is latin1, txp_form is latin1, txp_image is latin1, txp_js is latin1, txp_lang is latin1, txp_link is latin1, txp_log is latin1, txp_nlprefs is latin1, txp_page is latin1, txp_plugin is latin1, txp_prefs is latin1, txp_priv is latin1, txp_section is latin1, txp_subscribers is latin1, txp_users is latin1

Not good. If you moved the old tables over, you must also move the old config.php over, or at least make sure that the configured charset in the config.php is identical. If you haven’t saved anything to the db yet, simply change the config.php to read “latin1”. Otherwise it’s simplest to either resave all the data that was saved since the move, or just do a reimport.

There is more on this in textbook:
http://textbook.textpattern.net/wiki/index.php?title=Unicode_Support#UTF-8_support_in_Textpattern

Alternatively you can also convert your databasetables from latin1 to utf8.
http://dev.mysql.com/doc/refman/4.1/en/charset-upgrading.html

Last edited by Sencer (2007-07-03 06:46:46)

Offline

#6 2007-07-03 07:04:04

FireFusion
Member
Registered: 2005-05-10
Posts: 698

Re: Strange bug after moving database

Thanks Sencer, that’s very helpful.

Offline

Pages: 1

  1. Index
  2. » Archives
  3. » Strange bug after moving database

Board footer

Powered by FluxBB