Thread

After the upgrade from 1.6.8 to 2.1.1 the site wont work, i get the following error:

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

I have restored the exp_sites table, but that dont help me.

Hi, Gert. Did you make any sort of changes to the exp_sites table by editing it?

The exp_sites table from 1.6.x isn’t going to work with EE2.x.

no, i didn;t change anything, before the upgrade. After the upgrade the preferences in the exp_sites have the values ‘czowOiIiOw==’

I had already reverted the upgrade and have now 1.6.8 again. I’m now going to upgrade to 1.7.0 first in the development server and then try again to upgrade to 2.1.1.

Do you know what caused this error, because lots of people had this error i had seen on the forums?

I have made a test section locally and upgraded without any problems from 1.6.8. to 1.7.0. Then I cleared the cache and run the install wizard of 2.1.1, but after the step when the database tables are converting to 2.0.0. the wizard went to a blank screen. Now i get the error :

Fatal error: Call to undefined method CI_Config::site_prefs() in /Users/xxxxxxxxx/javel/expressionengine/libraries/Core.php on line 150

When i look in the exp_sites table this value is in the site_system_preferences field: YToxMDA6e3M6MTU6ImVuY3J5cHRpb25fdHlwZSI7czo0OiJzaG…

I also see the 1.x.x table names, for example i dont see a exp_channel table, but the exp_weblog table still exists ..

What can i do??

Gert,

Can you confirm that all the folders made it up there from your 2.1.1 download like the codeigniter folder?

One other thing to try is. You are renaming your system folder right? Rename it back to system and update any reference to it. Then try the upgrade again

i have tried with the default system folder name, and i still get the blank page after the step where the database is converted to 2.1.1.
I have set the debug variable to 1, and now i get a error message:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 40 bytes) in /Users/xxxxxxxxxx/Sites/xxxxxxxx/system/codeigniter/system/database/drivers/mysql/mysql_result.php on line 147

is this a bug, do i have set the max_upload_size bigger in php.ini??

It looks as though you’re running out of memory, yes. Can you try to increase that amount?

ok, that works, but now i get the following error:

A Database Error Occurred

Error Number: 1153

Got a packet bigger than 'max_allowed_packet' bytes

UPDATE `exp_forum_posts` SET `post_date` = `post_date` + 3600 WHERE `post_id` IN ('6','7','10','...........')

Filename: updates/ud_200.php

Line Number: 662

the list of post_id IN is huge,

Yeah! I have updated to 2.1.1!!!

I have setted the mysql max_allowed_packet to a larger number and now i have succesful updated to the newest version.

Thanx for your support!

Thanks for letting us know. Please post again as needed.