Quality Work Make Your Dream Come True
WordPress BuddyPress bbPress Developer

How To Wordpress

Free Mysql Server

Are there free mysql server on the internet?

A user ask me are there mysql servers free of charge, the answer is yes, of course, the amazing world have a few amazing guy, this is one of free mysql server — https://www.db4free.net/, Markus built a platform which allows users build and test mysql server free of charge, you even can test the newest version of mysql, in the current time, it is mysql 8.0.

It is very easy to create a free mysql server in one minute

Yes, it is super easy, just open this link: create an account for free , and typed

the MySQL database name, MySQL username, MySQL user password, MySQL user password verification , then enter your email address, you will receive email which tell you the mysql server is already for you! Quick and Easy, right?

It looks like this:

Just one minute, I create a 200M mysql database.

Please note, just like Markus said:

db4free.net is a testing service which means it is not suitable for production, There can be outages, data loss and security features do not meet the standards which you expect from a professional data hosting provider. If you need a MySQL database for production use, please do not use db4free.net!

Please don’t abuse their resource, it is great to help student, and many poor guys which can start their IT dream, If you like their free service, you can find the donate link at their sidebar. 🙂

Best Regards,

Tomas

WordPress Tips: Tools for how to find out what is slowing down your site and make it faster 1 of 10

As a wordpress developer, I helped a few friends speed up their site from 20s to 2~3s,  in general, what I will do it minify js and css and html, enable gzip compress, optimize images, reduce http requests numbers and reduce http requests size, add expires headers, enable CDN, switch php verion to php7.x, optimize mysql, enable database cache, object cache …. and …. and more. For speed up these performance optimization work, I used a few tools to get help me work more faster, I am happy to share them with you, my dear friends. 🙂

There are many site speed tools, for me, a useful online web performance tool is varvy.com, it is free, I use this online tool to audit client’s webpage for front-end issues.

Let’s use my site as a bad example — I designed my original theme at 2008,   I did not upgrade my theme in many years, so it is a good example to show front-end problems. In the current time, after 8 years? my theme is still works, at the bottom of the page, you can find w3c validator is still living, but it is too old, I will upgrade my theme to follow wordpress new API standard and add new features and share it on wordpress.org.

Page Speed Check

let’s Open https://varvy.com/pagespeed/, don’t worry, it’s a great tool which alexa rank is 31046. Input your site URL, and click test button, the report of page speed optimization will shown very quickly, it looks like this:

You can see the summary of page speed optimization told you a few problems on your site, for me, it is:

images not optimized, css not minumized, js not minifiled, browser caching issues, this is not good.

Also in the top right, the report shown screenshot of my site and give us a resources report. Scroll down, let see more details:

The “CSS delivery” section tell us front-end problems:

too many external css files, render blocking css files, 1 css file were called using @import, In  element css found, css not minimized

My god, too bad, I hate this.

In “Javascript usage” section, the report told me:

Over 300k of javascript, Total Javascript size: 620 k , three or more external js files, render blocking js found

Also the report use red color to tell me which js file size is too large:

addthis_widget: 347.015 kb

jquery: 97.184 kb

datepicker: 75.876 kb

The report let me know what is js and css problems quickly, the site is very FAST, although if you check their page source, you will find they did not minified html at all. Some other online tools need wait about 30s ~ 100s for get a result, this is a reason why I use it first to fix most obvious issues.

Next section is “Image optimization”, report said: “Image performance issues found.”

It lists all images which Not Optimized in the checking page, for example:

3d-tag-cloud.png | Not Optimized | Could save 155.2KiB if optimized (94%)

Optimize this image can save 94%, it is great help for speed up my site,  I can’t wait to reduce size of these images!

Also the tool will told us “Browser caching”:

Browser caching not enabled for all resources, also it tell me details about this issue:

You can find on my domain speed up your site via tomas.zhu.bz, the report said:

