Thread

Hey Folks,

I’m trying to move my EE site from one host to another. Everything seems fine (Control Panel works great, I can edit content etc) but all the templates just display gibberish. See http://gracechurchkelseyville.bitsculptor.com/go as an example

I tried just making an “Hello world” template that only spit out that text—but it just spit out gibberish (a small amount, but still gibberish).

Any ideas?

Here’s my “Hello world” page, if it helps: http://gracechurchkelseyville.bitsculptor.com/go/test

eschlange,

Can you walk us through the steps you used to move to the new host please?
Specifically how you moved the database itself
Can you run our Server Wizard on the new host and make sure it meets our requirements

What version and build of EE are you running?

Hi John,

I used phpMyAdmin on the old and new servers. Exported it from the old as a compressed file with mySQL 4.0 compatibility (because the uncompressed was too large to import, and I had a funky SQL statement error when importing it without the compatibility thing). Imported it with mySQL 4.0 compatibility on the new server.

Just ran the wizard, and it said everything looks good. This site is on EE version 1.7.1

I’m thinking it HAS to be something with the db. I just set up an EE 2.x site on the same server and it’s working fine.

I just tried redoing the export/import of the DB. This time without any compatibility, but still gzipped. Everything worked fine—except the pages are still gibberish! I’m going to try other db options now and see if it makes any difference…

Haven’t figure out another way to import the db, since it’s large enough (4.5MB) that I can’t import it using phpMyAdmin unless it’s compressed.

Both DBs are using the same collation (utf8_general_ci), and are MyISAM.

Here are settings from the phpMyAdmin homepages on both servers.

Old Server:
Server version: 5.0.51a-3ubuntu5.8
Protocol version: 10
MySQL charset: UTF-8 Unicode (utf8)

New Server:
Server version: 5.1.55
Protocol version: 10
MySQL charset: UTF-8 Unicode (utf8)

Progress!

I unchecked “Enable GZIP Output?” from at System Preferences ›  Output and Debugging Preferences

And now it’s at least showing page content.

Alright, so I got the site pages loading properly.

Now my last question is—how can I enable GZip output? Site’s working great, except if I enable that it goes back to gibberish.

Any ideas?

eschlange,

When viewing the “Hello World” test link you provided I see your server responds with

Content-Encoding:gzip

so it appears to already be GZipped regardless of EE’s setting. Enabling GZip in EE is actually compressing the data twice, which will give the symptoms you saw earlier. Is everything else working for you?

Everything else is, Brandon.

You are correct. GZip was enabled on the server. So I guess I can just leave that setting unchecked in EE, eh?

eschlange, yes leaving unchecked will be a suitable solution. Did you have any more questions regarding this topic or are you happy for us to close this one out?

Happy to have it closed. Thanks!

Cool. Thanks eschlange!