Thread

Thank you, BB.  I’ve alerted the dev team to your followup and this should get looked at tomorrow.  I also responded with a private email about database access, so please respond to that as we need that information to proceed.

Thank you!

Thanks, I sent the info over.

OK- we pushed the dev server through the upgrade, but it needs a really good browse through to make sure everything is fine.  I believe it originally timed out when going through the utf-8 conversion.  We’re not entirely sure where in that process it failed.  For most sites?  It is likely moot.  I suspect it is moot in your case- all tables are currently utf_8- which means the converter completed the conversion or they were utf-8 to start with.

Which is a long way of saying- I don’t believe there will be any problems there.

The second part of the upgrade I bulled through was a change to dates- how localization was handled changed.  Comments and forums did have the date change applied- the weblog/channel entries?  Did not.  This means there may be a data change of several hours for those entries.  If it’s mission critical for those dates to be accurate?  I should be able to force those changes through, so let me know.

Otherwise- while I did hit the snippets issue again, it was simple to push past and should have no impact on the actual data.

Give things a good, hard look.  And let us know if you are running into any critical issues that need to be addressed.  If we need to, we can step through it again w/a fresh database and ‘force batch’ some problem areas.

And sorry this upgrade has given you such fits!  More elegant handling of large databases during the 2.0 update is being worked on now.  But we can push it through manually now if needed.

Thanks Robin…. definitely some noticeable progress now!

I was able to successfully login to the backend, however I was getting an error when I would try to load the front. The error looked like it was related to the forum.

So I installed the forum module, logged into the backend to try to check configurations & I got

Error Number: 1091

Can't DROP 'topic_id'; check that column/key exists

ALTER TABLE `exp_forum_subscriptions` DROP KEY `topic_id`

Filename: modules/forum/upd.forum.php

Line Number: 830

Also, after the forum_themes folder was added to the themes folder, I started receiving the following error on the front page.

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 1

Filename: libraries/Template.php

Line Number: 933

Please advise.

—
Mike

Nothing is going to be easy on this one, is it?

To double the fun- ftp won’t let me edit the file I need to edit- I get a

‘Could not upload “upd.forum.php”
Error- 160: could not start data transfer

Oddly- I can edit the config file- I put a little test comment in to test.  The forum updater, however, wouldn’t let me save an edit.

Yell back if you spot what’s up there.  I was going to bull through that upgrade like we did the larger update.  Basically, in system/ee/modules/forum/upd.forum.php around line
857

$this->EE->db->query("ALTER TABLE `exp_forum_pollvotes` MODIFY COLUMN `vote_id` int(10) unsigned NOT NULL PRIMARY KEY auto_increment");
            
// ok


// updates stop here

            $this->EE->db->query("ALTER TABLE `exp_forum_boards` CHANGE `board_recent_poster` `board_recent_poster` VARCHAR(70) NULL DEFAULT NULL");

What needs to happen is a very careful commenting out of all of the update progress so far- we don’t need to rerun things.  We need to pick back up with that exp_forum_boards tweak.  It’s not a hard edit- but it’s one that’s easy to introduce a syntax error on.  Normally I’d have just done this for you- but ftp is not playing nicely.

If you can tweak something and want me to try again?  Just say the word.  At the moment, I’m stuck on editing that file.  And I’ll take a look at the template error while you either fiddle w/ftp or try commenting out that bit of code in the update.

ICK- sorry.  I hate having you that deep in code.

And do contact me privately if it seems a better venue- it’s always possible I’m doing something completely oblivious w/ftp.  Don’t think so, though.

Sorry about that. I guess when I installed the forum, the folder didn’t come with group write permissions… but came with execute, that’s why u could edit.

You should be good now.

—
Mike

Weirdness- still wouldn’t take an edit- but let me rename/delete/upload new, so that’s what I did.  Forum cp is loading fine now and I THINK the template issue is squared.  Was just missing a plugin- though why it threw the php error I’m not sure.

Main page looks a little choppy to me, but it will all need a good run through.  Especially w/any third party add-ons in play, may need a bit more updating here and there.

Which was a long way of saying- give it another try 😉

AWE-SOME!!!

You are right about the main page, hopefully that is just some html/css issues.
Thank you very much… I will start picking things apart & let you guys know if I run into anything else.

I hate to bring this up now :D , but after trying every use case we can think of, then we will have to upgrade the live site. So I’m wondering what the suggestion would be there….

Thank you Robin & thank you EE team for all the hours on this one!

—
Mike

Hy, Mike -

The best way to do this is to do the upgrade on in a dev environment, get it working, then move it live.  Because of the difficulty you’re seeing, doing this directly on the live site may not be the best idea.

Make sense?

Hey Lisa,

Yeah I understand that… that is exactly why we have it on the dev env right now.

What I’m saying is…. life goes on with the live site & has since the dump was made for the data that proved successful.

So to avoid the hassle of going back & re-entering 30+ posts & I wouldn’t even know where to begin with all the updates to the forum.

Since I needed you guysesssess :D help for the upgrade, I’m assuming I will again once we have fully tested this & know what needs to be fixed & will be able to accurately plan to upgrade the live site.

I’m thinking ahead on how this will get done once we are done testing..

—
Mike

Hi Mike,

We’ll be here when you need us, but you know that 😊 If there are no objections to closing this down, I’ll mark this resolved.

Mike, you know how to ping us when you have your plan in place.

Best,

Closing older thread.. If anything else comes up, please do let us know in a new thread..