General » Maintenance planned for 2007-04-12 & 13
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
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
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 )
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
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 )
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
Maintenance planned for 2007-04-12 & 13
Published 12/04/2007 @ 22:22:19, By Ralph
the right translation for
ä, ü, ö is ae, ue, oe
ä, ü, ö is ae, ue, oe
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.
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.
I hope that it will work fine. If it is the case within few minutes maintenance will be finished.
Maintenance planned for 2007-04-12 & 13
Published 13/04/2007 @ 21:49:25, By antp
That seems to work fine...
Maintenance planned for 2007-04-12 & 13
Published 14/04/2007 @ 00:59:09, By wickey
ok on my side
Maintenance planned for 2007-04-12 & 13
Published 15/04/2007 @ 02:02:02, By wrenchhead
I see no differences so far
Maintenance planned for 2007-04-12 & 13
Published 15/04/2007 @ 11:11:17, By antp
So that means that it worked fine
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".
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".
Maintenance planned for 2007-04-12 & 13
Published 15/04/2007 @ 13:50:39, By wickey
ooooooh, that will be great thanks in advance