Category Archives: Wordpress

MAMP MYPHPADMIN Delete wordpress trash

Delete Trash from WordPress

Delete WordPress Trash from SQLAs I was testing on mij localhost (using MAMP) I run into trouble while permanently deleting several hundred products from my Trash.

Instead of using WordPress interface I decided to user MyPhPAdmin to do this. Whereas WordPress gave and timeout when only selecting a few products, via SQL the job was doen in less than 3 seconds.

Here’s the Code snippet:

DELETE wp_posts,wp_term_relationships,wp_postmeta,wp_term_taxonomy
FROM wp_posts 
LEFT JOIN wp_term_relationships ON ( wp_posts.ID = wp_term_relationships.object_id )
LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
LEFT JOIN wp_term_taxonomy ON ( wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
WHERE wp_posts.post_status='trash';
Database size phpadmin wordpress

WordPress Database size in phpMyAdmin

How to show WordPress database size in pypmyadminI got an email from my hosting provider that I was exceeding my wordpress database space of 1000MB, which I thought was very strange. Had 2 dabases in which I each imported content of about 50MB (gzip format). I could not find the actual database size so I did some digging around and found the SQL code below which does the trick:

SELECT table_schema "Data Base Name",
sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;

Continue reading WordPress Database size in phpMyAdmin


Proudly Powered By WordPress – Change footer

Remove ‘Proudly Powerd By WordPress’

WordPressWhen starting with a new wordpress site the footer containts ‘Proudly Powered By WordPress’. If you want to your side to look more professional, of rather link to another site then WordPress you need to change this in the footer.php.

I used to edit this using a FTP program as Filezilla. But nowadays you can edit this from the WordPress Admin it self. Continue reading Proudly Powered By WordPress – Change footer

Press This « WordPress Codex

With WordPress 4.2.1 the Press This function is introduced. The “Press This” function allows quick publishing with a special web browser bookmarklet. You can create a post by quoting some text, images, and videos on any web page.

Source: Press This « WordPress Codex

lightbox (wp lightbox 2)

Using Lightbox to display Images

Avoid Ugly Image presentation

lightbox (wp lightbox 2)One of the easiest ways to make your website more actractive is using a ‘lightbox’ for displaying images. Default action for imanges is to desplay them just plain in the browser. This is not only a ugly presentation but it is also user unfriendly.

On my main website I’ve actually been using this bad presentation for far to long, reason for this is that I didn’t not know better, or actually didn’t know how easy the solution could be.

There are several (good) plugins available which will do the trick. I tried 3 of them: Continue reading Using Lightbox to display Images

WordPress Jetpack

Jetpack: [auth_failed] Authorization header was malformed

WordPress JetpackI noticed I got the message: “Jetpack: [auth_failed] Authorization header was malformed” in my wordpress admin panel. Refreshing and Reconnecting the social media links (Facebook, Twitter, Google+) did not work.

The solution turns out pretty easy:

  1. Go to the Jetpack page in your dashboard.
  2. Click on the Debug link appearing at the bottom of the page.
  3. Click the link that says “click here to contact Jetpack support.”
  4. Fill in the description box and your name and email address.
  5. Click the “Contact Support” button.

Continue reading Jetpack: [auth_failed] Authorization header was malformed


WordPress Heartbeat (wp-admin/admin-ajax.php)

heartbeat-control-plugin-wordpressWhile monitoring Stats of my websites wp-admin/admin-ajax.php was always on top of the list of most requested pages which made me wonder, Why is there so much activity from the wp-admin/ folder? Nobody (no regular visitor) is supposed to go there / request a page from the admin folder, right? Continue reading WordPress Heartbeat (wp-admin/admin-ajax.php)

Breadcrumbs woocommerce wordpress

Wrong Woocommerce Breadcrumb for Products in Multiple Categories

Breadcrumbs woocommerce wordpressWoocommerce Breadcrumb are great for customers looking for products in a specifiek product within a categorie, but when using products in multiple categories this is not working very well. If you have a product in categorie X, Y and Z for instance, and you navigate to the product from within the catogory Z, your breadcrumbs probably will display Category X.
This is very confusing for customers and even can result in loss of a sale! Continue reading Wrong Woocommerce Breadcrumb for Products in Multiple Categories


Finding the right webfont using a webfont preview

wordpress-webfontsWebfonts are great! With a new WordPress theme I’m setting up a lot of webfonts are predefined, 661 to be exact! So if you don’t know which exact font you need / want it’s hard to find the right font when there is no preview available, which in no theme I’m currently working with is the case (are there any?).  Continue reading Finding the right webfont using a webfont preview

translate wordpress po / mo

Create WordPress Translations (.po / .mo files) – translate wordpress

translate wordpress po / moWhen you need to create a custom translation for WordPress there are some tips:

  3. Add a extra word to translation file

Continue reading Create WordPress Translations (.po / .mo files) – translate wordpress