No caching errors found for resources served from origin domain.

What caused the problem?

Browser caching not enabled from these domains called from this page:

m.addthisedge.com
s7.addthis.com

Yes, I using addthis plugin, I hope my posts can be shared with readers, if it is a little helpful. 🙂

And then next is optimized sections lists:

It include:

Compression is enabled for all resources

Server responded in less than 200 milliseconds

And so on. Site owner is a gentleman, he said “Thanks for using this tool”, Thanks for https://varvy.com/, you built a great tools to help webmasters and developers like me. 🙂

Mobile Friendly Test

Goodbye? No, no, wait a moment, varvy.com have another good feature — test your site on mobile, because my theme is designed at 2008, I did not add mobile features, so my theme is a good sample for show errors on mobile, please don’t miss-understanding me, I am not ignored mobile users, in some country and in some sites, 70% users is come from mobile devices,  I have designed many themes which is support mobile devices, also  I have customized many child themes to let plugins support mobile devices, all of them is get A rank or score 100 / 100  in speed test sites, once I have time from my hard works, I will re-design my theme to support mobile user and share it with you, if you have any ideas, please tell me, I am happy to add it into this theme.

Now please just open home page on https://varvy.com/, and in the top left, there are mobile test link, just click it and enter your site URL and wait about 15s, you will get mobile report like this:

You can find my site just get 64 / 100 on Mobile friendly, and there are details about issues:

  • Font size is small
  • Viewport not configured
  • Tap targets are small
  • Browser caching issues
  • Render blocking CSS and/or JS
  • CSS not minimized
  • Javascript not minified
  • Images not optimized

It is useful to get a glance of problems on mobile devices.

SEO Tool

On the home page of varvy.com, there are another tool I like to use: seo tool, if you enter your site URL, you will get a seo diagnosis report:

 

Based on this report, I found I do ignored a few SEO points.

This is section one of “WordPress Tips: Tools for how to find out what is slowing down your site and make it faster“, I will share other tools in next articles, thanks for read my posts, if you have any great thoughts, please don’t hesitate to me and other reader. Have  a happy day with your family. 🙂

 

Best Regards,

Tomas

WordPress 4.7.2 Security Release – fix serious content injection vulnerability

WordPress 4.7.2 was released in January 26th, 2017. An Unauthenticated Privilege Escalation Vulnerability in a REST API Endpoint was fixed. The WordPress Official advises the users to update the sites immediately.

WordPress 4.7.2 Security Release - fix serious content injection vulnerability

WordPress 4.7.2 Security Release – fix serious content injection vulnerability

The issue reporter Sucuri said, modify the WordPress website content will produce a modified data packet, The attacker can modify URL to bypass the account verification and directly view the contents of the website by REST API, In addition, the vulnerability even allows an unauthenticated user to modify the content of any post or page within a WordPress site.other content.

Sucuri provide technical details of the vulnerability and write the conclusion in his blog:

This is a serious vulnerability that can be misused in different ways to compromise a vulnerable site. Update now!

 

 

WordPress tag cloud plugin: 3D Tag Cloud

 WordPress tag cloud plugin: 3D Tag Cloud

WordPress tag cloud plugin: 3D Tag Cloud

3D Tag Cloud plugin is a free wordpress plugin to allow the tag label to appears in the form of 3D animation.

3D Tag Cloud plugin has the same function as WordPress default tag, but 3D Tag Cloud plugin provides more rich effects visually, but also very flexible, 3D Tag Cloud plugin has the following features:

Title of the Tag Cloud.
Number of tags to be displayed.
Height and Width of the widget.
Background Color.
Text Color.
Font.
Font maximum size.
Font minimum size.


This plugin is very popular now, support Support multiple languages, e.g, French, German, Portuguese – Brazilian, Slovak, Spanish.

You can download here: https://wordpress.org/plugins/cardoza-3d-tag-cloud/

 

 

