@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?
Comments
@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:
Is there anyway around this? Do I need the old GDN_Session data or can I just create a new table?
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
@meshugy That code code snippet would be a lot easier to read if you formatted it with the code style.
@R_J Thanks so much for your help. The GDN_Sessions table was over 9GB so I just cleared it and then bingo:
Congrats!