Edit /etc/my.cnf
[mysqld]wait_timeout = 28800
interactive_timeout = 28800
max_allowed_packet=640M
Then stop and start mariadb.
Then don’t forget to restore the old values…
ERROR 2006 (HY000) at line 1030: MySQL server has gone away
Category Archives: MySQL
ERROR 1005 (HY000) at line 6032: Can’t create table ‘cms.product_id’ (errno: 150)
On the import sql or code, add
SET FOREIGN_KEY_CHECKS=0;For more readings MySQL – FOREIGN KEY Constraints Documentation
PHP MySQL to MySQLi migration shim library
phpmyadmin – Your password does not satisfy the current policy requirements
mysqli_query(): (HY000/1819): Your password does not satisfy the current policy requirements
I generally use the PHPMyAdmin to generate the passwords,
what I’v done in this case, but I got the following error….
SHOW VARIABLES LIKE 'validate_password%';
| Variable_name | Value | |
|---|---|---|
| validate_password_check_user_name | OFF | |
| validate_password_dictionary_file | ||
| validate_password_length | 8 | |
| validate_password_mixed_case_count | 1 | |
| validate_password_number_count | 1 | |
| validate_password_policy | MEDIUM | |
| validate_password_special_char_count | 1 |
SET GLOBAL validate_password_policy = 0;
#1366 – Incorrect integer value: ” for column ‘upd_iid’ at row 1
While I was switching a legacy site from servers… some SQLs weren’t working…
#1366 - Incorrect integer value: '' for column 'upd_iid' at row 1
This worked for me…
I’v edited my /etc/mysql/my.cnf and comment the original “sql_mode” and added this one
sql_mode = ""
Save and restart mysql!
live MySQL queries
On your mysql console…
mysql> SHOW VARIABLES LIKE "general_log%";
+------------------+----------------------------+
| Variable_name | Value |
+------------------+----------------------------+
| general_log | OFF |
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+
mysql> SET GLOBAL general_log = 'ON';Then!
tail -f -n200 /var/run/mysqld/mysqld.log
After debugging… don’t forget to turn it OFF!
mysql> SET GLOBAL general_log = 'OFF';
The used table type doesn’t support FULLTEXT indexes
ERROR 1214 (HY000) at line 323: The used table type doesn’t support FULLTEXT indexes
Upgrade to 5.6 and use InnoDB Full-Text Search
codeigniter + php + mysql – emojis 😉
This is how…
On mysql set your table(s)’s filed(s) to utf8mb4_general_ci.
codeigniter config/database.php
$db['default']['char_set'] = 'utf8mb4';
$db['default']['dbcollat'] = 'utf8mb4_general_ci';Resources
https://stackoverflow.com/questions/16828197/displaying-utf8-character-on-codeigniter
MySQL – compare tables and generate SQL
PHP MySql compare table structure – ONLINE!
This site can compare two MySQL database table structures and generate the necessary SQL statements to update the second table to be identical to the first.
It compares the table creation SQL statements of two MySQL databases as outputted from the mysqldump command or phpmyadmin.
The site determines what changed from one database to the other and generates schema alteration SQL statements to create, drop and alter tables that should be applied to one database to make it have the same schema of the other.
mysql – #1241 – Operand should contain 1 column(s)
So!, I was/am writing a subquery to get a value to rating_stars… and I got this (beginner) error…
mysql – #1241 – Operand should contain 1 column(s)
(SELECT value, (sum(value)/count(value)) FROM model_ratings WHERE modelId = id) AS rating_stars
Subquery should return one column, whatever corresponds to rating_stars.
(...) (SELECT (sum(value)/count(value)) FROM model_ratings WHERE modelId = id) AS rating_stars (...)