Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


JRWR last won the day on December 18 2013

JRWR had the most liked content!

About JRWR

  • Rank

Profile Information

  • Gender
  1. Ah, I was wondering when that would crop up. Back then when I setup that up. reCaptcha was just not doing it. We used the custom answer ones to keep the automated bots and bay. and it did work for some time. Of course it should be replaced soon, but it did work for some time.
  2. So, I have F-777 on skype, he just sent me this:
  3. Yep! a old newgrounds fav, This guy makes AMAZING music
  4. well... I didnt really know what was broken untill I put the log in, Its hard to reproduce the issue sometimes on these types of bugs! now to fix that slow ass homepage, thats insane
  5. So, A few months/weeks ago I noticed a bug where if you accessed the webserver with a domain that we did not have configured, you could install mediawiki for that domain and do all kinds of nonsense! So I thought I fixed it, and in part I did, but some people like using http://PCGamingWiki.com as their homepage, Well how the system works is that it checks for /path/sites/PCGamingWiki.com/LocalSettings.php well... we only have a /path/sites/pcgamingwiki.com.com/LocalSettings.php, Notice the issue? Yep! Linux is case sensitive and so was Mediawiki >.>.... one Strtolower and we are all good to go!
  6. Last night Andy and Another PHP Dev were trying to get Invision Powerboard to authenticate to the MediaWiki User Database, They called me when the PHP Dev where having issues with the way that PCGamingWiki is setup We discovered that the bridge they were trying to use, was the wrong type, it was to use PowerBoard’s user database for auth and not mediawiki, So we uninstalled and left it like that. We got a report the next morning that all auth groups had been wiped from the database, I still do not really know how this happened, but I suspect the Auth Bridge was to blame, All page permissions where gone as well, and I saw no way of fixing it, but a database rollback That’s where things went south, I got a backup off our Backup Server from the 25th, and exported the current wiki as XML, but I found out that the database backup copy was bad, really bad, like eat your goat and piss on your oatmeal bad, it crashed mysql HARD, After some “science†(Hex Editor, and some luck) and was able to get Mysql to mount the InnoDB store It segfaulted (crashed) midway into the raw SQL dump, Fuck After some more “Science†and some really good luck, I got a Full Database dump. And deleted all the old data, or so I thougth…. That was a incomplete dump, I forgot to push the binlogs to current…. So after some more “science†and some 4 hours later, we now have a working database that is 2 days old and with the current content of PCGamingWiki, Sorry TruePCGamer, Hope you had some old backups for the last two days
  7. These links should help http://store.steampowered.com/search/?d ... e%20Cristo http://store.steampowered.com/app/231140
  8. We don't have any pages for Cities XL here are some fixes for the page: http://www.reddit.com/r/CitiesXL/commen ... h_the_lag/ Im teribad at wiki code :)
  9. Ill be doing updates on my twitter https://twitter.com/jrwr
  10. Yay! gotta redo all the cache stuff since we have a shit ton more diskspace/cpu cycles/memory
  11. Ok, doing test move number 1 Locking DB and dumping the whole thing to disk!
  12. it might of, Ill look into it more after the move
  13. At one point later today, I need to lock the database and dump it so I can get a working copy, oh fun!
  14. This is a Pre-Pre Accouncement that we are moving to a nice fat dedicated server from a little Linode VPS! the site should load faster and have a ton more power behind it now, Please Note that the site might go down and up over the next few days, if you have any issues, contact us at contact@pcgamingwik.com Lets hope nothing breaks
  • Create New...