As 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:
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 )
I 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
Remove ‘Proudly Powerd By WordPress’
When 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
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
Avoid Ugly Image presentation
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
I 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:
- Go to the Jetpack page in your dashboard.
- Click on the Debug link appearing at the bottom of the page.
- Click the link that says “click here to contact Jetpack support.”
- Fill in the description box and your name and email address.
- Click the “Contact Support” button.
Continue reading Jetpack: [auth_failed] Authorization header was malformed
While 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)
Woocommerce 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
Webfonts 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