This page lists all content tagged with the term "mysql".

Tiiimestamp ain't on my side

No it ain't.

I had an existing MySQL table with a few columns, e.g. x, y, and z, and I needed to add a timestamp column `ts` to it. But when I tried, the column was filled with "<Error>" values. Read on to see how I fixed it.

Extending Drupal 7 text field character limit

After getting the message, "There is data for this field in the database. The field settings can no longer be changed." while trying to extend the character limit for a text field in a Drupal 7 instance, I used the code below to increase the character limit. It modifies the relevant parts of the database to allow more characters. I ran the SQL code through a content node with the PHP Code Text Filter enabled, but it could also be run in a custom module.

General error: 126 Incorrect key file for table

Saw this error in Magento admin:
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_7397_0.MYI'; try to repair it

Solved it by increasing the tmp directory space on the MySQL server.

Syndicate content