-
Popular Posts
-
Search
-
Recent Posts
Follow for New Updates
-
Tags
amazon analytics api apple blog browser chrome chromium Design dropbox error extension facebook firefox google greasemonkey ipad javascript jQuery keyboard linux lion mac Marketing mysql os x osx php plugin project quicksilver scam search SEO social spam ssl themes twitter unix ux video windows woo wordpress-
-
Category Archives: Web Development
How to Reset WP to Twitter
The WordPress plugin WP to Twitter “posts a Twitter status update when you update your WordPress blog or post to your blogroll, using your chosen URL shortening service. Rich in features for customizing and promoting your Tweets.” You can activate the plugin and then set all the options, but if you are having trouble the plugin offers no way to unset all of the options associated with it. You can use the following sql / mySQL command to remove all of the options generated by this plugin. Use this at your own risk, and of course create a backup of your database before attempting this. delete from wp_options where option_name in (‘app_consumer_key’, ‘app_consumer_secret’, ‘bitlyapi’, ‘bitlylogin’, ‘comment-published-text’, ‘comment-published-update’, ‘disable_oauth_notice’, ‘disable_twitter_failure’, ‘disable_url_failure’, ‘jd_date_format’, ‘jd_donations’, ‘jd_dynamic_analytics’, ‘jd_individual_twitter_users’, ‘jd_keyword_format’, ‘jd_last_tweet’, ‘jd_max_characters’, ‘jd_max_tags’, ‘jd_post_excerpt’, ‘jd_replace_character’, ‘jd_shortener’, ‘jd_status_message’, ‘jd_strip_nonan’, ‘jd_tweet_default’, ‘jd_twit_append’, ‘jd_twit_blogroll’, ‘jd_twit_custom_url’, ‘jd_twit_prepend’, ‘jd_twit_remote’, ‘limit_categories’, ‘newlink-published-text’, ‘oauth_token’, ‘oauth_token_secret’, ‘suprapi’, ‘suprlogin’, ‘tweet_categories’, ‘twitter-analytics-campaign’, ‘twitterInitialised’, ‘use-twitter-analytics’, ‘use_dynamic_analytics’, ‘use_tags_as_hashtags’, ‘wp_bitly_error’, ‘wp_debug_oauth’, ‘wp_supr_error’, ‘wp_to_twitter_version’, ‘wp_twitter_failure’, ‘wp_url_failure’, ‘wpt_inline_edits’, ‘wpt_post_types’, ‘wtt_oauth_hash’, ‘wtt_twitter_username’, ‘wtt_user_permissions’, ‘yourlsapi’, ‘yourlslogin’, ‘yourlspath’, ‘yourlsurl’)
Posted in Social Media, Tech Tips, Web Development
Tagged mysql, plugin, twitter, wordpress
Leave a comment
Woo Themes and Affiliate Link Structure
Recently received an error from Woo. It’s below, and it has some unique insights to how the database and affiliate tracking is done. Database Error A database error occurred while performing the requested procedure. Please review the database error below for more information. system/libraries/drivers/Database/Mysql.php [371]: There was an SQL error: Duplicate entry ’9802422′ for key 1 – INSERT INTO wm_affclick (aff_id, url, remote_addr, referrer, woo_product, is_unique) VALUES (’123456′, ‘http://www.woothemes.com/extension/google-product-feed/’, ’123.45.67.89′, NULL, ”, 0) Stack Trace system/libraries/drivers/Database/Mysql.php [99]:Mysql_Result->__construct( ) system/libraries/Database.php [259]:Database_Mysql_Driver->query( INSERT INTO wm_affclick (aff_id, url, remote_addr, referrer, woo_product, is_unique) VALUES ('123456', 'http://www.woothemes.com/extension/google-product-feed/', '123.45.67.89', NULL, '', 0) ) system/libraries/Database.php [962]:Database_Core->query( INSERT INTO wm_affclick (aff_id, url, remote_addr, referrer, woo_product, is_unique) VALUES ('123456', 'http://www.woothemes.com/extension/google-product-feed/', '123.45.67.89', NULL, '', 0) ) application/models/affiliatestats.php [138]:Database_Core->insert( wm_affclick, Array ( [aff_id] => 123456 [url] => http://www.woothemes.com/extension/google-product-feed/ [remote_addr] => 123.45.67.89 [referrer] => [woo_product] => [is_unique] => 0 ) ) application/helpers/log.php [95]:AffiliateStats_Model->create( Array ( [aff_id] => 123456 [url] => http://www.woothemes.com/extension/google-product-feed/ [remote_addr] => 123.45.67.89 [referrer] => [woo_product] => [is_unique] => 0 ) ) application/controllers/go.php [124]:log_Core->add_affclick( 123456, http://www.woothemes.com/extension/google-product-feed/ ) Go_Controller->index( ) system/core/Kohana.php [291]:ReflectionMethod->invokeArgs( Go_Controller Object ( [uri] => URI Object ( ) [input] => Input Object ( [use_xss_clean:protected] => 1 [magic_quotes_gpc:protected] => 1 [ip_address] => ) [session] => Session Object ( [input:protected] => Input Object ( [use_xss_clean:protected] => 1 [magic_quotes_gpc:protected] => 1 [ip_address] => ) ) ) ) Kohana::instance( ) system/core/Event.php [209]:calluserfunc( Array ( [0] => Kohana [1] => instance ) ) system/core/Bootstrap.php [55]:Event::run( system.execute ) index.php [106]:require( system/core/Bootstrap.php )Loaded in 0.0088 seconds, using 1.13MB of memory. Generated by Kohana v2.3.4.
Remove WooCommerce Generator Tag
If you would like to remove the Remove WooCommerce Generator Tag from the <head> section of your WordPress installation, you can add the following line somewhere, perhaps in your wordpress functions.php file: remove_action(‘wp_head’, array($GLOBALS['woocommerce'],’generator’)); I’ve updated the code to work with the most recent version of Woo Commerce, try adding this to the functions.php file of your WordPress theme: function remove_woo_commerce_generator_tag() { remove_action(‘wp_head’,array($GLOBALS['woocommerce'], ‘generator’)); } add_action(‘get_header’,'remove_woo_commerce_generator_tag’); That will prevent the following line from being shown in your HTML code: <!– WooCommerce Version –> <meta name=”generator” content=”WooCommerce 1.5″ />
Posted in Security, Tech Tips, Web Development
Tagged generator, tag, woo, woocommerce, wordpress
2 Comments
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 Example
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
Posted in Social Media, Tech Tips, Web Development
Tagged blog, categories, mysql, query, sql, wordpress
Leave a comment
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
