Categories
development

Cryptic MySQL Error on DROP TABLE

Ran across this fairly unhelpful error in MySQL today: InnoDB: Error: in ALTER TABLE `myschema`.`mytablename` has or is referenced in foreign key constraints which are not compatible with the new table definition. [Warning]: Invalid (old?) table or database name ‘#sql-a5c_8’ InnoDB: Error: table `myschema`.`mytablename` does not exist in the InnoDB internal data dictionary though MySQL is trying to drop […]

Categories
websites

Codeception with Yii Part 1 – Acceptance Tests

I will be working with a default, standard, bare Yii webapp generated from the command line – called yiicodecept. > yiic webapp yiicodecept !Important! For starters, delete the protected/tests directory – Codeception will create what it needs in there. We generally follow Codeception install instructions here: http://codeception.com/quickstart Summary: Save .phar to root/protected of webapp (yiicodecept/protected) […]

Categories
websites

Setting up Yii Testing with XAMPP, PHPUnit and Selenium

Setup Yii Testing In protected/tests/WebTestCase.php, change TEST_BASE_URL to your project define(‘TEST_BASE_URL’,’http://127.0.0.1/webapp/’); Check protected/tests/bootstrap.php to make sure it is configured in a reasonable manner.  I believe in most cases it will be fine – I am using the yii-environment extension, and needed to copy over my config so it would read from existing config files.  Take […]

Categories
websites

Keep Your Free dyndns.org Account

Programmatically login to your dyndns.org account Per the discussion and script provided by azertx here, I’ve decided to document things a little more clearly in the hopes that more people are able to continue using the dyndns.org FREE dynamic hostname service. Create a perl script called ‘dyndns-refresh.pl’ containing the following code: #!/usr/bin/perl use strict; use […]

Categories
hardware

Solved: Bluetooth Mouse Disconnecting on Windows 8.1

After upgrading to Windows 8.1, I started having problems with my bluetooth mouse disconnecting from my Dell XPS14 frequently.  Every few minutes or so it would stop responding entirely, then I would have to go to the Bluetooth Devices screen – this would usually kick it out of its “sleeping” state, but only temporarily.  Eventually, […]

Categories
software

uTorrent Proxy Connection Error or DHT: Waiting to log in

When using uTorrent, you get the following notice in the status bar: DHT: Waiting to log in In the Tracker Status, you will see: [DHT] waiting for announce Proxy connect error: No connection could be made because the target machine actively refused it. As well as the status changing from “Ok” to “No incoming connections” […]

Categories
apple

Looping video on an iPhone or iPod Touch

Contrary to what a quick Google search will tell you, looping video on an iPhone or iPod Touch is simple, easy, and most importantly, FREE – using built-in features.  I tried a ton of video player apps before I actually found a solution that works – figured others would benefit from this post, so here […]

Categories
Uncategorized

Fixing iTunes Restore Error 16xx (1600, 1604, 1648…etc)

If you’re having problems restoring your iPhone, iPod and keep getting one of these 16xx errors, the solution might be much simpler than you think! The iPhone could not be restored.  An unknown error occurred (1600). There are numerous reasons for running into these errors – one of the simplest (and least obvious) fixes for […]

Categories
hardware

Inspiron 1420 Obituary

I’ve been putting this off for a long time, but my trusty laptop is really on its last legs this time.  It was bought in October of 2008 for $780 (after my trusty Inspiron 8500 died – RIP *tear) – making it almost exactly 5 years old to the day. In all reality it’s lasted […]

Categories
websites

Adding Google Analytics to Your WordPress Site

First thing I do anytime I spin up a new site is to add Google Analytics to it.  This lets me see what is being used on the site, by who, how often…etc, and can be invaluable to any small business that wants to know more about its customers. Site analytics are also useful for […]