Select Page

Website administration Blogs

How to fix ‘503 service unavailable error’ in your websites

In our role as Server administration specialists for server owners, website errors are a commonly encountered issue that we resolve for them.

‘503 service unavailable error’ is one such website error. Recently, we were contacted by a Docker hosting provider who was getting this error in his website.


How to fix Magento error “Syntax error or access violation: 1118 Row size too large”

As a server administration company, we often get support requests from website and server owners.

Recently we were called on to fix this error in a Magento 2 server:

SQLSTATE[42000]: Syntax error or access violation:1118 Row size too large. The Maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

Everything started when the customer added new products into Magento.

Soon after this error was displayed, and Product Re-Indexing failed (uh oh).

Indexing of several products failed, and without those indexes, the product pages started loading slow (15 secs load time instead of the usual 3 secs).

Visitors started bouncing from the site, and orders started taking a dip.

Needless to say, it was an Emergency situation, and we started working on it through our priority channel : Emergency Support Services.

Here are the various solutions we considered, and if you are in a similar situation, here’s how you can fix this error.


What is “Syntax error or access violation”?

That is MySQL’s way of saying it was asked to do something that’s not permitted.

In this case, the amount of data you’ve given as input was larger than the table size.

That is what it meant by saying “The Maximum row size for the used table type is 65535.


What causes “Syntax error or access violation” in Magento?

Magento is built to store large amounts of data about a single product. This includes, description, attributes, price, dates, and more.

Usually Magento places these data in 6 or more database tables.

But that causes a performance penalty. It takes several seconds (if not more) to execute queries on multiple tables and then display a single product.

To make the store fast, Magento provides an option to put all this data in to a single database table,  so that all information about a product can be fetched with a single query.

This option is called a Flat Catalog.


flat catalog error Syntax error or access violation

How Flat Catalog is enabled in Magento 1.9


The problem with Flat Catalog

Using a single table is a great idea to reduce database query time.

But it comes with a limitation – a limitation imposed by MySQL, that is, each product can store only 65535 Bytes (= 64 KB) of information.

If any product has more than 64 KB of information (as in descriptions, attributes, production options, etc.), it cannot be inserted into the table. MySQL will throw the error “The Maximum row size for the used table type is 65535.

If you are not sure this is the error you are facing, click here to talk to a Magento Expert. We’re online 24/7, and can get on your case within minutes.


How to resolve “Syntax error or access violation” in Magento

In Magento, Flat Catalog is the most common epicenter for this error. If you’ve enabled Flat Catalog, there are basically two ways to resolve this issue:

  1. Make the flat catalog row data smaller.
  2. Disabling flat catalog and using full page caching to improve page loading speed.

The first option is the easier way, and the second one is for better for more complex stores. We’ll look at these options one by one.


1. Remove rarely used product attributes

Product attributes are a great way for your customers to quickly find out what they need.

However, you can always find out (via analytics) which attributes are used more, that lead to the most purchases.

You can then make an educated choice as to which attributes are important, and which ones can be removed.

To fix this error, find attributes that have the most amount of content, but that are used less.

If you can get rid of 3 to 5 attributes of that nature, you are done!

If you are not sure how to find out which attributes are least used, we can help. Click here to consult a Magento expert. We’re online 24/7 and we can assist you in a few minutes.


Un-assign rarely used attributes from the attribute set - "Syntax error or access violation"

Un-assign rarely used attributes from the attribute set.

PS: This is the option that our customer chose to resolve this error. He had included many extra attributes to improve searches, but many were redundant in reality.


2. Prevent complex attributes getting into Flat Catalog

Some attributes can have multiple values (via multi-select), like say “Cloth Size”, or “Sleeve Length”.

Such attributes introduce many values in one field, and can quickly eat up space.

If you prevent these attributes from being displayed on the front end, it’ll not be listed in the Flat Catalog, and you can save space.

To do this, go to the attributes that have large content (Catalog –> Attributes –> Manage Attributes in admin area), and disable them in front end Navigation and Product listing as shown here.

If you are not sure which attributes can be harmlessly disabled, we can help you. Click here to consult a Magento expert. We’re online 24/7 and we can assist you in a few minutes.


Reduce attribute usage Syntax error or access violation

Disabling front end navigation of an attribute saves space in Flat Catalog table.


3. Change “Multi-Select” to “Dropdown” for attribute input type

If you really can’t disable any complex attributes, try changing the attribute input type to “Dropdown” instead of “Multiselect”.

As you can imagine, using a “Multiselect” will require passing multiple values of a single attribute in a single search or listing.

Instead, if you use Dropdown, you can limit your listing and searches to 1 value per attribute, thereby saving space.

You may need to re-create the chosen attributes and change it as shown here:


Drop down instead of multi-select - Syntax error or access violation


4. Disable Flat Catalog and enable Page Caching

The purpose of Flat Catalog is to prevent costly multiple table database queries.

