Thread

Hi, is there any solution about database from 1.x to 2.4. I have same problem, and one logical question - how to improve a diferent tables between weblog and channel, which is a main problem I think? I’ve tried to import old base after blank instalation, but the message is the same.

Hi Danijel,

You want to be careful about modifying the database. I wouldn’t recommend anything for this particular problem outside of the recommendations found here. Could you go into more detail about what you mean with your question on improving tables between weblog and channel? I’m not sure I quite understand.

thank you Kevin on your answer,
I don’t understand the diferences in base for EE 1.x i EE 2.x. in EE1.x syntax is weblog, and in EE2.x is channel. so, that generate table exp_weblog in 1.x base, and exp_channel in 2.x base. I tried to upload 1.x base to use in EE 2.x system, I followed your instructions (unserialize the data), but it didn’t give results. I hope that this clearly describes my problem.

Hello Danijel,

Did you follow the stops that Kevin mentioned?

What results did you get? Where there any errors?

Please let me know.

Cheers,

Hi Shane,
I followed all steps from 1 to 5, except step 6 (6. Now log in to your CP and double-check all your settings and preferences, especially things like site URL and forum theme path, etc.), because I am unable to log in, I have no admin page and no index page, only message “Site Error: Unable to Load Site Preferences; Invalid Preference Data”.

Danijel,

It sounds like you uploaded the full EE 1.x database and overwrote your EE 2.x database. Is that what happened? Did you clearly follow the steps I outlined here and nothing more? You should’ve only modified information in the live site’s database from the exp_sites table. Your mentions of weblog vs. channel have me worried.

Please explain to us exactly what you did.

I’ve followed these steps too and am still getting the same problem. I’ve tried unserializing and base64 reserializing all the prefs columns in exp_sites. Is there anything else that can be done to get the CP to display the log in page?

Actually, never mind. I started the whole thing over again (had to go further back with 1.x updates because even though the config file said it was at 1.6.8 it was missing a column that was added with 1.6.5) and have managed to get it to 2.5.2 without the error.

Hey Tyssen,

I am glad to hear it.

If you need anything else, please let me know.

Cheers,

Hello!!, i have the same error:

An Error Was Encountered

Site Error: Unable to Load Site Preferences; Invalid Preference Data

I followed these instructions:

Hey all,

I’ve got an update after working with Visualis privately. In almost every case where I see the error message “Site Error: Unable to Load Site Preferences; Invalid Preference Data”, it’s caused by corrupted site preferences in the database. Dan alluded to this previously, but I’m going to go into more detail here to help you fix this yourselves.

Disclaimer: You’ll be working directly against your database to fix this. Please make sure you have a reliable backup of your database before proceeding.

It’s my assumption that everyone here experienced this after upgrading from EE 1.x to EE 2.x.

To perform this fix, you’ll need access to your database pre-upgrade (EE 1.x), access to your database post-upgrade (EE 2.x), and some kind of visual DB tool like PHPMyAdmin or Sequel Pro. If you’ve taken a backup of your database before upgrading, as the upgrade instructions strongly recommend, then you can just restore that backup to a new blank database that you’re not using for your site. It helps to have both the pre-upgrade and post-upgrade databases right next to each other, as it were, so that you can quickly switch between the two. You’ll be copying some data from the pre-upgrade DB to the post-upgrade DB.

1. In your EE 1.x database, navigate to the exp_sites table and find the column site_system_preferences. Copy the data from this column.
2. Use the utility at Online PHP Unserializer to unserialize the data. Copy it into the field, do not check the box labeled base64 decode, and click “Unserialize!”
3. Now on the resulting page, scroll down to the bottom, this time do check the box labeled base64 encode, and click “Re-serialize!”
4. Copy the contents of the box titled “Re-serialized output”.
5. Now open up your EE 2.x database, and navigate to the exp_sites table to find the site_system_preferences field. Paste and save here the data you copied from the box in the previous step. (If you’re running an MSM site with multiple rows in your exp_sites table, you’ll repeat steps 1-5 for each one.)
6. Now log in to your CP and double-check all your settings and preferences, especially things like site URL and forum theme path, etc.

That should take care of it. If you’ve followed the steps above carefully and you’re still not finding any resolution, let us know!

But the error is still there.

What can i do??.

Thanks.

Hey Isaacj,

I am sorry to hear you are running into this problem.

Can you run the Server Wizard and tell me what the results are?

Thank you,

Hello!!, i run another webs with EE 2x without problems, i only have the problem when i try to upgrade:

Here are the results:

http://www.isaacj.com/imagenesforo/captura-test-ee2.jpg

Thanks for all.

Hey Isaacj,

One last thing to check. Are you able to connect to the database with a test file using the same configurations?

Thank you,

Yes! :0)

Hey Isaacj,

If we were to login would we be able to get access to your database?

Thank you,