Fixing old EE site - v6 - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Templates_templates.enable_http_auth' in 'field list':
How Do I?
Hello everyone, I’m trying to repair an old installation of EE. Anytime I click on the templates portion of the admin area, I get the attached message. I cannot edit the site unfortunately.
Does anyone have any suggestions? I’ve google’d quite extensively for this but still haven’t find the answer.
That’s pretty interesting. I can’t seem to see the first image, only the MySQL error and stack trace.
Was this table manually modified?
If you run the following MySQL query on your database, it should add the missing column (my test worked again there after). I would recommend backing up your exp_templates table first.
ALTER TABLE exp_templates
ADD enable_http_auth CHAR(1) NOT NULL default 'n';Thanks,
-Tom Jaeger
Thanks for your recommendation. This is what I am looking for.
If you’re using an older version of ExpressionEngine, consider upgrading to the latest version. This might resolve compatibility issues and include the necessary column definition. Buckshot Roulette