As you might know, there is a fix which allows WordPress to run on MySQL strict. WordPress version 3.1.1 includes a database upgrade, which will break your WordPress installation if you run MySQL on strict/traditional if you upgrade automatically; I found out the hard way (although luckily on a test environment). The best bet is to upgrade the database manually.
Disclaimer: No server hamsters were (severely) harmed in the process.
So yeah, WaveHack asked me to post a thing because i’ve been silent on the blog for a while now. this is mostly because i’ve been doing nothing interesting dev wise in a while and i probably won’t for a while so let’s just get on with it and ramble on about irrelevant stuff that no-one will ever read.
Somethingafwul
As some of you might know i read and post on Somethingawful occasionally and a interesting thing has happened there. someone broke the rules and posted a request for school help in the general forum, and promptly got mod challenged for it. a mod challenge is a challenge posted by a mod wich unless fullfilled end with your account being banned and costing you money to re-reg, as SA accounts cost 10 dollars. People started saying that they woud donate to the red cross and other charitys if the idiot got banned and it kind of got out of control, as of now. goons have donated 50,000 Dollars and the total i still rising by about 00 Dollar a day. So go goons!
Minecraft
By now this is a topic wich has come up on pretty much every gaming blog ever. Minecraft. a cute little sandbox that grew into a open world survival game wich has sold millions and has allow it’s creator, Markus Persson to start his own company, Mojang.
I personally enjoy both parts of the game, the old creative mode for building insane superstructures with my buddy Luminaflare and surviving out in the wilderness on randomly generated terrain in SMP on our private server. were I’ve settled in a town dubbed Creepertop. due to the sheer amount of creepers spawning there. The thing that interests me the most about minecraft is the emergent gameplay within it. from spleef to minecart racing, to building a song using music boxes.
Fy00char
In the future I hope to be actively developing modes for games and content for multitroid again, once my studies calm down a bit and holidays have started. but my current priorities lie not with Mineth Studios but with my study, so back into radio silence I go. See you later internet!
If you’ve ever tried installing WordPress on a MySQL5-server where the SQL-mode includes either NO_ZERO_DATE or TRADITIONAL (aka ‘strict’ mode), you will be greeted by a whole lot of errors upon trying to complete the installation.
Firstly, let’s look at MySQL’s definition of the TRADITIONAL SQL-mode:
Make MySQL behave like a “traditional” SQL database system. A simple description of this mode is “give an error instead of a warning” when inserting an incorrect value into a column.
Definition of NO_ZERO_DATE:
In strict mode, do not permit
'0000-00-00'as a valid date. You can still insert zero dates with theIGNOREoption. When not in strict mode, the date is accepted but a warning is generated. (Added in MySQL 5.0.2)
This pretty much fails the WordPress installation, since a whole lot of database tables aren’t being created, since they include errors according to the server’s SQL standard.
WordPress database error: [Invalid default value for 'comment_date'] CREATE TABLE wp_comments ( ...
WordPress uses quite a bit of ‘zero dates’ (dates consisting of 0000-00-00), which conflicts with the NO_ZERO_DATE constraint, which is included in the TRADITIONAL sql mode.
Most webhosters don’t use these kind of server settings. But for those that do (including this website), I have a very simple solution that fixes it. The only things you are required to do is be extra cautious about updating the WordPress installation (not plugins, only WP itself), since you need to manually add a line of code after each update. Be sure to make backups before updating (just to be safe) and ask your hosting provider if you’re allowed to ‘change the session sql-mode’ .
Note: This fix is for WordPress 3.1. Older versions require a slightly different approach, explained below.
After uploading your WordPress to your (restrictive) server, before installation, open your favorite FTP-client and edit file ‘/wp-includes/wp-db/php’. Find the current line:
$this->select( $this->dbname, $this->dbh );
This should be on or around line number 1065. Simply replace that with the following code:
mysql_query( "SET SESSION SQL_MODE := ''", $this->dbh ); $this->select( $this->dbname, $this->dbh );
After this, you can safely run the WordPress 3.1 installation and use it to your heart’s content, like you normally would. For WordPress versions older than 3.1, you need to call the ‘SET SESSION SQL_MODE’ query before each call to $this->select() in the code.
Last week I finally received my Pandora! For those of you who don’t know what a Pandora is; it’s basically a full-featured and very powerful Linux computer slightly larger than a Nintendo DS. It’s capable of running a full desktop environment you’d expect on a PC or notebook and it’s designed mainly for gamers, geeks and developers (which would pretty much describe me)! It runs games on 3d hardware up to Quake3 and PSX/N64 emulation. But best of all, it’s completely open source! From the kernel to most of the games and applications being made and ported for it! I won’t go in too much detail here about the Pandora, so for more information about it, visit OpenPandora.org. Here you can see mine running Castlevania: Symphony of the Night (PSX):
Excuse the slightly crappy image quality, but it’s the best I have at the moment. I can make more pictures of it or record videos of certain games or programs upon request. Castlevania SotN works pretty much flawlessly, other than the sound occasionally keeps hiccing up. But very playable nonetheless.
I’m currently working on a small open source game for the Pandora, which is basically SDL Sand optimized and rewritten in C. It’s a Falling Sand Game, which is a very enjoyable sandbox game where you drop (draw) different kinds of particles (like sand, water, salt, etc) on a black canvas and they interact with each other (salt and water merge to salt water, oil and plants burn, etc). The Pandora has a touch screen, so it will fit perfectly for this kind of game. The only thing that worries me is that small things might be hard to see (FSG being a pixel-based game), since the Pandora has a DPI of 217, so I might have to build in scaling or zooming for that. But we’ll see how it turns out.
Back when Mineth.net got started. there wasn’t a plan for it and there probably never be a proper one. so we’ve decided to use it as our perosnal blog and devlog. And this time around we mean it.
So let’s kick my first post off with all the stuff I made in the past,a little about me and the things that I might work on in the future!
The past
The second pack i made for FRAXY, this shmup boss collection features only content made by me and is therefore a bit smaller than metaFRAXY, seeing as metaFRAXY was getting crowded with too many authors and insecurities about the quality of the bosses i decided to can that project and start my own creative collection.
Haven gotten tens of thousand of downloads, i can call this one a minor success!
metaFRAXY, it was one of the biggest and best packs around initially and was still well known in the FRAXY community last time i checked, mostly abandoned and left to die behind the garden shed. The authors either lost interest or their boss quality went down the drain. Due to a mix of those things we decided to no longer work on it.
The download counter for this one was around 100somethingK when I last checked, i stopped paying attention to it.
Me!
I thought that it would be nice to post a bit about myself on here, seeing as it’s a personal blog.
I’m 23 years old and currently residing in the Netherlands, hoping to get the hell out of here when i finish my education. I really enjoy video games and modding them as well as listening to and making music. I spent most of my time growing up behind a keyboard and therefore have a varied taste in games, from Duke3D to Peggle, gotta play’em all!
I’ve known SQD Wavehack for far too long now, going back to when I was 7 I think. He’s my go-to guy for coding issues and school-work that I’m having issues with and in return I build and design stuff for his games, such as levels for multitroid, and enemies for Vectro(another dead Mineth project)
I got into gaming when i was about 4 or 5, my parent came home with a NES and super mario bros, i recall playing it for days and days and months and years to the point where i could probably do the first half of the game on muscle memory and i still enjoy speed-running the hell out of it.
Later in life when i met Wavehack we started playing this game called Jazz Jackrabbit 2, at this point in time we both didn’t know much about editing levels and using tools to build content so we were kinda meh about doing this kinda stuff. Until we worked out how the basics of J2Edit worked and just started going nuts on making levels, tilesets and pretty much everything. Later on I got into modding WarCraft 3, Unreal Tournament and level-design for Transport Tycoon/Roller-coaster Tycoon.My current projects are based on entirely different styles of games. so I’ve turned from SMB adict to jack of all trades Modder.
I personally enjoy working on FRAXY bosspacks, even though I rarely have time to work on them any more as of late due to my study and my job taking up all my free time. And when i do have free time I’m mostly playing around with either random game/level editors or working on school projects if I’m at home, if I’m on the road I spend most of my time reading the excellent Discworld novels by Terry Pratchett.
And then there’s minecraft, but I’ll whip up a post about that sometime in the future.
The Future
I’m hoping that my life calms down a little soon so I can just relax and take it easy for a while, I’m planning to go on a trip to England somewhere in July/August to visit a friend of mine.
Game and modding wise. I’m currently enjoying the hell out of minecraft and Test Drive Unlimited 2 and I’m really looking forward to Bulletstorm. On the modding side of things I’m hoping to spend some more time on my Knytt Stories campaign and doing level design for Multitroid, more news about that in the future.
So yeah enough about me for now.
