[Error Message] Encoding/MySQL 5.5?

[Error Message] Encoding/MySQL 5.5? - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: [Error Message] Encoding/MySQL 5.5? (/thread-146050.html)

Encoding/MySQL 5.5? - ArieKatz - 2013-09-29

Hey all,
I moved to a new server and trying to upload my old MyBB forum to it (1.6.8).

I'll try to give as much information as possible so you can help me (Before I pay to my hosting for that service...)
(The forums TEXT in in Russion)

OLD SERVER INFO

Database server

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.1.70-cll - MySQL Community Server (GPL)
Protocol version: 10
User: ***@localhost
Server charset: UTF-8 Unicode (utf8)

Web server

cpsrvd 11.38.2.7
Database client version: libmysql - 5.0.96
PHP extension: mysql Documentation

MyISAM is the default storage engine on this MySQL server.
Unicode (multilingual), case-insensitive (Default)

DUMP FILES (QUICK MODE)

STRUCTURE
Link

DATA
Link

New server info

Server: Localhost via UNIX socket
Server type: Percona Server
Server version: 5.5.32-31.0-log - Percona Server (GPL), Release rel31.0, Revision 549
Protocol version: 10
User: ***@localhost
Server charset: UTF-8 Unicode (utf8)

InnoDB is the default storage engine on this MySQL server.
Unicode (multilingual), case-insensitive (Default)

cpsrvd 11.38.2.7
Database client version: libmysql - 5.0.96
PHP extension: mysql Documentation

Link to OLD (WORKING**) Forums
Forums

Link to NEW (ENCODING???**) Forums
Forums

Some notes:
* If you go to the OLD forums and click any link you will get different file! It something with the encoding in the database?
** So except deleting BOM, when I upload the DATA file I'm getting this error
*** Moving Joomla! does not did this kind of problem.
**** New server is running Server version: 5.5.32-31.0-log - Percona Server - Old server is running MySQL

  #1062 - Duplicate entry 'internal_settings' for key 'PRIMARY'

After DELETING all lines with "internal_settings" (3 lines) AND DELETING NULNULNUL**** The data file load without errors BUT the forum.videoculinary.ru looks like it has an encoding error...

Help please.

Thanks in advance

RE: Encoding/MySQL 5.5? - Matt - 2013-09-29

This looks like a file issue, not MySQL. What did you use to upload all your files?

RE: Encoding/MySQL 5.5? - ArieKatz - 2013-09-29

Thank you for the quick replay,

I tar(ed) first, then Gziped. Upload and extracted.

FileZila + Cpanel

Edit: BTW - the Admin Panel is working without any problems or errors.

Edit 2: Installed on wampserver (local) And everything works just fine

local MySQL info

Server: localhost (localhost via TCP/IP)
Software: MySQL
Software version: 5.5.24-log - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)

Apache/2.2.22 (Win64) PHP/5.3.13
Database client version: libmysql - mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $
PHP extension: mysqli Documentation

SOLVED!

It was caused by the following PHP variable which was enabled on the server:

zlib.output-compression

http://php.net/manual/en/zlib.configuration.php

The behaviour of these functions is affected by settings in php.ini.

The zlib extension offers the option to transparently compress your pages on-the-fly, if the requesting browser supports this.