Hi All,
Attempted an upgrade via the GUI and got this.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Member_members.dismissed_pro_banner' in 'field list':
SELECT Member_members.member_id as Member__member_id, Member_members.role_id as Member__role_id, Member_members.username as Member__username, Member_members.screen_name as Member__screen_name, Member_members.password as Member__password, Member_members.salt as Member__salt, Member_members.unique_id as Member__unique_id, Member_members.crypt_key as Member__crypt_key, Member_members.authcode as Member__authcode, Member_members.email as Member__email, Member_members.signature as Member__signature, Member_members.avatar_filename as Member__avatar_filename, Member_members.avatar_width as Member__avatar_width, Member_members.avatar_height as Member__avatar_height, Member_members.photo_filename as Member__photo_filename, Member_members.photo_width as Member__photo_width, Member_members.photo_height as Member__photo_height, Member_members.sig_img_filename as Member__sig_img_filename, Member_members.sig_img_width as Member__sig_img_width, Member_members.sig_img_height as Member__sig_img_height, Member_members.ignore_list as Member__ignore_list, Member_members.private_messages as Member__private_messages, Member_members.accept_messages as Member__accept_messages, Member_members.last_view_bulletins as Member__last_view_bulletins, Member_members.last_bulletin_date as Member__last_bulletin_date, Member_members.ip_address as Member__ip_address, Member_members.join_date as Member__join_date, Member_members.last_visit as Member__last_visit, Member_members.last_activity as Member__last_activity, Member_members.total_entries as Member__total_entries, Member_members.total_comments as Member__total_comments, Member_members.total_forum_topics as Member__total_forum_topics, Member_members.total_forum_posts as Member__total_forum_posts, Member_members.last_entry_date as Member__last_entry_date, Member_members.last_comment_date as Member__last_comment_date, Member_members.last_forum_post_date as Member__last_forum_post_date, Member_members.last_email_date as Member__last_email_date, Member_members.in_authorlist as Member__in_authorlist, Member_members.accept_admin_email as Member__accept_admin_email, Member_members.accept_user_email as Member__accept_user_email, Member_members.notify_by_default as Member__notify_by_default, Member_members.notify_of_pm as Member__notify_of_pm, Member_members.display_signatures as Member__display_signatures, Member_members.parse_smileys as Member__parse_smileys, Member_members.smart_notifications as Member__smart_notifications, Member_members.language as Member__language, Member_members.timezone as Member__timezone, Member_members.time_format as Member__time_format, Member_members.date_format as Member__date_format, Member_members.include_seconds as Member__include_seconds, Member_members.profile_theme as Member__profile_theme, Member_members.forum_theme as Member__forum_theme, Member_members.tracker as Member__tracker, Member_members.template_size as Member__template_size, Member_members.notepad as Member__notepad, Member_members.notepad_size as Member__notepad_size, Member_members.bookmarklets as Member__bookmarklets, Member_members.quick_links as Member__quick_links, Member_members.quick_tabs as Member__quick_tabs, Member_members.show_sidebar as Member__show_sidebar, Member_members.pmember_id as Member__pmember_id, Member_members.cp_homepage as Member__cp_homepage, Member_members.cp_homepage_channel as Member__cp_homepage_channel, Member_members.cp_homepage_custom as Member__cp_homepage_custom, Member_members.dismissed_pro_banner as Member__dismissed_pro_banner, Member_member_data.member_id as Member__member_id, Member_member_data.member_id as Member__member_id, PrimaryRole_roles.role_id as PrimaryRole__role_id, PrimaryRole_roles.name as PrimaryRole__name, PrimaryRole_roles.short_name as PrimaryRole__short_name, PrimaryRole_roles.description as PrimaryRole__description, PrimaryRole_roles.is_locked as PrimaryRole__is_locked, Roles_roles.role_id as Roles__role_id, Roles_roles.name as Roles__name, Roles_roles.short_name as Roles__short_name, Roles_roles.description as Roles__description, Roles_roles.is_locked as Roles__is_locked, RoleGroups_role_groups.group_id as RoleGroups__group_id, RoleGroups_role_groups.name as RoleGroups__name FROM (`exp_members` as Member_members, `exp_member_data` as Member_member_data) LEFT JOIN `exp_roles` AS PrimaryRole_roles ON `PrimaryRole_roles`.`role_id` = `Member_members`.`role_id` LEFT JOIN `exp_members_roles` as Member_Roles_members_roles ON `Member_Roles_members_roles`.`member_id` = `Member_members`.`member_id` LEFT JOIN `exp_roles` as Roles_roles ON `Roles_roles`.`role_id` = `Member_Roles_members_roles`.`role_id` LEFT JOIN `exp_members_role_groups` as Member_RoleGroups_members_role_groups ON `Member_RoleGroups_members_role_groups`.`member_id` = `Member_members`.`member_id` LEFT JOIN `exp_role_groups` as RoleGroups_role_groups ON `RoleGroups_role_groups`.`group_id` = `Member_RoleGroups_members_role_groups`.`group_id` WHERE Member_member_data.member_id = Member_members.member_id AND ( `Member_member_data`.`member_id` = 1 ) LIMIT 1
Roll back didn’t work either.
All our tables are prefixed with exp_ and not members_. Shouldn’t it be shown as “ext_members.member_id” etc?
I just don’t understand why with every single upgrade something always breaks catastrophically.
Hi xcl,
The prefix should be fine, but it’s not seeing the member field ‘dismissed_pro_banner. That field is added in the ud_6_01_00_rc_1.php update, so something must have happened before then. I haven’t seen that particular error, though. It’s an odd one.
If you want to drop me a line at support@expressionengine.com we can figure out what’s going on. If you have the stack trace, send it along, as that will be handy. Also let me know the version you were upgrading from.
I’m a little less sure the GUI works the same, but I can’t see why not.
Go in and edit your config file- system/user/config/config.php - and set the version number back. It will then run through all the update files between whatever you set the version to and the latest version.
So we want to run ud_6_01_00_rc_1.php set it to
$config['app_version'] = '6.0.6';
Make sure your installer folder is in place, and then let’s see if that does the trick.
Hrm- glad it worked, but I agree, it’s really odd it was skipped first time around.
Sometimes things are skipped if people roll back and especially manually roll back the database and don’t delete new tables that were created, just replace existing ones.
But I can’t see that possibly being the case here.
It is odd.
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.