Upgrade to 2.0.15

[jeep]

Well, there are several changes required for the upgrade to 2.0.15 and I've got them all coded. I'll put the new code in place in about 7 hours. If you see a little blip in accessibility, it's probably me. Don't worry about reporting them.

mith, you may notice that admin tasks get more annoying because you'll have to reauthenticate more often.

-JEEP

[jeep]

As soon as the DB backup finishes, I'm going to make the db changes.

-JEEP

[jeep]

Well, this goes SLOWLY. It currently says "optimizing tables". Been on this for an hour and a half. I'll let it run overnight and finish up tomorrow, I hope.

-JEEP

[jeep]

Test, things are complete, but something isn't right.

[jeep]

test

[MeMe]

Well, the site is racing now -- but I got this error when trying to edit the first post in the regular queue (and something like it -- possibly identical -- when I deleted a double post in the mini game I'm running):

-----------------
Error in deleting post

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MYI'. (errno: 145)

DELETE FROM phpbb_search_wordmatch WHERE post_id IN (95782)

Line : 433
File : functions_search.php
-------------------

And I got this error when posting a reply with an embedded quote in newbie 110:

-------------------
Could not insert new word matches

DEBUG MODE

SQL Error : 1196 Warning: Some non-transactional changed tables couldn't be rolled back

[MeMe]

Whoa -- when I just submitted the post above, I got this error:

---------------

Could not insert new word matches

DEBUG MODE

SQL Error : 1196 Warning: Some non-transactional changed tables couldn't be rolled back

[MeMe]

(Got another error message with that last post -- but that's not really the point here)

I just noticed that the list of words I'm getting in the error messages contain words from the post I made in the newbie game. Weird.

[jeep]

Basically, we lost the MYI file for the table: phpbb_search_wordmatch

The repair timed out on me several times. I'll get it working.

-JEEP

[Yaw]

New issue -- the front page doesn't seem to be updating with new posts. The total post count doesn't go up, and the new post doesn't appear in the right-hand column of the forum.

[Someone]

I've been noting the same kind of errors as MeMe. If I get any more I'll be sure to Copy and post them.

In other news the site speed is sweet!

[Iammars]

I'm not sure this is necessary to point it out, but I just learned how to do this, so I'll show you what i got when I tried to quote Warpy and Yos2 in Checkmate.
A screenshot

[jeep]

Yeah, I know about the problem but cannot fix it from here. I've sent mith instructions, so if he has time, perhaps he can run the command.

In the middle of the update, MySQL went down and we wound up with a corrupted file. I tried to repair it through the web tools, but they time out. I need to do it from the command line. I can't ssh to the server from work.

-JEEP

[jeep]

This issue should be fixed now.

-JEEP

[MeMe]

Oh wow - it is. Just updated the front post in the regular queue and it took about 3 seconds to accept the changes (as opposed to the usual 2 minute minimum).

I'm so amazingly giddy.

[jeep]

Yeah, the upgrade did some optimizations and I did some cleaning up when I did the upgrade. It's possible that the index was flakey to begin with, since mysql died when we got to doing that optimization. I actually had to repair the table.

-JEEP