The same effect can be achieved by using a Page Caching system like Varnish, where a copy of each page will be cached in the server memory.

So, when a visitor requests a page, Magento doesn’t even have to go to the database. It can simply serve the page from memory.


How to disable Flat Catalog

As the first step, disable Flat Catalog by going to System –> Configuration, and toggling the settings shown here:

disabling flat catalog


How to enable page caching in Magento 2

Magento 2 has out of the box support for Varnish, but it needs to be customized for your store.

The full details are out of the scope of this article, however, here’s a general guide.

  1. Go to Stores –> Settings –> Configuration –> Advanced –> System.
  2. Choose “Built-in Application” as the “Caching Application” under the “Full Page Cache” section.


Full page cache - Mage 2

Basic cache setup in Magento 2


This should get your store out of the ditches, but to make your store truly fast, you’ll need to use a specialized HTML caching system like Varnish.

For that you’ll need to install and setup Varnish in your server, and then choose “Varnish Caching” as your “Caching Application”.

It should be done only after considering many factors like your available server resources, size of the store, daily traffic and more.

You can do this by trial and error (and suffer a few site downtimes), or you can get our Magento experts to do this for you. Click here to consult our Magento experts. We’re online 24/7 and we can assist you in a few minutes.


How to enable page caching in Magento 1.x

Unlike Magento 2, there’s no built-in page cache for Magento 1.x.

However, you can use an external add-on like Turpentine ( to integrate Varnish into your Magento.

Again, this could get messy if you don’t configure the Varnish server to suit your store and traffic.

Click here to get this done for you within a few hours.



Many Magento users see the error “SQLSTATE[42000]: Syntax error or access violation:1118 Row size too large.” when updating products. A common cause for this is large data sets associated with product attributes. Today we’ve seen various ways in which this issue can be resolved.




How to speed up Magento – Top 10 proven ways [Updated 2018]

Magento is a popular eCommerce app for a lot of reasons – it’s secure, feature rich and super stable.

BUT, it has an Achilles’ heel – Poor Speed

The default settings in Magento is not optimized for speed, and pages can take up to 10 seconds to load. (more…)

How to choose the right web support company – 5 point checklist

Managing a website can be hard. To keep your site business ready, you need to routinely optimize the databases, replace bulky plugins, renew SSL certificates, upgrade software, optimize pages for SEO, and more.

That’s quite a lot of work, considering you still need to update your pages, product list and features to keep your site user friendly. But where do you get the time for all this when you have a business to run? That is why you need a dedicated expert to maintain your website.

Which leads us to the question : How do you choose a reliable website support company for your business? (more…)

How to update WordPress version without website downtime

Are you a WordPress website owner? You’d have come across this notification in your WordPress admin dashboard atleast once – ‘An updated version of WordPress is available.’

WordPress is the most popular CMS and they often releases updates to their software, with feature updates or security patches. You’d also find an ‘Update Now’ button in the dashboard to update WordPress version in a click. (more…)

Speed up website – How the perfect server solution can boost your slow websites

A slow website does more harm to your business than good. Not only would customers abandon it, they may also share negative reviews with others.

We’ve seen scenarios where a single website slows down the entire server. In our server administration services, we often get requests to speed up websites.


How to secure WordPress website from hacks!

How to secure WordPress website from hacks!

WordPress powers 19% of the web, and 48 of the top 100 blog sites online. With a strong community of users and developers, the WordPress platform is evolving day by day, with more features and Add-ons.

This, in turn, poses some threats as well. Vulnerabilities and hacks can end up disrupting the website functioning. There have been many instances where a blog owner lost complete access to his site. (more…)

How to fix ‘502 server error – Bad Gateway’ in web servers

How to fix ‘502 server error – Bad Gateway’ in web servers

Google forums get bombarded by customer complaints whenever they see a ‘502 server error – Bad Gateway’ in their Google applications. Though an intermittent error, it can often shoo away visitors from your website.

Bobcares helps website owners and web hosting providers fix all website and application errors, and this error is often reported at our Website Administration Services. (more…)

How to handle multiple project management for WordPress without incurring software conflict

How to handle multiple project management for WordPress without incurring software conflict

Being the most popular CMS for websites, WordPress development and management has an important role in online businesses. WordPress project management is a common task we perform as a part of our custom software development services.

Many often, development companies have multiple WordPress projects, which creates so much overhead and can incur software conflicts. From software development to DevOps, we cover all the stages involved in the project management for WordPress, for our customers. (more…)

Using WordPress Docker containers to prevent project delays

Using WordPress Docker containers to prevent project delays

WordPress customization and plugin development is a common task we perform in our custom software development services. A typical WordPress development workflow starts with setting up development environment to uploading the bug-free code to the live website.

The WordPress environment that we setup, can vary with each project requirement. The version, features, plugins, web applications, content, etc. would change depending on the business. (more…)

Page 1 of 812345...8