Thread

Apologize for a new post on this since I see that similar posts are out there already, but I have not found a clear cut answer on any of them.  When I try to upgrade (locally OR remotely) from ee 1.6.7 to 2.x I keep running into database errors regarding this file:

Filename: updates/ud_200.php

They all have to do with either a duplicate key or unknown column in a table.  Here is my latest one:
A Database Error Occurred

Error Number: 1054

Unknown column ‘recent_trackback_date’ in ‘field list’

SELECT `recent_trackback_date`, `entry_id` FROM `exp_weblog_titles`

Filename: updates/ud_200.php

Line Number: 647

I’ve followed the upgrade instructions to the letter.  Any advice or if anyone can point me to a thread with the solution is greatly appreciated.

Fixed the above issue, now I have this:
Site Error: Unable to Load Site Preferences; Invalid Preference Data

working on it, but any advice?

Devs, client paid $200 + for this upgrade.  Any advice you can offer?

You guys recommend coming to the forum for support and that your developers are monitoring the forum to help with issues.  I’ve got two emails in to support as well as a couple of posts regarding my issue and haven’t had a single response.  You charge $200 for a product and so far provide less than stellar support for it.  Can you please tell me how I can talk to an actual person by phone?  I’m not asking you to build my site for me, just some general direction with an upgrade issue.

Your initial issue has been resolved? Did your upgrade involve a server move as well? Have you modified the database manually in any way?

PS: According to our support policy we answer all requests in the order that they are received. Our goal is to have a first response to all threads within one business day of posting time.

Initial issue I resolved myself.  Have not modified Database manually in anyway.  Still have this error:
Site Error: Unable to Load Site Preferences; Invalid Preference Data

Trying upgrade locally first and then will move as suggested by someone in this forum

Fifth Letter,

This error could occur if the exp_sites table was truncated at some point. Was the database moved, imported or exported previously? Keep us posted with your progress in trying the upgrade locally.

Site was migrated from one server to another.  The whole reason I am upgrading is because the new server runs php 5.3 which as you know causes a ton of issues with EE 1.6.7.  So yeah, the database was exported from the old server, then imported on the new server.

So what is the resolution the truncation of that table at some point is causing the issue?

Anything I can provide you to help diagnose.  A database dump or anything?

Fifth Letter,

Did the EE upgrade wizard actually complete successfully? What is the value of app_version in your system/expressionengine/config.php file?

It completed successfully.  I received the screen with links to the site and control panel.  This is the value of the app version:

$config['app_version'] = "212";

There is data in the exp_sites table. (I’m not running multiple sites) and in most fields it is serialized.

What else can I tell you to help diagnose?

Hi Fifth Letter,

Can you clarify what you mean when you say most fields are serialized? In EE 2.x those fields should be encoded and not serialized. This is in your upgraded site? Can you please take a screenshot of part of your exp_sites.site_system_preferences field and post it in the thread.

Cheers

Greg

site_id,site_label,site_name,site_description - normal text fields

site_system_preferences,site_mailinglist_preferences,site_member_preferences   site_template_preferences-

Serialized:  ie: a:3:{s:19:"mailinglist_enabled";s💯"y";s:18:"mailinglist_notify";s💯"n";s:25:"mailinglist_notify_emails";s👎"";}

site_channel_preferences:
YjowOw==

site_bootstrap_checksums:  empty

ex_sites didn’t become base64 encoded during the last update, so there’s clearly something going on. Do you have a good, pre-update backup? It might be a good idea to roll back to that state and try again, upgrading to 2.1.3. Should you be running into any issues please stop at one and tell us about it. Thanks.

did the following.  same issue with site preferences:

1) rolled back to previous install
2) downloaded latest build 2.1.3
3) followed instructions from ee docs on upgrading from 1.x to 2.x
4) got a database error for a duplicate key in exp_module_member_groups
5) dumped the database and rolled back
6) removed duplicate entry in that table
7) ran the installer again
8) tells me that I upgraded successfully.
9) followed link to control panel.
10) received the same “Unable to load site preferences” error

What can I provide you to help you diagnose this issue.  A database dump? anything?  is there anybody out there with this same problem.  I see more than a ton of upgrade issues on this forum.  Really at wits end with this.

Does exp_sites look the same as before? It should no longer be a serialized array. Where does the error occur, i.e. to what EE version do you progress normally?

table is still serialized.

I’m trying to upgrade from 1.6.7 to 2.1.3