WordPress Security update: WordPress 4.7.1 release

WordPress Security update: WordPress 4.7.1 release

WordPress Security update: WordPress 4.7.1 release

The official WordPress news, 36 days after the official release of the WordPress 4.7 version, WordPress 4.7.1 release, which is a security update version.

This version fixes the vulnerability, which will affect all of the previous version of the WordPress, Tomas Zhu recommended you upgrade in time. Before the upgrade, please backup the modified theme files, WordPress files, as well as the database.

There are 8 issues about this security update:

1. Remote code execution (RCE) in PHPMailer – No specific issue appears to affect WordPress or any of the major plugins we investigated but, out of an abundance of caution, we updated PHPMailer in this release.
2. The REST API exposed user data for all users who had authored a post of a public post type. WordPress 4.7.1 limits this to only post types which have

specified that they should be shown within the REST API.
3. Cross-site scripting (XSS) via the plugin name or version header on update-core.php. Reported by Dominik Schilling of the WordPress Security Team.
4. Cross-site request forgery (CSRF) bypass via uploading a Flash file.
5. Cross-site scripting (XSS) via theme name fallback.
6. Post via email checks mail.example.com if default settings aren’t changed.
7. A cross-site request forgery (CSRF) was discovered in the accessibility mode of widget editing.
8. Weak cryptographic security for multisite activation key.

If you are not a professional technical staff, these should have little impact on us, but for the sake of safety, Tomas zhu recommended you to upgrade in time.

In addition to repair 8 major security vulnerabilities, WordPress 4.7.1 also repair 62 Bugs based on WordPress 4.7. The WordPress official had push a new version of the update notification in your site’s admin area, after backing up all the data(the modified theme files, WordPress files, as well as the database), you can updated in your site’s admin area.

The version does not involve the compatibility issues of language packs, themes and plugin, so you can update in time after having backed up.

WordPress.4.7.1 Download: https://wordpress.org/wordpress-4.7.1.zip

How to Avoid WordPress Permalink 404 on Your Apache Server

A friend ask me why all pages on his wordpress site are 404 page not found, after he enabled pretty wordpress permalink structure, I did a quick check and I found he did not enable mod_rewrite on his apache at all, I record fix steps in here:

1: ssh to your server and log in as root, on ubuntu, the command will be

sudo su

2: activate mod_rewrite on your site, on ubuntu, it should be:

sudo a2enmod rewrite

then restart your apache, on ubuntu, this should be:

sudo service apache2 restart

3: Allow edit .htaccess file, wordpress will write all rewrite rules in .htaccess, on ubuntu, you need change the apache config file like this:

sudo nano /etc/apache2/sites-enabled/000-default.conf

ubunThis will open nano edit window, you will find there are line like this:

DocumentRoot /var/www/html

under this line, just add:

<Directory /var/www/html>
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
allow from all
</Directory>

then CTRL+O to save and CTRL+x to exit nano.

and restart your apache again:

sudo service apache2 restart

 

4: Go to wordpress admin area and change permalinks to Pretty Permalinks, it means the link structure like:

https://yourdomain.com/?/p=1

will looks like:

https://yourdomain.com/hello-world

It is better to understand and it is better for SEO.

Best Regards,

Tomas

 

Thumbnails Regenerate and Thumbnail Rebuild AJAX to help rebuild all thumbnails without script timeouts on your server

Speak of WordPress, the colorful theme templates and omnipotent plugins is the most attractive for us, WordPress support automatically uploading pictures for users to generate thumbnails. A variety of multiple thumbnails enable us to maximize to optimize the theme visual effects.

Generally we install the theme, automatically generated thumbnail size according to the needs, so that the theme automatically calls, or we manually insert the images into the page. But when we change a new theme, the problem comes, the new theme probably needs different size of thumbnail size from prvious theme. At this time, we have a variety of ways to regenerate the Thumbnail images. But for me, the most simple, the most thorough, the most perfect way is to regenerate all of thumbnail images of the whole website.

