Technical Q&A

MySQL Logo
| 2 min read
From MySQL 5.7 onwards, the error SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column will appear if any non aggregated columns are in the select list, which is not in the group by clause. This article discusses one such use case with Mautic and how we solved it.
Drupal sitebuilding tips
| 6 min read
Agility is at the core of any Drupal site building project. The market changes fast, so the business needs. A Drupal site builder or developer also needs to support the business in this agile environment. This tutorial covers how to solve the error - "There is data for this field in the database. The field settings can no longer be changed."
The website encountered an unexpected error. Please try again later
| 3 min read
"The website encountered an unexpected error. Please try again later." this is the most common error encountered by a Drupal developer. Usually, errors are logged by Drupal and the logs can be accessed from Admin->Reports->Recent log messages. But when you get "The website encountered an unexpected error. Please try again later." you cannot even access the reports dashboard.
Zyxware default image4
| 2 min read
You can always create a view manually, and change the configuration one by one manually. And, all done. But, still, there is a chance of manual error. Drupal9 allows you to import-export views. You can follow the below steps to Import and Export views
Zyxware default image3
| 2 min read
In pre Drupal 8 era, the global variable $user was available every where, from you can easily get the current logged in user id. For all new version of Drupal, you should use \Drupal::currentUser()->id() Once you have the user id, you can use the User::load to get the user object.
Zyxware default image3
| 2 min read
Have you ever faced problems trying to delete all the contents of a particular content type in a Drupal website? Drupal is a CMS technology and supports Drupal developers/content writers to add content. I think content writers can face problems while trying to delete content. There are two modules in Drupal that help us overcome this issue, they are:
Zyxware default image4
| 2 min read
Clearing cache is something that a Drupal developer do frequently. Here are the 4 most popular ways to clear the cache. 1.Install the devel module which adds a cache clear option for administrators. You'll find a devel block to add to a region for quick cache clearing. 2. If you install the admin menu and get a quick menu in the top left for clearing various caches in Drupal.