IMCDb Forum
General » Maintenance planned for 2007-04-12 & 13
Category:  
« Previous topic
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 12/04/2007 @ 10:19:04, By antp
The site will be set to "read-only" for one hour or less (i.e. addition of new comments & cars will be disabled for that time) for doing a test of MySQL 5 instead of current version 4.
This will be done this evening (CET timezone); I'll add a notice for admins a little before I do that.

Next step (friday if everything goes well) is to switch to the "SQLLarge" option of our hosting company, as the database is becoming to big. Except if a problem occurs, this will be done in few minutes (then again I'll have to set the site to "read-only" for that time).

Latest Edition: 12/04/2007 @ 10:19:12
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 12/04/2007 @ 20:31:04, By antp
At first sight, it seems to work well.
I'll wait few time before removing the "read-only" lock, please check that everything displays fine (i.e. no error), report me anything unusual (except the fact that all admin links are disabled, of course :grin: )
First advantage of the change: ÖAF is now listed with the other "O" makes, but it is still not at its real place. Büssing is not more accurately sorted.
I suppose that the "ü" & "ö" are not considered as "u" & "o" by the sorting engine of mysql, but rather as separate characters, respectively between u/v & o/p. To have German characters properly listed, I have to set sort to "German" rather than "general" West-Europe. I am not 100% sure that this does not have side-effects on non-German accent characters, so for the moment I'll keep "general".
A solution would be using full unicode: it would allow anything, including East-European characters, and sorting would be better from what I understand in MySQL documentation. But I am not sure that PHP supports that properly, and it would anyway require many changes. So that will be for later.

Latest Edition: 12/04/2007 @ 21:09:30
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 12/04/2007 @ 22:22:19, By Ralph
the right translation for
ä, ü, ö is ae, ue, oe
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 12/04/2007 @ 22:26:20, By antp
Indeed. But that is only available with "German2". In "German1" (what I called "German" above) it translates to the same letter without accent.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 13/04/2007 @ 21:40:25, By antp
I started the upgrade for the database (to have a 100 MB limit instead of current 50, as the database is 47 M)
I hope that it will work fine. If it is the case within few minutes maintenance will be finished.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 13/04/2007 @ 21:49:25, By antp
That seems to work fine...
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 14/04/2007 @ 00:59:09, By wickey
ok on my side :lol:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 15/04/2007 @ 02:02:02, By wrenchhead
I see no differences so far
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 15/04/2007 @ 11:11:17, By antp
So that means that it worked fine :smile:
Now that the site is on MySQL 5, I may be able to add some interesting functionalities, like a "See new comments on pages where I posted".
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Maintenance planned for 2007-04-12 & 13
Published 15/04/2007 @ 13:50:39, By wickey
ooooooh, that will be great :tongue: thanks in advance
Add Reply - Category:  
Sign In :: Sign Up :: Lost your login or your password?
KelCommunity.be :: © 2004-2024 Akretio SPRL :: Powered by Kelare