http://albertech.net Tips, Tricks, and Reviews in Linux, Apache, MySQL, PHP Wed, 28 Jul 2010 16:09:13 +0000 http://backend.userland.com/rss092 en

1. Remove the wp-content/blogs.php file as it is no longer supported in WordPress 3.0. It has been replaced with wp-includes/ms-files.php
2. Locate the .htaccess file in the root directory
3. Find the following line:  RewriteRule ^(.*/)?files/(.*) wp-content/blogs.php?file=$2 [L]
4. Replace it with: RewriteRule ^(.*/)?files/(.*) wp-includes/ms-files.php?file=$2 [L]  
5. This should fix the problem with broken images/files not showing up in the WordPress MU blogs.

]]> http://albertech.net/2010/07/wordpress-mu-fix-broken-images-on-2-9-to-3-0-upgrade/ sysv-rc-conf (Install it using aptitude or apt-get install)]]> http://albertech.net/2010/07/disable-autostart-of-mysql-in-debian-and-ubuntu/ http://albertech.net/2010/06/using-jquery-for-setting-focus-on-an-input-box/ http://albertech.net/2010/05/wordpress-rss-cache-issue/ Bluetooth does not exist. To fix, simply upgrade to the latest version of Snow Leopard (OS X 10.6.3 as of 5/11/2010) They apparently brought back the "Rename" option in a newer version of Snow Leopard.]]> http://albertech.net/2010/05/fix-renaming-applebluetooth-keyboard/ Solution: The workaround is to use iMovie '09 to import the video files from the camera. Connect the Canon camcorder to the Mac via ... ]]> http://albertech.net/2010/04/importing-canon-mts-video-into-final-cut-express/ http://albertech.net/2010/04/codeigniter-reading-excel-files/ The error message looked like: "Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'" I ran into this problem today while importing text from a CSV file. Evidently, the text format of the document had UTF characters, which caused CodeIgniter to error out when it tried to insert it to the database. The line had French characters (The ç in Français) My database fields by default are set to "latin1_swedish_ci" character set. The fix? I decided the best way to fix this was to set the Collation option for that specific field in the MySQL database to  "utf8_general_ci If you are in the market for a Canon 7D or a Canon 5D Mark II and a lens, March 7, 2010 - April 3, 2010 is a great time to buy one. Canon is offering 2x the rebates for lenses if you pick up the 5D Mark II at the same time. Historically, the 580 EX II had a $50 instant rebate during Winter 2009, so the rebate isn't as good (unless you buy the 5D Mark II at the same time) The $100 off on the 7D looks like a great deal, especially for such a new camera. One of my favorite lenses for indoor use is the 16-35mm, $200 off w/ the 5D II is a good deal. ]]> http://albertech.net/2010/03/canon-spring-2010-rebates/ http://albertech.net/2010/03/mysql-case-insensitive-order-by/
How do you get video on the Intel SS4200? Read the blog entry for more information.]]> http://albertech.net/2010/02/intel-ss4200-e-server-with-windows-server-2008/ http://albertech.net/2010/01/amanda-backup-client-installation-on-debian/ http://albertech.net/2010/01/wordpress-sidebar-not-showing-up-on-wordpress-2-9/ CakeForge - Great resource for Open Source CakePHP applications. This site has many more applications than the CakePHP Bakery. http://cakeforge.org/ Bakery - How to use different CSS files in CakePHP http://bakery.cakephp.org/articles/view/some-ideas-to-organize-your-css-files-and-autoload-them-in-cakephp Giga Promoters - CakePHP tutorials and scripts: http://www.gigapromoters.com/blog/category/cakephp/ I'll be updating this list as I find more resources.]]> http://albertech.net/2010/01/cakephp-resources/ SQL Command $sql = "SELECT * FROM (SELECT * FROM [TABLE] WHERE ORDER BY modified_date DESC LIMIT 10) AS tbl ORDER BY tbl.modified_date" This will retrieve the last 10 rows while sorting by date chronologically. I used this SQL command for ... ]]> http://albertech.net/2010/01/mysql-tutorial-fetch-last-10-rows-without-reversing-order/ http://www.iprong.com/ipodiphoneitunes/app-review-i-am-t-pain/. I really enjoyed the app with its auto-tune feature. Here's a really good video of how it works, with musicians testing it out for the first time. ]]> http://albertech.net/2009/12/app-review-i-am-t-pain-on-iprong-magazine/ http://albertech.net/2009/11/sftp-scponly-fix-for-winscp-error/ http://albertech.net/2009/11/vmware-server-2-02-update/ http://albertech.net/2009/10/iphone-app-review-jammit/ http://albertech.net/2009/10/tinymce-fix-empty-tag-removal/