Search
-
Recent Posts
Tags
adwords amazon analytics api apple aws blog chrome chromium cloud Design dropbox ec2 email error facebook firefox google google-apps homebrew ipad javascript jQuery linux lion mac microsoft mysql osx os x paypal php plugin quicksilver raspberry pi scam social spam twitter ubuntu unix video windows woo wordpress
Monthly Archives: February 2012
iPower: The server encountered an unexpected condition which prevented it from fulfilling the request.
iPower: The server encountered an unexpected condition which prevented it from fulfilling the request. If you’re getting this error on iPower you need to enable CGI / scripts. Sometimes your account will show you that this is enabled, even if it is not. Contact iPower support to get them to resolve it for you. Even if in your control panel homepage CGI / PHP is showing up as active, click on the server configuration tab and you probably will see that CGI is in fact inactive:
Posted in Server Admin, Server Administration, Web Development
Tagged cgi, error, hosting, ipower, php, scripts, wordpress
Leave a comment
Install WordPress on Linux in 5 Seconds
WordPress is available on WordPress.org in two formats, .zip and .tar.gz: I wanted an option to download and extract WordPress as easily as possible. I had looked for a way to do this with the zip format but apparently Archives read from standard input are not yet supported, except with funzip (and then only the first member of the archive can be extracted). (source So, my solution was to use WordPress’ latest.tar.gz file and pipe it (stdin/stdout). Running the following command will create a wordpress folder in your current working directory with all files: wget -O – http://wordpress.org/latest.tar.gz | gzip -c -d | tar -x Notes: wget -O – //send output to stdout, use – before the URL gzip -c -d //read from stdin, decompress tar -x // extract, could probably also use -v to verify
14 Most Popular Woo Themes
Backstage A powerful niche theme design for musicians and artists showcasing their media, upcoming shows and music using hugely flexible custom widgets and audio players. This beautifully crafted layout was designed by Elliot Jay Stocks and boasts 7 alternate styles. Live demo – Read more Biznizz Built on WooThemes own winning formula, Biznizz will give your website a fresh new look. Its integrated slider and custom homepage layout, in addition to the optional portfolio page template, makes Biznizz a great candidate for your next business website. Live demo – Read more Caffeinated This personal portfolio theme by Ryan Downie was originally designed for his own personal use – fueled by his passion for Coffee, Red Bull and lunchtime pot of noodles according to his Twitter stream. It’s perfect for anyone wanting a bold design to show off their work. Live demo – Read more City Guide This theme was developed to cater for directory-based WordPress sites. For example, a guide to a city with shops, restaurants and other places of interest all archived in posts with geo-tags, custom content about the locations, and well presented in this killer theme designed by Sam Brown. Live demo – Read more Continuum A Magazine theme which features a custom homepage, custom typography and some extra custom widgets, all to help your news/magazine website get a stylish and functional look. Designed by Simon Collison. Live demo – Read more Crisp Designed by Tyler Galpin, and boasting all-new tumblog functionality with a quick publishing form on the dashboard Crisp is perfect for lazy bloggers who … Continue reading
Posted in Design, Tech Tips, Web Development
Tagged popular, themes, woo, woo themes, wordpress
1 Comment
MySQL UPDATE JOIN
Here is a working example of how to do an UPDATE JOIN with MySQL: MySql UPDATE LEFT / CENTER / RIGHT JOIN Example This is the correct way to update a table when using a JOIN. They key is that the SET needs to come after the JOIN. UPDATE wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) SET wp_term_taxonomy.taxonomy = ‘category’ WHERE 1 AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (1) This WILL NOT WORK because the SET is in the wrong place: UPDATE wp_posts SET wp_term_taxonomy.taxonomy = ‘category’ LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1 AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (1)
WordPress: SQL to get all Categories
If you’re trying to get all categories in WordPress with a real, raw, mysql sql statement, this is the type of query you can use: SELECT * FROM wp_term_relationships LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE wp_term_taxonomy.taxonomy = ‘category’ GROUP BY wp_term_taxonomy.term_id This is how you can get posts of a certain category / taxonomy. I have a few extra lines commented out that could also be used: SELECT * FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1 #AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (13) #AND wp_term_taxonomy.term_id IN (1,2,3,4,5,6,7) GROUP BY wp_posts.ID ORDER BY ID Update: Omar asks: cool.. but how can I get the NAME of those categories ?? Well, try this: SELECT * FROM wp_term_relationships LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms on wp_term_taxonomy.term_taxonomy_id = wp_terms.term_id WHERE wp_term_taxonomy.taxonomy = ‘category’ GROUP BY wp_term_taxonomy.term_id or just for the names: SELECT wp_terms.name FROM wp_term_relationships LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms on wp_term_taxonomy.term_taxonomy_id = wp_terms.term_id WHERE wp_term_taxonomy.taxonomy = ‘category’ GROUP BY wp_term_taxonomy.term_id
Posted in Social Media, Tech Tips, Web Development
Tagged blog, categories, mysql, query, sql, wordpress
8 Comments
Applescript: Check Application Is Running
Below is my Applescript example of how to check if an application is running, such as Finder.app, VLC.app, itunes.app, or something along those lines. Quite often I need to check if an application is running as part of my applescript, and so I use this little function / subroutine in applescript to test if the application is running: on appIsRunning(appName) tell application “System Events” to (name of processes) contains appName end appIsRunning Example usage: display dialog appIsRunning(“Finder”) The above apple script example will show “true” in a popup dialog.
OS X Lion: Printing Multiple Pages per Sheet
I’ve been disappointed that the preview in the OS X Lion does not show multiple pages per sheet like Leopard and Snow Leopard did. I often do this to conserve paper when I’m printing lecture notes. With Leopard, I’m often doing this blind and get things out of order. Preview or Acrobat provide this functionality, but in Preview the functionality is hidden under the “Preview / Layout” dropdown option: To print multiple pages per sheet, first select the Layout option from the Print dialog. It is part of the menu marked “Preview.” Then, choose the number of pages which should be printed on one side of a single sheet of paper. With this example, there will be two pages on each side, for a total of four pages on a single sheet of paper when duplexed. You can also optionally set the layout direction, and whether a border should be printed around each individual page.
Canvas Commerce psd
The WooTheme “Canvas Commerce” photoshop psd files is not listed in the downloads section of the WooThemes member area: It is unclear why no PSD files are included for download, however, this is actually the case for several of the Woo Commerce themes including: Kaboodle Commerce PSD Inspire Commerce PSD Bizznizz Commerce PSD Canvas Commerce PSD Simplicity Commerce PSD Statua Commerce PSD
Posted in Design, Web Development
Tagged photoshop, psd, themes, woo, woo commerce, woo themes, wordpress
Leave a comment