Should you find yourself catting files together to make a megafile (like turning many individual sproc files into a single file fit for execution) and you end up with your program (let’s say SQL Management Studio) saying there’s a problem with the file its because a Unicode BOM (byte order mark or char value 65279) that appeared at the start of one of the concatenated files made it into your megafile. We solved this by opening the offending file in Visual Studio and Save As… overwriting itself as a Unicode Codepage 1200 instead of UTF-8.
Archive for 2010
October 21st, 2010
No Comments »
September 28th, 2010
No Comments »
August 27th, 2010
No Comments »
If you upgrade SMF from 1.1.2 all the way to 1.1.11 there is a missing chunk of SQL upgrade. The `smf_board_permissions` table has `permission` VARCHAR(10) but there are permissions like "post_reply_new" which gets silently shaved into "post_reply" due to the column length limitation leaving you tearing your hair out. (Well it did me. I was editing templates and everything.) This results in situations where forum users can no longer reply to posts and trying to edit forum permissions results in database error messages due to duplicate keys ("post_reply_own" and "post_reply_any" both get shaved into "post_reply" for example).
Alter the column `permission` to VARCHAR(50) and it'll work again.
July 29th, 2010
No Comments »
While doing some research on what options are available to eliminate deeply nested branching, I stumbled across this:
http://www.ctocorner.com/fsharp/book/default.aspx
I’ve been reading it when I have a moment here and there and so far its been great.
March 25th, 2010
No Comments »
I recently replaced my aging Intel Core2 Duo 1.86GHz with an AMD Phenom II Black and a BioStar TA70GXE 128M motherboard (which is a real piece of shit, I would not recommend it to anyone). I could not find RAID drivers that allowed me to install Windows 7 64-bit (or even 32-bit), scouring the Internet led to a lot of perplexed posts about why it would not work. One suggestion that apparently works is to install Windows XP 32-bit with the supplied RAID drivers, then upgrade to Windows 7 64-bit. I was about to do that but I stumbled across an older set of AMD SB7XX RAID drivers today that caused Windows 7 setup to FINALLY detect my RAID/0 array. Here’s hoping to no stability problems.
The drivers I found can be downloaded from my web site: ATI_SB700_SATA_Slipstream.zip