We use cookies to help make our site work properly and to analyze how our site is used. Some are optional, but none contain your personal information, and we don't use any for ads. You can view our cookies policy, manage your cookie preferences, or consent and dismiss this banner by clicking agree:

Agree

Bug #23493 See Comments

Error when editing entries after upgrade to 4.0.9

Version: 4.0.9 Reporter: GCT Software —

I get this error when I try to edit an existing entry on the site. No error when publishing new entries.

Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ChannelEntry_channel_titles.status_id' in 'field list':
SELECT ChannelEntry_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_titles.site_id as ChannelEntry__site_id, ChannelEntry_channel_titles.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_titles.author_id as ChannelEntry__author_id, ChannelEntry_channel_titles.forum_topic_id as ChannelEntry__forum_topic_id, ChannelEntry_channel_titles.ip_address as ChannelEntry__ip_address, ChannelEntry_channel_titles.title as ChannelEntry__title, ChannelEntry_channel_titles.url_title as ChannelEntry__url_title, ChannelEntry_channel_titles.status as ChannelEntry__status, ChannelEntry_channel_titles.status_id as ChannelEntry__status_id, ChannelEntry_channel_titles.versioning_enabled as ChannelEntry__versioning_enabled, ChannelEntry_channel_titles.view_count_one as ChannelEntry__view_count_one, ChannelEntry_channel_titles.view_count_two as ChannelEntry__view_count_two, ChannelEntry_channel_titles.view_count_three as ChannelEntry__view_count_three, ChannelEntry_channel_titles.view_count_four as ChannelEntry__view_count_four, ChannelEntry_channel_titles.allow_comments as ChannelEntry__allow_comments, ChannelEntry_channel_titles.sticky as ChannelEntry__sticky, ChannelEntry_channel_titles.entry_date as ChannelEntry__entry_date, ChannelEntry_channel_titles.year as ChannelEntry__year, ChannelEntry_channel_titles.month as ChannelEntry__month, ChannelEntry_channel_titles.day as ChannelEntry__day, ChannelEntry_channel_titles.expiration_date as ChannelEntry__expiration_date, ChannelEntry_channel_titles.comment_expiration_date as ChannelEntry__comment_expiration_date, ChannelEntry_channel_titles.edit_date as ChannelEntry__edit_date, ChannelEntry_channel_titles.recent_comment_date as ChannelEntry__recent_comment_date, ChannelEntry_channel_titles.comment_total as ChannelEntry__comment_total, ChannelEntry_channel_data.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_data.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_data.site_id as ChannelEntry__site_id, ChannelEntry_channel_data.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_data.site_id as ChannelEntry__site_id, ChannelEntry_channel_data.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_data.field_id_24 as ChannelEntry__field_id_24, ChannelEntry_channel_data.field_ft_24 as ChannelEntry__field_ft_24, ChannelEntry_channel_data.field_id_30 as ChannelEntry__field_id_30, ChannelEntry_channel_data.field_ft_30 as ChannelEntry__field_ft_30, ChannelEntry_channel_data.field_id_31 as ChannelEntry__field_id_31, ChannelEntry_channel_data.field_ft_31 as ChannelEntry__field_ft_31, ChannelEntry_channel_data.field_id_50 as ChannelEntry__field_id_50, ChannelEntry_channel_data.field_ft_50 as ChannelEntry__field_ft_50, ChannelEntry_channel_data.field_id_54 as ChannelEntry__field_id_54, ChannelEntry_channel_data.field_ft_54 as ChannelEntry__field_ft_54, ChannelEntry_channel_data.field_id_56 as ChannelEntry__field_id_56, ChannelEntry_channel_data.field_ft_56 as ChannelEntry__field_ft_56, ChannelEntry_channel_data.field_id_57 as ChannelEntry__field_id_57, ChannelEntry_channel_data.field_ft_57 as ChannelEntry__field_ft_57, ChannelEntry_channel_data.field_id_59 as ChannelEntry__field_id_59, ChannelEntry_channel_data.field_ft_59 as ChannelEntry__field_ft_59, ChannelEntry_channel_data.field_id_60 as ChannelEntry__field_id_60, ChannelEntry_channel_data.field_ft_60 as ChannelEntry__field_ft_60, ChannelEntry_channel_data.field_id_61 as ChannelEntry__field_id_61, ChannelEntry_channel_data.field_ft_61 as ChannelEntry__field_ft_61, ChannelEntry_channel_data.field_id_63 as ChannelEntry__field_id_63, ChannelEntry_channel_data.field_ft_63 as ChannelEntry__field_ft_63, ChannelEntry_channel_data.field_id_65 as ChannelEntry__field_id_65, ChannelEntry_channel_data.field_ft_65 as ChannelEntry__field_ft_65, ChannelEntry_channel_data.field_id_67 as ChannelEntry__field_id_67, ChannelEntry_channel_data.field_ft_67 as ChannelEntry__field_ft_67, ChannelEntry_channel_data.field_id_69 as ChannelEntry__field_id_69, ChannelEntry_channel_data.field_ft_69 as ChannelEntry__field_ft_69, ChannelEntry_channel_data.field_id_70 as ChannelEntry__field_id_70, ChannelEntry_channel_data.field_ft_70 as ChannelEntry__field_ft_70, ChannelEntry_channel_data.field_id_71 as ChannelEntry__field_id_71, ChannelEntry_channel_data.field_ft_71 as ChannelEntry__field_ft_71, ChannelEntry_channel_data.field_id_72 as ChannelEntry__field_id_72, ChannelEntry_channel_data.field_ft_72 as ChannelEntry__field_ft_72, ChannelEntry_channel_data.field_id_73 as ChannelEntry__field_id_73, ChannelEntry_channel_data.field_ft_73 as ChannelEntry__field_ft_73, ChannelEntry_channel_data.field_id_74 as ChannelEntry__field_id_74, ChannelEntry_channel_data.field_ft_74 as ChannelEntry__field_ft_74, ChannelEntry_channel_data.field_id_75 as ChannelEntry__field_id_75, ChannelEntry_channel_data.field_ft_75 as ChannelEntry__field_ft_75, ChannelEntry_channel_data.field_id_76 as ChannelEntry__field_id_76, ChannelEntry_channel_data.field_ft_76 as ChannelEntry__field_ft_76, ChannelEntry_channel_data.field_id_78 as ChannelEntry__field_id_78, ChannelEntry_channel_data.field_ft_78 as ChannelEntry__field_ft_78, ChannelEntry_channel_data.field_id_79 as ChannelEntry__field_id_79, ChannelEntry_channel_data.field_ft_79 as ChannelEntry__field_ft_79, ChannelEntry_channel_data.field_id_80 as ChannelEntry__field_id_80, ChannelEntry_channel_data.field_ft_80 as ChannelEntry__field_ft_80, ChannelEntry_channel_data.field_id_83 as ChannelEntry__field_id_83, ChannelEntry_channel_data.field_ft_83 as ChannelEntry__field_ft_83, Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.extra_publish_controls as Channel__extra_publish_controls, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.live_look_template as Channel__live_look_template, Channel_channels.max_entries as Channel__max_entries FROM (`exp_channel_titles` as ChannelEntry_channel_titles, `exp_channel_data` as ChannelEntry_channel_data) LEFT JOIN `exp_channels` AS Channel_channels ON `Channel_channels`.`channel_id` = `ChannelEntry_channel_titles`.`channel_id` WHERE ChannelEntry_channel_data.entry_id = ChannelEntry_channel_titles.entry_id AND ( `ChannelEntry_channel_data`.`entry_id` = '219' AND `ChannelEntry_channel_data`.`site_id` = 1 ) LIMIT 1
ee/legacy/database/drivers/mysqli/mysqli_connection.php:116

Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('SELECT ChannelE...')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('SELECT ChannelE...')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('SELECT ChannelE...')
#3 ee/legacy/database/DB_active_rec.php(1137): CI_DB_driver->query('SELECT ChannelE...')
#4 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(48): CI_DB_active_record->get()
#5 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Select->run()
#6 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(227): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery('Select', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#7 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(143): EllisLab\ExpressionEngine\Service\Model\DataStore->selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#8 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(54): EllisLab\ExpressionEngine\Service\Model\Query\Builder->fetch()
#9 ee/EllisLab/ExpressionEngine/Controller/Publish/Edit.php(381): EllisLab\ExpressionEngine\Service\Model\Query\Builder->first()
#10 [internal function]: EllisLab\ExpressionEngine\Controller\Publish\Edit->entry('219')
#11 ee/EllisLab/ExpressionEngine/Core/Core.php(240): call_user_func_array(Array, Array)
#12 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#13 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#14 admin.php(147): require_once('...')
#14 admin.php(147): require_once('...')
Report Bug

Sort Bugs

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

ExpressionEngine News!

#eecms, #events, #releases

© Packet Tide, All Rights Reserved. Legal Notices

Formatting Cheatsheet

ExpressionEngine implements Markdown Extra and BBCode. Please see the Markdown Extra docs and the BBCode Wikipedia article for a full reference.

Inline styles

**bold**, __bold__, *italics*, _italics_, ~strike/del~, `code()`
bold, italics, strike/del, code()

Links and Images

Link: [link title](https://example.com)

Image: ![alt text](https://example.com/image.jpg)

Quoting

[blockquote]...[/blockquote], [quote]...[/quote], and Markdown style:

> Some quoted text.
>
> This is all one quote.

Code Samples

[code]...[/code], and you can also specify the language for syntax highlighting, [code=php]...[/code]

GitHub flavored Markdown code fences are also supported:

```
public function decoderRing($str)
{
	return str_rot13($str);
}
```

Username

Password

Forgot password?
or Register