Thread

Hi!

I am in the process of updating a 1.6.7-Site to 2.5.x.

My first step ist to move all data and db from my 1.67 site to rebuild it on my local MAMP-Setting. I have done this. I have changed file-permissions as usual, changed the settings for database in config.php and everything seems to work.

My Problem is: I cannot login to the control-panel! I get the unstyled boxes for name/password, fill it out and send it up, only to land on a blank page with a cookie or whatever in the url. no control panel at all, not even unstyled!

Also i see the main-page of my site unstyled but without the mysql-data loaded. Testing the db-connection didn’t get my any errors.

Could this have to do with slightly different mysql-versions on both servers?

Could someone please help me out?

TIA,

Bernie

I tracked it down to a PHP-Version/EE-Extension Konflikt.

Only thing missing now is cp-css, i may get this one too

Thanks!

1.6.7 to 2.5.x is a huge difference.
I hope you fixed it!

How is your progress?

1.6.7 to 2.5.x is a huge difference.
I hope you fixed it!

How is your progress?

The movement of 1.67 to my mamp-install worked with extensions=“n” OR downgrading PHP to 5.2x.

Then i tried to update to 2.52, which failed at some point, i cannot get to the cp nor to the site because he said “Site Error: Unable to Load Site Preferences; Invalid Preference Data”, thats where im stuck at at the moment.

As far as i understand there are some tables in the db which didn’t belong to ee which may i have to delete (tables or rows from old extensions). I don’t know if it helps to delete this rows. i may try it, but didn’t have much hope.

So i may end up re-building the site with 2.5.2 and importing the content thereafter.

Hello Bernie_the_one,

Where are things now? How can I help you? Sounds like you were able to get upgraded but are getting that error. I can help you with that error if you are still in the same place. You mentioned rebuilding the site and importing the content.

Please let me know where you are in the process and we can go from there.

Thanks Bernie,

Hello Bernie_the_one,

Where are things now? How can I help you? Sounds like you were able to get upgraded but are getting that error. I can help you with that error if you are still in the same place. You mentioned rebuilding the site and importing the content.

Please let me know where you are in the process and we can go from there.

Thanks Bernie,

Shane,

thanks for asking! Yes, i stuck at this error-message and don’t know how to procede without rebuilding the whole thing. As i understand the problems are from extensions/plugins or modules and content which are only editable/seeable in the cp if the extensions are there. So, i don’t know exactly how i should proceed with the whole thing, how can i get the site updated without rebuilding the whole site?

i think the offending extensions plugins are one of these:

- Photo Gallery Extended (solstice, never used)
- LG Polls
- SAEF-Calendar
- MarkyPants 1.0.2
- SmartyPants 1.0.2
- Markdown 1.0.1f
- HTML-Stripper 1.0.1
- LogMein 1.2
- Image Sizer 2.5.5
- Textile (v.1.1.1 (2.0.0 r2779
- Edit this 1.1.0
- LG Better Meta 1.7.1
- YearList 1.2
- Randomizer 1.0
- FieldFrame 1.1.2
- moxiecode_auth (v.0.2.0)
- Markitup 1.6.1
- Snitch 1.1.0
- Edit Tab AJAX (v.1.2.2)

and maybe some others, but these are the main pack.

I disabled all 3rd Party extensions and modules for the update, i got one message because of offending templates, but if i click go without templates the update runs till the end without problems. After that i try to login and it failed with the message mentioned with preference data not valid.

Have you some tipps for me?

TIA, if i can take over 70 - 80 % of the site it would be a big help and the customer would be glad to spend the cost for the upgrade.

cheers,

Bernie

Hey Bernie_the_one,

Do you have a backup of the old database, the one before the upgrade?

Thank you,

Hey Bernie_the_one,

Do you have a backup of the old database, the one before the upgrade?

Thank you,

Yes, i have, i too have the old site running here: http://gelnhaeuser-tafel.de.dd20202.kasserver.com

Bernd

Hello Bernie_the_one,

I think your issue is caused by corrupted site preferences in the database. I know, brilliant deduction given the error. 😊

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 me know!

Thank you,

Shane,

thank you very much for this great support! I was able to follow your directions and i am now back in the game.

It was possible to get to the CP and login to the 2.5.3-Site, alter path for themes and no can go on from there. The site itself want work at this stage because it throws errors for field types from third party extensions at me, but i think i can fix that step by step.

Again, thank you very much for the great help, if i stumble upon something i may come back to this thread or post to the 2.x-Forum.

all the best,

Bernd

Hey Bernie_the_one,

AWESOME! Glad to hear it. My pleasure to help!

If you need anything else, please just let me know by opening a new thread.

Cheers,