Thread

Oh! Well that might be something important… Are you saying that PHP would run out of memory during your upgrades? If so, what was your response when that would happen?

Kevin

It would say something along the lines that exp_snippets exists, etc. On which I read that was a PHP issue on the server part.

I’m almost done deploying on the Live server and I’ll give it another go.

I’ll report back in a few.

Thanks Kevin.

— V.

Hey Valon—

Any updates on getting that installation deployed to a live server? Also, try the upgrade again from the beginning and let me know about ANY errors you get along the way… PHP, MySQL… any error at all.

Thanks,

Kevin

Hi Kevin & thanks for the follow up —

After deploying to a Live server, I took another stab at the upgrade & it worked (besides a glitch, read far below). However, before doing so I had to do two things:

1. alter table exp_weblog_data change entry_id entry_id int unsigned (which got rid of the 1075 Error)
2. Remove few duplicates on my exp_category_posts

Everything ran smooth all the way up to the upgrade.

However, after trying to access my CP or Homepage, I’m getting this error:

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

(!?) Ran my fingers through the forums again & didn’t want to mess with the DB on my own.

Any quick fixes on this one? OR Should I get you up and going inside the guts of my DB?

Thanks Kevin for your help & dedication. I’m thinking we’re one hurdle away from the finish line.

— Valon.

Valon,

Can you share what’s in your config.php please and just edit out any private info?

Hi John —

Do you want config.php info pre or post upgrade to 213.

— V.

Post please. I have seen that error come up if there was something in the config that didn’t need to be there

Hi John —

Sharing the top part of the file config.php
down to // END EE config items

$config['app_version'] = "213";
$config['install_lock'] = '1';
$config['license_number'] = '';
$config['debug'] = '1';
$config['cp_url'] = 'http://';
$config['doc_url'] = 'http://expressionengine.com/docs/';
$config['is_system_on'] = 'y';
$config['cookie_prefix'] = '';
$config['allow_extensions'] = 'y';
$config['multiple_sites_enabled'] = 'n';
$config['disable_all_tracking'] = 'y';
$config['relaxed_track_views'] = 'y';
$config['trackbacks_to_comments'] = 'n';
$config['archive_trackbacks'] = 'n';

— V.

That’s odd. If you have Multiple Site Manager disabled, that error shouldn’t come up at all. From both your EE1 and EE2 databases, could you run this query and PM me the results? (Don’t post them here, could pose a security risk.)

SELECT es.* FROM exp_sites AS es WHERE es.site_id = '1'

For reference, here’s how you can do that within EE1, and within EE2, go to Tools > Data > SQL Manager > Database Query Form.

Thanks again for your patience on this, Valon!

Kevin

Hi Kevin — I have both those queries ready / but cannot PM you for some reason !?

— V.

Sorry, apparently we have those turned off. Just email them to me: .(JavaScript must be enabled to view this email address).

Hi Kevin —

Did you get a chance to look at the SQL results I sent over.

Thanks for the help man. Much appreciated.

— Valon.

Hi Kevin —

I’ve decided to go into a fresh EE213 Install and manually re-enter 2000+ entries.

Upgrading to 213 from 171 has proved to a be a true nightmare — not worth it :/

Many thanks to you for trying to help. Much appreciated.

Cheers.

— Valon.

Hi Valon,

Kevin will be around again next week. We are keen to help you figure this out but if you wish us to close this thread then we’ll do so.

Cheers

Greg

Hi,

I am having exactly same problem.

ALTER TABLE `exp_weblog_data` ADD PRIMARY KEY `entry_id` (`entry_id`)

If I remove multiple records with entry_id = 0 and run the update again it gives this:

CREATE TABLE `exp_snippets` ( `snippet_id` int(10) unsigned NOT NULL auto_increment, `site_id` int(4) NOT NULL, `snippet_name` varchar(75) NOT NULL, `snippet_contents` text NULL, PRIMARY KEY (`snippet_id`), KEY `site_id` (`site_id`) )

If I insert IF NOT EXISTS into the query - it works obviously but then next query doesn’t - exactly same problem and so on and so forth.

Should I try to update to an older version maybe?

Thanks!