ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Upgrade error: Unknown column 'protect_javascript' in 'field list'

July 18, 2014 1:54am

Subscribe [2]
  • #1 / Jul 18, 2014 1:54am

    morganbird

    1 posts

    I’m attempting to upgrade from 2.1.3 to 2.9 (I realize this should have been done before now; just took over this site recently). The upgrade fails at 2.5.5 with the following error:

    Error Number: 1054

    Unknown column ‘protect_javascript’ in ‘field list’

    UPDATE `exp_templates` SET `template_id` = ‘36’, `site_id` = ‘1’, `group_id` = ‘10’, `template_name` = ‘.client_name’, `save_template_file` = ‘n’, `template_type` = ‘webpage’, `template_data` = ‘{exp:channel:entries channel=\"projects\" entry_id=\"{embed:project_entry_id}\” limit=\“1\” dynamic=\“off\”}\n\n{work_client}{work_client:title}{/work_client}\n\n{/exp:channel:entries}’, `template_notes` = ‘’, `edit_date` = 1405662666, `last_author_id` = ‘1’, `cache` = ‘n’, `refresh` = ‘0’, `no_auth_bounce` = ‘’, `enable_http_auth` = ‘n’, `allow_php` = ‘n’, `php_parse_location` = ‘o’, `hits` = ‘0’, `protect_javascript` = NULL WHERE `site_id` = ‘1’ AND `template_id` = ‘36’

    Filename: /home/skeo/webapps/skeo_dev/system/expressionengine/models/template_model.php

    Line Number: 389

    I tried manually adding a protect_javascript column of type char(1) (guessed based on documentation) but I still get the error. Anyone encountered this? I’ve seen discussion of this happening in other upgrades with other fields but not this one.

  • #2 / Aug 07, 2014 5:47pm

    earthisland

    46 posts

    Hi, I’m replying with hope that this topic will get bumped… I’m attempting an upgrade from 1.69 to 2.9 (I know, I know) on my dev server, and have encountered the same error. Thanks!

  • #3 / Aug 07, 2014 6:06pm

    earthisland

    46 posts

    Hi,
    I just got a super-speedy reply from EllisLab referencing a bug-fix:

    https://support.ellislab.com/bugs/detail/20479/updating-from-2.7-or-older-to-2.9-you-can-hit-a-mysql-error

    giving it a shot now!

    5 minutes later: worked right away.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases