Thread

Hello all,

I was attempting to update a site from version 1.6 to 2.8 and i followed all the instructions from:
http://ellislab.com/expressionengine/user-guide/installation/upgrade_from_1.x.html

the updating wizard installed and ran fine up until the update processing just froze. So i left it for a few hours, but it was still stuck at the same update progress, so I stopped it and tried again, same issue. So now I reverted back to version 1, while i figure out alternate ways to upgrade.

But after deleting the ver 2 admin.php, index.php, system and themes folders and renaming the ‘_old’ files back to active ones, Im getting this error when loading any page of the website:

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

All of my files are version 1 files, so now im stuck and don’t really know how to revert back to the version 1 EE and have the original website load

Any help would be great!

Thanks

Also I can’t even access the admin/login for CP…

Did you also revert the database back to what it was before you attempted the upgrade?

the original site was developed by someone else and i don’t think i was given any admin rights for the databases, all i have access to is the client’s ftp, would the database be housed there?

The database is not housed in the same place as the files.  Can you get your host to restore from backup to before the site was upgraded?  Once you get the files and the database restored, you can locate the config.php file and see what the username, password, and database names are.  You can then make backups of all the files and database yourself and will always have the potential to restore until you can get the upgrade to work properly.  Do you already have the saved version of config,php?  You would need that file from your previous install to properly install version 2.8. 

Great, thanks for that tip, i found database/user/pass in the config.php file and logged into the database, do you know how i can restore from a backup?

Or is that something only the host can do?

(see attached for what the SQL page that im working with looks like, hope this can help somehow…)

Thank you!

*phew* thankfully i figured out how to restore from previous database backup and it fixed it!

thank you Ethereal for all your help 😊

Now….how the heck do i upgrade the system without the errors…i seemed to do all the upgrading steps properly…

First thing make sure your server is compatible with EE 2.0+ 
Go to http://ellislab.com/expressionengine/user-guide/installation/requirements.html
Find the Server Compatibility Wizard and run it on your server to ensure it meets all the requirements.

Ran the Wizard and everything is supported 😊

The problem I’m having with upgrading from 1.6.7 to version 2 is that the templates need to be converted from version 1 to version 2, since version 2 has “templatename.group’ and version one is just folders

The problem here is that when upgrading the preferences data is being encrypted.

When you run the script once: It goes OK.
If anything breaks, crashes or goes wrong and you re-run the script the table data is encrypted twice and EE cannot read it anymore.

For a developer it is not so hard to find the double encrypted data and decrypt it (it’s base64 on top of my head) until he/she has human-readable text. Then he/she encrypt it once and place it back in the database. 

If you are not so much developersavvy you should make more backups. 😊

Ran the Wizard and everything is supported 😊

The problem I’m having with upgrading from 1.6.7 to version 2 is that the templates need to be converted from version 1 to version 2, since version 2 has “templatename.group’ and version one is just folders

Well. Is your template data not also in the database?
If so , move the template files and let EE2 place the new ones in your filesystem.

I am upgrading from 1.6.9 on Ubuntu to 2.10.1 running on Centos x64.
After updating the restored database with tables none existent in 1.6.9 and running the un-serialize and re-serialize(with base64) on all data in ex_sites table I hit a wall.  I cannot re-serialize the data in site_pages table.  The table is of type longtext while the rest of the tables are text.  The upgrade process stopped at Core version 2.7.3.  Think if I can get the data in site_pages to re-serialize i will be good until I hit the next wall.  Again, I can un-serialize the data but cannot re-serialize the data and place in data table.