If you delete all your tags a simple 301 redirect assuming you didn’t change your tags base on the WordPress permalinks page is:
RewriteEngine On
RewriteRule ^tag/(.*)$ http://example.com/ [R=301,L]
That would 301 redirect all tags (everything indexed underexample.com/tag/(all tags have the /tag/ slug by default) to the home page of example.com
If you have changed the tag base on the permalinks page change tag to what you use.
If you’ve been using the monthly archive widget another good 301 redirect rule is:
RewriteEngine On
RewriteRule ^2013/(.*)$ http://example.com/ [R=301,L]
RewriteRule ^2014/(.*)$ http://example.com/ [R=301,L]
This would 301 redirect 2013 and 2014 dated archives to home. Dated archives have no SEO value, waste link benefit, so if you delete the monthly archive widget and/or the calendar widget add the above. Go back as far as your site’s existed, one line for each year.
Always check you haven’t got anything important indexed under a domain with a site search
Under “Settings” >> “Permalinks” I’ve changed my Category base to “responsive”.
I wouldn’t want to use a 301 redirect rule which included “RewriteRule ^responsive/(.*)$ ….” since it would 301 redirect all my indexed categories which I want spidered and indexed!
Also check with Google Webmaster Tools and/or Google Analytics none of your tags generate search engine traffic. If you find a few are pulling in traffic either keep those tags or 301 redirect them to the most relevant webpage on the site (similar SERPs).
If you had a tag called “Awesome” that had SERPs and a category called “Awesome Stuff” a possible solution would be delete all the tags and use this:
RewriteEngine On
RewriteRule ^tag/awesome/(.*)$ http://example.com/category/awesome-stuff/ [R=301,L]
RewriteRule ^tag/(.*)$ http://example.com/ [R=301,L]
This would 301 redirect the Awesome tag to the Awesome Stuff category conserving SEO benefit. All other tags 301 to home.
This way you can conserve any ranking value from tags that have SERPs and redirect the rest to home.
In my experience tags tend not to generate traffic, especially single word tags. I’ve bought dozens of WordPress blogs with loads of tags I’ve deleted and never had to use the above code to conserve traffic. Though being a perfectionist I setup those types of 301 redirects anyway, I look for the most relevant webpage for something I’ve deleted because I can :-)
David
More Comments by SEO Gold Services
SEO TutorialBroken W3 Total Cache Plugin HTML Cache : The Meta Tags article worked as expected in FireFox (I was logged into WordPress), but didn’t work in Google Chrome (not logged into WordPress in …
SEO TutorialSearch Engine Traffic Recovery : Glad to hear your search engine traffic is recovering, the adult niche is a great niche to be in for high traffic, sex/porn etc… will …
SEO TutorialHow to 301 Redirect a Directory : You add the .htaccess file 301 redirects to the domains you are redirecting FROM (domain1 and domain2 in your example) NOT the domain you are …
Sometimes there are more than one WordPress installation is necessary, but your host might have limited MySQL Database allowance. Well the solution to that problem is having multiple WordPress installation in one database.
You mustinstall WordPress manuallyin order for this to work. Most one click programs like Fantastic would not let you choose the prefix.
During the installation in your config.php phase, you want to change the prefix “wp_” in order to allow multiple installation. So it can be wpchris_ and the next one can be wpben_ you can use different prefix and use them to create as many installation as you need.
That is all you really need to do. This is also a security measure that you can take even if you don’t have to install multiple installation. By having a prefix, you are making the hacker work more to find out what is the SQL Address before he can hack.
Having compelling content is often not enough. Every visitor uses different criteria to judge whether your site is worth their time, but few issues can sink you as quickly asslow load times.
There are a lot of factors which can impact your loading times, and using high-resolution images is one of them. Their file size can be incredibly large. Most of us have experienced what it’s like to navigate through a website full of images that take forever to load – an experience made even more frustrating if you’ve been using the internet long enough to remember when speeds weren’t quite so snappy.
These days, the average fixed internet connection can easily handle high-resolution images, but smartphone usage continues to grow, and mobile connections aren’t nearly as reliable. With that in mind, let’s take a look at six WordPress image optimization plugins that can ensure your site is quick to load!
After installing and setting upEWWW Image Optimizer, it’ll automatically optimize any images you upload to your blog as long as they’re either JPG, PNG, or GIF files. It also includes a function to optimize your entire media catalog, in case you already have lots of images on your site.
One of the advantages of EWWW Image Optimizer is that the optimization process takes place within your own servers by default, instead of connecting to a third party service. This means your optimization tasks will require less time, which can come in handy when tackling large media libraries, since regular-sized files (<1mb) should ideally load in a few seconds.
This local optimization process is made possible by including several pre-compiled binaries, which must be installed from your local WordPress folder. This means some users may run into difficulties completing the setup process if they don’t have permission to execute the files.
To combat this potential issue, EWWW Image Optimizer also offers a cloud optimization feature, which while taking a bit longer to perform its duties, enables you to bypass this setup process. It’s also worth noting that while the plugin uses lossless optimization methods by default, it also enables you to apply lossy reductions for even bigger reductions in file size.
2. WP Smush
WP SmushisWPMU DEV’simage optimization plugin, available in both free and premium formats. As is common with this sort of plugin, any images you upload to your WordPress site will be automatically optimized (orsmushed, as the plugin developers like to call it).
The plugin also packs a bulk optimization option, which as its name implies, enables you to tackle multiple tasks at once – perfect if you’re looking to compress your image archive wafter installing the plugin. This bulk option is limited to 50 files at a time in the free version of the plugin.
You can also optimize images individually by heading over to yourMedia Library, clicking on whichever file you want to compress, and clicking on theSmushoption on theAttachment Detailswindow. This option can come in handy if for some reason you’d prefer not to use the bulk optimization option and have only a few images you’d like to compress.
By default, WP Smush uses lossless optimization techniques, but its pro version includes aSuper-Smushoption which optimizes each image multiple times using lossy compression techniques. This method can allegedly cut filesizes almost by half with a minimal loss of quality, but for the purposes of our article, we’re going to be sticking with the free version of the plugin.
3. ShortPixel Image Optimizer
ShortPixelnot only scores well when it comes to compression, it also packs a nice interface. After installing and activating the plugin, every JPG, PNG, and GIF you upload will be automatically optimized, and this plugin doesn’t enable you to turn off this option at all, as most others do.
A bulk optimization tool is included, and individual images can be compressed by opening yourMedia Libraryin theList Viewformat, where each file will appear with an individualOptimize Nowbutton alongside it.
ShortPixel enables you to choose between lossy and lossless compression methods, using the former by default. It optimizes all of the image thumbnails created by WordPress during the upload process, is capable of removing EXIF data (or preserve it you prefer), can establish a maximum resolution for your images, and best of all, it automatically saves a backup of every image you upload to a new folder.
In order to set up the ShortPixel plugin, you’ll be prompted to enter an API key during the activation process, which is provided for free by signing up with your email to their subscription list and doesn’t require any additional information.A free signup entitles you to 100 image compressions per month, and credits for additional tasks can be purchased separately or earned by referring new users to the service.
4. TinyPNG Compress JPG & PNG Images
TinyPNG Compress JPG & PNG Imagesis rather more drastic than the other plugins we’ve mentioned on this list when it comes to image optimization. It employs only lossy compression methods, which make for a drastic reduction in file sizes while mostly preserving the quality of the images undergoing the procedure.
The plugin doesn’t offer many configuration options in its settings page, since you can’t modify the compression methods it uses. However, you can choose maximum resolutions for your uploaded images, pick exactly which sizes you want to compress (i.e. thumbnail, medium, etc.), and whether or not to preserve the copyright information of each file if available.
Despite these limitations, TinyPNG images performs very well when it comes to the optimization process, and our tests didn’t show any obvious reduction in quality of the images after they were processed.
5. Optimus
WhileOptimusperforms admirably when it comes to the actual optimization process, the free version of this plugin includes a rather stifling 100kb file size cap on the images you can process, which essentially renders it a glorified demo. Generally, you’re trying to get to100kb, not size it down even further. It works really well and is simple, but it’s basically a premium plugin.
That being said, Optimus has a simple settings menu, which makes it a good choice if you’re looking for sheer performance and are not interested in fine-tuning the details of the optimization process.
By default, Optimus will (pardon the pun) optimize images as they’re uploaded, but it won’t show the compression details on theAttachment Detailswindow of each file, or in the menu, so you’ll have to manually compare file sizes in order to notice any difference.
This plugin won’t only optimize the files you upload, but also the multiple sized images that WordPress automatically creates for these media files (i.e. thumbnail, small, medium, and large).
6. Imagify
Imagifyis a newer go-to in the image optimization plugin scene, but it’s made a name for itself because of how useful and simple the whole process is, as well as how many options you get from a free plugin.
You can choose from three different settings for the optimization — Normal, Aggressive, and Ultra. Generally, Aggressive is a good spot where you can keep file size down without a noticeable dip in visual quality. As you move into Ultra compression, there may be blurring, slight pixelization, color ratio loss, and minor artifacts in the images. However, that lossy compression is incredibly effective at reducing file size.
You just sign up, grab an API key from them, and move through your files. You can individually optimize your library image by image, run a bulk optimization, and any images that you upload will be run through whatever default process you set up. In general, Imagify has looked at other plugins on the market and implemented the lessons they’ve learned very well.
Let’s Put Them to the Test
So far we’ve covered each plugin’s individual features, as well as their pros and cons. Now it’s time to see how they actually fare against each other when it comes to their intended purpose: image optimization. We’ve split the actual testing between JPG and PNG files since they’re the most commonly used types of graphic files on most websites, and chosen a single image with an average file size for each.
To get the best possible results, we’ve chosen lossy image optimization when possible, but that proved impossible with WP Smush and Optimus, due to a lack of alternatives. Despite the disparity in the results obtained from these particular plugins, we decided it would be best to include them alongside the rest for the sake of completion, since they remain some of the most popular image optimization tools available for WordPress.
We’d like to remind everyone that these results are far from exhaustive. Your mileage may vary depending on which particular image you choose to optimize, and these findings should be viewed only as an example of how each plugin performs individually.
As we can see, the plugins which applied a lossy optimization method obtained roughly similar scores across the board. Due to its slight edge when it comes to the compression percentage (plus all of its additional features), we’re going to recommend you go with TinyPNG if you use mostly JPG files on your site.
EWWW comes rather close as well. However, remember that it has a slightly more complicated setup than some others.
In this round, ShortPixel Image Optimizer took the lead with a slight advantage over the winners of the last section – once again with no noticeable reduction in the quality of the optimized images.
ShortPixel was one of our favorite plugins to use during the testing phase of this list due to its intuitive settings menu, which included solid descriptions for each feature. Its only downside is that it limits you to a maximum of 100 images per month and you’re required to purchase credits for any additional optimization tasks – same as the runner up, TinyPNG Compress JPG & PNG Images.
Conclusion
While optimizing your images won’t make your site magically load in milliseconds, it’s one of those things that show you take every detail into consideration. Even if the resources you save aren’t substantial to you as far as bandwidth goes (and let’s face it, bandwidth is pretty cheap), visitors with slow connections will definitely be thankful for it.
Just keep in mind that while we may have tested all of these plugins with different images, you will find that the results vary depending on the image you use. If you want to tackle image optimization seriously for your own projects, we recommend that you take the time to individually test some of our frontrunners to see for yourself just which plugin you prefer.
Have you found different results with any of these image optimization plugins? Let us know and subscribe to the comments section below!
Article featured image by Mikhail Grachikov / shutterstock.com
SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language=’en’ AND s.language!=’en’ WHERE s.context = ‘default’ LIMIT 1000 OFFSET 5000 made by activate_plugin
해당 에러와 같은 비슷한 에러가 일어나는 경우가 있다.
대충 살펴보다 보면, 데이터베이스 wcl_wp_icl_string_translations 에서 error가 발생한 사항을 확인할 수 있는데, 이는 WPML의 Table Schema Setting 이 Server에서 사용되는 Table Schema Set에 적합하지 않아서 발생하는 문제이다.
이 문제사항을 해결하기 위해서는 총 3가지를 점검해야하는데
1. MySQL Version
2. PHP Version
3. PHP script 내부에서의 query상의 오류이다.
불러오려는 데이터필드 일부를 찾을수가 없거나, 필드가 제대로 명시되어 있지 않은 경우 발생할 수 있다.
내 경우는 Mangboard와 WPML간의 호환성이 맞지 않아서 발생하는 문제인 줄 알았는데 그것이 아니라...
It appears that your MySQL database is rejecting the tables because it doesn’t like the length of the key in some of the tables.
I checked the table definitions and I didn’t see any indexes that were anything close to 3072 bytes (there was one I saw that was a little over 1000 bytes).
Do you know what version of MySQL you are running? Can you take a screenshot of the tables that were created? That should tell me which ones are missing and point me to potential issues.