So I found the following 2 plugins:

Thumbnails Regenerate

Thumbnails Regenerate

Thumbnails Regenerate

Thumbnail Rebuild AJAX

Thumbnail Rebuild AJAX

Thumbnail Rebuild AJAX

If you search in internet, you will find that these two plugins frequently appear in the author recommendation lists. Tomas Zhu only used Regenerate Thumbnails because it was in self built server, I set the PHP execution time limit very long, and the number of pictures on the site is not so much, so the process of regeneration thumbnails is successful. And for those users with too much images in the site, Thumbnail Rebuild AJAX may be a better choice. Read the introduction from Thumbnail Rebuild AJAX, it can solve the problem of the massive picture execution time exceeds PHP setting.

When you have a lot of full-size photos, the script on the server side takes a long time to run. Unfortunately the time a script is allowed to run is limited, which sets an upper limit to the number of thumbnails you can regenerate. This number depends on the server configuration and the computing power your server has available. When you get over this limit, you won’t be able to rebuild your thumbnails. AJAX Thumbnail Rebuild allows you to rebuild all thumbnails at once without script timeouts on your server.

 

 

EWWW Image Optimizer – image optimization plugin

EWWW Image Optimizer - image optimization plugin

EWWW Image Optimizer – image optimization plugin

Image compression can not only improve the image loading speed when accessing, but also reduce server bandwidth. EWWW Image Optimizer is a WordPress image optimization plugin. This Plugin can automatically optimize your images, the image has been uploaded this will be optimized, EWWW Image Optimizer achieve the optimization effect mainly by reducing the size of the image, the plugin has settings Options in admin panel, you can use lossy compression picture, lossless compression picture in default. It can optimize the images that you have already uploaded, convert your images automatically to the file format that will produce the smallest image size.

Reduce image sizes in WordPress including NextGEN, GRAND FlAGallery, FooGallery and more using lossless/lossy methods and image format conversion. EWWW Image Optimizer is very popular image optimization plugin, more than 400,000 downloads.

WP Tips: in a minute, remove the “Briefly unavailable for scheduled maintenance” message after automatic upgrade

A good guy contact me said that his site is “shutdown” and there are just a white screen with a message “Briefly unavailable for scheduled maintenance, Check back in a minute“, but he waiting more than 1 day, the site is still shutdown and always in the Maintenance mode.

Actually this is because he setting his site as automatic upgrade mode, sometimes, maybe hosting have a little problems, for example, your wordpress just successfully removed files from your plugin folder bbpress, but did not successfully removed the bbpress folder ,  so the upgrade can not be finished. for avoid any risk, wordpress will add a maintenance file in your wordpress installation folder, only when upgrade successfully completed, wordpress will remove the maintenance file, so this is why our sites always show “Briefly unavailable for scheduled maintenance, Check back in a minute”, because in any time, if your wordpress installation folder have the maintenance file, your site will only show “Briefly unavailable for scheduled maintenance, Check back in a minute“.

To remove the problem, it is very easy,

1: Logged in your FTP or your CPanel,  Check plugins or themes folders and sort via time, check recent updated folder, in general, you will find some folders and files in these folder have problems, you can just remove these folder and download the official codes from wordpress.org, then upload it again.

 

2: Go to your wordpress installation folder, and remove “.maintenance" file.

3: Open  your front end,  you will find the site is come back

 

My suggestion is, if you update your site, install a coming soon or maintenance plugin, add your note and a countdown for example something we will come back about 02:15:25. So your users will know your site is maintenance and they will come back about 2 hours later. In general, a good coming soon plugin should setting your site as “503” status, which means The 503 Service Unavailable error means that the web site’s server is not available, usually due to maintenance or server overloading, this is help for your SEO.

Anything I can help you? contact me. 🙂

Best Regards,

Tomas

 

Page 1 of 41234