Upgrade from 2.2.1 to 2.8.3 - 504

meshugy

@R_J thanks, your suggestion mostly worked. I was able to update all the tables except GDN_Session. These updates need to be done but MYSQL times out every time, even after 15min:

alter table `GDN_Session`
-- [Existing: `Attributes` mediumtext null, New: `Attributes` text null]
change `Attributes` `Attributes` text null;

alter table `GDN_Session`
add index IX_Session_DateExpires (`DateExpires`);

Is there anyway around this? Do I need the old GDN_Session data or can I just create a new table?

R_J

Not sure about that, though I would assume you log all of your users out of the forum. But what you could try is to

• backup only the data of that table
• prune its contents
• run the above commands
• try to import the data

charrondev

@meshugy That code code snippet would be a lot easier to read if you formatted it with the code style.

meshugy

@R_J Thanks so much for your help. The GDN_Sessions table was over 9GB so I just cleared it and then bingo:

R_J

Congrats!