Archive for the ‘Information Technology’ Category
Jun
29
The Cost of Incompetent Programmers
This topic comes up for me not necessarily as a rant, but as I was going through some old notes before tossing them away, and this issue came up. How much damage can an organization do to themselves by hiring discount, unqualified programming resources?
The answer: A hell of a lot.
If you own a small software development shop, do yourself a huge favor and keep reading.
May
1
Table BitValue – NoYes, DisabledEnabled, FalseTrue
Warning- this may not be really all that funny unless you are a database administrator or a geek with the right knowledge. This rather silly product I am working with stores its data in the backend via a Microsoft SQL Server database. There’s nothing wrong with that… but on further examination of the schema I found a pretty ridiculous jewel of a table setup. Click on the picture to see the bloody details.
For those not technically inclined- this is precisely NOT how you would utilize a relational database server. It’s poor design, and rather an extreme and laughable example.
Feb
26
ODBC SQLState:42000 Error, Or Why Microsoft Sucks, Reason #42000
You’re probably here because you searched for this:
Microsoft SQL-DMO (ODBC SQLState:42000)
[Microsoft][ODBC SQL Server Driver][SQL Server] To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).
Feb
23
Xythos Broken Advanced Upload Functionality
We use Xythos at our workplace to provide a file repository for students and eventually faculty and staff. It’s basically a web front end for a file system.
My personal feelings about the product are somewhat ho-hum and indifferent. It makes funny noises under the hood, it’s a bit clunky, but it works, runs on Linux and it’s reliable.
So you’re probably here because you searched on this error:
java.lang.ClassFormatError: Truncated class file
The problem is that you’re probably running your Xythos installation over port 443 (as you should) but there are still components trying to pull files down from port 80. With Xythos, if SSL is enabled, any requests to port 80 get dumped over to 443, and you will get truncated errors like above.
Nov
6
Gallery2 Upgrade Error “Unable to selectAdminUser for core upgrade”
I use Gallery2 for the backend service of photos. It works rather well, despite a few quirks. But none of these issues are nearly as bad as something in the world of a closed-source vendor.
I recently tried to upgrade the Gallery software and found this nasty error in the logs right around when I was trying to push the big red ‘Upgrade’ button:
...Unable to selectAdminUser for core upgrade...
Hopefully if you are reading this, it is because you found this page on a web search and are grasping for some answers. I’m not saying I have all of them, but this is the process I used to figure things out.

