No Support > Announcements

Scheduled webpage maintenance works on 2005-05-26

<< < (2/3) > >>

Joachim Müller:
After leaving the forum offline for more than 7 hours (while I was working on the server move) I finally have to admit defeat: the server (for now) remains as-is, as there turned out to be issues that need to be fixed before I can finally move. The problem are thousands of postings and PM's that contain single quotes that are not properly escaped (some are, some are not). When I tried to restore the mySQL dump on the new server, those unescaped single quotes caused errors. My guess is that they're still leftovers from phpBB (apparently the migration script from phpBB to SMF didn't convert everything as expected.
I'll try later (asap), there will be an announcement before I do.

Joachim

P.S. Needless to say that I'm very frustrated... :\'(

Tranz:
awww... (https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Ftu2.net%2Femoticons%2Ficon_console.gif&hash=ade76d31f04c7200b4f2441a241fc9e3f96fdc5f) Thank you for your time and effort on this, Joachim.  :-* (https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Ftu2.net%2Femoticons%2Ficon_love.gif&hash=007ca33759d6b5029c2712b7b02073de2e8db474)

OmegaGOD:
@GauGau,

Sorry to hear about those unescaped single quotes. Murphy's Law sucks! Thanks for workin on it. Maybe take 2 will be better  :D

vuud:

--- Quote from: GauGau on May 26, 2005, 04:03:52 pm ---After leaving the forum offline for more than 7 hours (while I was working on the server move) I finally have to admit defeat: the server (for now) remains as-is, as there turned out to be issues that need to be fixed before I can finally move. The problem are thousands of postings and PM's that contain single quotes that are not properly escaped (some are, some are not). When I tried to restore the mySQL dump on the new server, those unescaped single quotes caused errors. My guess is that they're still leftovers from phpBB (apparently the migration script from phpBB to SMF didn't convert everything as expected.
I'll try later (asap), there will be an announcement before I do.

Joachim

P.S. Needless to say that I'm very frustrated... :\'(

--- End quote ---

I'm pretty good with fixing stuff... let me know if you want any help working out a way to fix all the problem chars...

If its going to go wrong, it will...  ah well

Ironically, the server seems to be responding much better anyway... Maybe you scared it.

Joachim Müller:
Thanks for your readiness to help. Alas, the dump I created the other day is of course out-dated, so it's no real use anymore. What I'll do instead is writing a backup tool as suggested in [help wanted]:MySQL backup system. Once it's done, I'll use it to move over. The idea is that the tool will create a dump file on the server, with only a few lines of queries done at a time (which get appended to the dump file on the server's file system), with a refresh of the page done every xx seconds that will do another few steps. This way, a dump file will be built gradually that will not run into timeouts, no matter what. The same process will be used to restore the dump: little by little (several hundred queries only). It will have only small impact on the mysql server when run, only some http traffic impact and a large local dumpfile. I will publish the script once it's finished as well.

Navigation

[0] Message Index

[#] Next page

[*] Previous page