admin

About Warren Chandler

Warren Chandler is a freelance web programmer and web developer, based in Frinton on Sea, Essex. Warren specialises in web programming, web design, corporate identity, copy writing, SEO, logo and print media for home, work, and mobile platforms.

MySQL Fix: Error #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

From time to time when migrating a WordPress website, you may come across collation issues when migrating the database. Specifically, a common error message when importing via PHPMyAdmin is the #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ error. When Wordpress updated to version 4.2 they introduced support [...]

2018-11-07T01:05:20+00:00August 6th, 2017|WordPress Snippets|0 Comments

Restrict Dates to Future Only in Gravity Forms Datepicker

Gravity Forms is quite possibly the best forms plugin available for WordPress, but even with the vast array of functionality it offers right out of the box it still has its limitations. One such limitation is the date picker field, offers practically no chance of [...]

2020-09-25T23:45:06+00:00July 12th, 2017|WordPress Snippets|11 Comments

Change Howdy Welcome Message on WordPress Admin Bar

It's often the small things that tend to annoy us, and in the case of one client it was the "Howdy" message on the right of the WordPress admin bar. A small thing perhaps, but how can you change it, programmatically? Fortunately help is at [...]

2018-11-07T01:06:41+00:00July 7th, 2017|WordPress Snippets|2 Comments

Add Mailchimp DKIM and SPF Records in cPanel/WHM

Managing your domain authentication to send mail with Mailchimp or similar mail providers can sound like a daunting task, but it's a relatively simple process. Hopefully this article will hold your hand through the experience and allow you to send mail via external websites, quickly [...]

2018-11-07T01:07:07+00:00April 4th, 2017|Web Services|1 Comment

Restrict WordPress Registration to Certain Email Domains

Recently for a project it was necessary to restrict WordPress registration to a select few specific domains, for example: domains with an email address from a certain company, i.e. email addresses ending with @warrenchandler.com. Rather than using a plugin to do limit domain access when registering, [...]

2019-03-13T01:32:49+00:00December 12th, 2016|WordPress Snippets|18 Comments

How to prevent or reduce nausea and motion sickness with PlayStation VR

People who know me are aware of the fact that I like a gadget or two (perhaps the understatement of the year). Arguably the hottest gadget around at the moment for consumers/gamers is the PlayStation VR, but it does come with its downsides.  And these [...]

2018-11-07T01:08:03+00:00November 12th, 2016|General|1 Comment

WooCommerce Product Unavailable Out of Stock Problem

UPDATE: On later versions of WooCommerce in 2020 you may also try the following fix for the 30 limit threshold. https://www.warrenchandler.com/2020/06/27/woocommerce-variations-break-after-30-or-more-bug-fix/ Recently, a client was reporting that they were seeing an out of stock message on their product page, which wasn't correct.  All of the [...]

2020-06-27T17:42:03+00:00November 8th, 2016|Web Programming, WordPress Snippets|17 Comments

WordPress Resize at Upload Plugin mysql_real_escape_string() Error

If like me you use the WordPress plugin Resize at Upload, or Resize at Upload Plus, it's quite likely that you'll be getting a mysql error when changing the settings.  Something like: Access denied for user ''@'localhost' (using password: NO) in /home/accountname/public_html/wp-content/plugins/resize-at-upload/resize-upload.php on line 63 [...]

2018-11-07T01:08:52+00:00June 26th, 2016|PHP Snippets, WordPress Snippets|1 Comment

WordPress Login Redirect For Different User Roles

From time to time clients come to me requesting login redirects in WordPress. The following handy snippet below allows you to specify where the user lands once they've logged in, based on user roles. In the example, users with Administrator and Editor roles are redirected [...]

2018-11-07T01:10:06+00:00August 29th, 2015|WordPress Snippets|0 Comments

Increase WordPress Upload Size from 8MB (Multi-Site)

WordPress installations can be confusing at times, and when combined with the PHP environment in which they reside, uploading can be one area that causes quite a bit of confusion. To give an example, recently a client asked for a solution to the following problem: [...]

2018-11-07T01:11:00+00:00March 6th, 2015|Web Programming, WordPress|0 Comments

WordPress Search Syntax in URL for Custom Post Types

WordPress isn't exactly Google when it comes to searching. The system is long overdue an overhaul, but while we wait for the never-arriving necessity you can still get much more out of your WordPress searches. Today a programmer client asked me something that I thought [...]

2018-02-02T03:09:31+00:00January 25th, 2015|WordPress, WordPress Snippets|0 Comments

Move the Cart in a WooCommerce Single Product

WooCommerce is a fantastic WordPress plugin, but unless you're really familiar with how it works you may run into a number of things that, on the surface at least, can not be done. One such thing is modifying the single product page template to rearrange [...]

2018-02-02T03:09:31+00:00January 25th, 2015|Programming Tips, Web Programming|0 Comments
Go to Top