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.
MySQL
The MySQL 1030 error occurs due to the local disk space issue. The error typically occurs when the server MySQL runs from, utilises the total disk space and tries to execute any of the below mentioned tasks.
Have you ever faced an error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock', while trying to log in to MySQL as any user?
You can login to your MySQL via the following terminal command.
mysql -u root -p
or
mysql -u root -pPassword
Its recommended, not to use passwords in terminal command, due to privacy reasons.
Verify that, your MySQL is running. If not, start service by typing following command in your Linux terminal.
sudo service mysql start
or
Slick is a powerful solution for slideshow/carousel. It supports nested sliders and can be implemented in your custom block of Drupal 7 site. Slick has jQuery dependency. Download the latest jQuery and use in your page or use jQuery update module for Drupal 7.
Download slick libraries from https://github.com/kenwheeler/slick/. Extract the folder and place it in sites/all/themes/yourtheme/ and rename the library as slick. While creating slider, we need to use only slick.css and slick.min.js in the folder slick-slider/slick.
Before we discuss on how to to join multiple database tables using db_select in Drupal 7, let me tell you that we can add as many joins as we want and most methods such as, 'fields', 'conditions', joins etc. can be called multiple times. However, one thing may be worth mentioning is that the call to join() needs to be separate. It should not be "chained", meaning that one should use this,
While settings up local installation in my system I came across this error (PHP fatal error 'Undefined class constant MYSQL_ATTR_USE_BUFFERED_ QUERY'). I tried a lot to fix it. Finally got the solution as follows. The reason for this error is missing pdo_mysql extension in my PHP installation.
Command line provides a platform to that takes input from keyboard to interact with the operating system. In Linux Operating System's, the Command line is often referred to bash.
MySQL in Command Line
In one of the Drupal sites were working on, the members of the site frequently found that the nodes they had created were crashing. They would enter content into the node fields and try to save the node. The node would appear to save with apparently no error message. They found that it was not accessible at all afterwards. This wasn't occurring for everyone. We checked the dblog and we saw that the users were getting the error PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value:. Read on to know how we solved this issue.
Suppose you forgot mysql password in the middle of a project and you tried almost all passwords and failed. So the only option left is to change the password. Then you can follow the below steps. Please note that you have to login as admin for doing this process.
The designing industry is highly competitive, and to get ahead in the race, designers need to keenly focus on being technical as well as strategic. Here are a few common issues that designers have to face during web design and development.
An entity is a useful abstraction to make grouping together of fields. Here I am giving you a brief view about how the custom entities created, adding extra fields, adding bundles etc all things attached to entity.
There are some constraints when giving passwords for mysql databases when using with drupal 6. Some special characters will make the site unavailable with the error "Access denied for user 'user'@'localhost' (using password: YES)" even if the password is correct in Drupal 6.
To connect into MySQL database with the help of PHP based web applications we are in need of mysql_connect or by PDO method. Here i have added a common function which will be useful for the php based websites to connect into the database.
We as a PHP Drupal web platform developer most often has to face the situation to export data from one table to another table of same database or to table of another database (if site uses multiple databases) during the process of any change in normal work flow.
Most of us normally think to export the data from one table to another by firstly querying the required data from source table and then looping through the query result and inserting them to destination table. This can be simply achieved with a single query.
This article lists some of the basic MySQL commands how to create a new database, a new database user and granting privileges to a user.
How to create a new database from terminal.
The first step here is to log in as the MySQL root from terminal using the following command.
mysql -u root -p Now this will prompt for the MySQL root password.
Enter password : After entering the MySQL root password we will be able to log in to the MySQL prompt.
The next step is to create the new database.
Many Drupal programmers, Drupal site admins and Drupal site users have encountered errors similar to "User warning: Illegal mix of collations (PDOException: SQLSTATE[HY000]: General error: 1267)" in their Drupal site. If you are facing the same situation in your Drupal site then read on to find out more.
Many Drupal users have encountered the following error in their Drupal sites. "user error: Access denied for user: 'user@host' to database 'database' query: LOCK TABLES sequences WRITE in [path]/database.mysql.inc on line xx". If you are facing the same error message in your Drupal site then read on to find out the solution.
Many Drupal users received a "user warning: Got error 28 from storage engine query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2,3) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/your-username-here/public_html/modules/block/block.module on line 433." If you are facing the same situation in your Drupal site then read on to find out the solution.
Many Drupal users received a "Got a packet bigger than 'max_allowed_packet' " error in their Drupal sites. If you are facing the same situation in your Drupal site then read on to find out the solution.
As a web developer, we sometimes may want to export a specific table from a MySQL database. It can be particularly helpful when we are going to apply some changes to a table that is part of a large database and we are interested in backing up that specific table only, rather that whole huge database.
To create a backup (also called dump) of the a table use this command:
mysqldump -u username -p db_name table_name | gzip > db_name.table_name.sql.gzThis will create the backup/dump for the table in the file in compressed format.