So, as usual I haven’t written anything personal in a while. I’ve been working hard on my new web application that’s basically just a clone of a couple dozen other websites out there. I’m not really striving for originality so much as I’m applying old solutions to unsolved problems. That’s fine with me – whatever …
This is a shorty but it was kind of irritating. It turned out to be a MySQL error that only occurred on my production server. Presumably this was because the version of MySQL was either different or configured differently on the production server as on my local development box. Either way it’s an easy work-around …
A while back I had this problem that took me about a day to resolve. Specifically, I had a SQL Statement that worked in PHPMyAdmin but not in PHP. Which makes no sense. But, of course, in a world where your entire 30,000 line program can die because you forgot a semi-colon, it actually does make …
Solved: SQL Statement Works in PHPMyAdmin but not PHP Read More »
This is another stupid error. It has to do with trying to successfully set foreign keys in MySQL. ERROR 1005: Can’t create table (errno: 150) Great, that’s fantastic. Here’s an example of where this error will occur. CREATE TABLE main( id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id) ); CREATE TABLE other( id INT UNSIGNED …
Solved: MySQL ERROR 1005: Can’t create table (errno: 150) (Foreign Key) Read More »
Your page loads multiple (in my case two or three) times and you don’t know why. Maybe you noticed this when your database was being hit too often or you have duplicate records showing up on INSERTs. This might have been limited to Webkit browsers like Safari or Chrome, or maybe you saw it in …
Web Developememt Bug: Page Loads Two Times (PHP ASP HTACCESS) Read More »