MySQL

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.

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.

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.