How to turn off gzip without using admin?

[beyerg]

Hi,

I need to know how to turn off Gzip NOT from the Admin interface but by editing a configuration file.

Scenario - I got hacked. I scrubbed and restored all of my .php files that got corruputed (with excecption of Admin and Catalog /includes/configure.php which were write protected anyway)

Now when I try to load either my Catalog or my Admin, I get a browser message "The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression."

Something is still wrong with Gzip and to get my site and Admin control back , I'm going to disable it for the time being.

I know how to turn it off in Admin - but obviously cannot login to do that. Now, there must be a setting in some configuraiton file that I can swap the 1 to 0 and turn off Gzip. Been all over these forums and Google but can't find the TEXT based method for turning off Gzip.

I do not have access to the Apache server config files as I am on a shared system, so need to turn it off in MY zen-cart only

Thanks all!

[DrByte]

Run this MySQL query on your database:

update configuration set configuration_value=0 where configuration_key='GZIP_LEVEL';

[Steven300]

Are you able to login to phpMyAdmin? If so, go to the configuration table and find the row with configuration_id 304. For that row, change the configuration_value field to 0.

Edit: Or use DrByte's method.

[DrByte]

The configuration_id may or may not be 304 for you. Better to use the configuration_key value.

[beyerg]

Run this MySQL query on your database:

update configuration set configuration_value=0 where configuration_key='GZIP_LEVEL';

Boo-YEAH!!!

You guys are FANTASTIC. Site is back (with full error logging at the moment) and I've got my Admin interface again.

Kick-aZZ. Thank you, thank you, Doc!

Now to function test the site and harden the heck out of it.

Anyone listening to this thread---read and DO: https://www.zen-cart.com/tutorials/index.php?article=73 (How can I protect my site from malicious attack? Security Recommendations)....or you will be kicking yourself in the rear when you get hacked. I've learned my lesson.

[veronicathecow]

Many thanks for this tip. I had just tried to set compression to one and then lost all admin functions with the error message...

Running the query fixed it.
Cheers
Tony