Thread

Hello.  I am attempting a migration from an old server running EE 1.5.1 to a new one running 1.7 ; should should I do to fix the below errors?  Thank you.

MySQL ERROR:

Error Number: 1054

Description: Unknown column ‘site_id’ in ‘where clause’

Query: SELECT member_id, admin_sess, last_activity FROM exp_sessions WHERE session_id = ‘0’ AND ip_address = ‘68.89.173.159’ AND user_agent = ‘Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en’ AND site_id = ‘1’

Another:

MySQL ERROR:

Error Number: 1054

Description: Unknown column ‘m.ignore_list’ in ‘field list’

Query: SELECT m.weblog_id, m.tmpl_group_id, m.username, m.screen_name, m.member_id, m.email, m.url, m.location, m.join_date, m.last_visit, m.last_activity, m.total_entries, m.total_comments, m.total_forum_posts, m.total_forum_topics, m.last_forum_post_date, m.language, m.timezone, m.daylight_savings, m.time_format, m.profile_theme, m.forum_theme, m.private_messages, m.accept_messages, m.last_view_bulletins, m.last_bulletin_date, m.display_signatures, m.display_avatars, m.last_email_date, m.notify_by_default, m.ignore_list, m.upload_id, m.cp_theme, m.quick_links, m.quick_tabs, m.template_size, g.* FROM exp_members AS m, exp_member_groups AS g WHERE g.site_id = ‘1’ AND unique_id = ‘28a731354cde744b7d37079e10de40c573e387b1’ AND password = ‘8a59fe6e61a58c4b722c20351afdad1547ebe69d’ AND m.group_id = g.group_id

Welcome to the ExpressionEngine forums, dperis.

Since you’re new to the EE forums, have you seen EEWiki:// How to Post a Support Request?

How did you attempt to upgrade? Did you run update.php from the /system folder? Do you have a good backup of your database?

Thanks Sue.  I’m wondering if it is possible to get an older version of Expression Engine (1.5.1) as I am trying to migrate an old installation to a new server, but I only have the database and not the old version of EE, and of course I’m in a hurry.  I’m currently getting this error:

MySQL ERROR:

Error Number: 1146

Thanks!

Hi, dperis. In that case, you’ll need to do the upgrade on the new server. We don’t have older versions available for download.