14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
+ ERROR 1813
(+ ERROR 1813) |
|||
| Line 115: | Line 115: | ||
) final | ) final | ||
WHERE final.rank <= 10 | WHERE final.rank <= 10 | ||
</pre> | </pre> | ||
| Line 139: | Line 131: | ||
Solution: Increase {{kbd | key = innodb_buffer_pool_size}} e.g. [http://stackoverflow.com/questions/5696857/how-to-change-value-for-innodb-buffer-pool-size-in-mysql-on-mac-os innodb - How to change value for innodb_buffer_pool_size in MySQL on Mac OS? - Stack Overflow]. | Solution: Increase {{kbd | key = innodb_buffer_pool_size}} e.g. [http://stackoverflow.com/questions/5696857/how-to-change-value-for-innodb-buffer-pool-size-in-mysql-on-mac-os innodb - How to change value for innodb_buffer_pool_size in MySQL on Mac OS? - Stack Overflow]. | ||
== ERROR 1690 - BIGINT UNSIGNED value is out of range == | |||
Message: MySQL error #1690 (BIGINT UNSIGNED value is out of range) | |||
Solution <ref>[https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html MySQL :: MySQL 8.0 Reference Manual :: 11.2.6 Out-of-Range and Overflow Handling]</ref><ref>[https://stackoverflow.com/questions/34115917/mysql-error-1690-bigint-unsigned-value-is-out-of-range-for-unix-timestamp MySQL error #1690 (BIGINT UNSIGNED value is out of range) for UNIX_TIMESTAMP() - Stack Overflow]</ref>: | |||
<pre> | |||
SET sql_mode = 'NO_UNSIGNED_SUBTRACTION'; | |||
</pre> | |||
== ERROR 1813: Tablespace for table xxx exists == | |||
Message: ERROR 1813 Tablespace for table xxx exists. | |||
Solution | |||
* [https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp mysql - Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT - Stack Overflow] | |||
== ERROR 1827 (HY000): The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. == | == ERROR 1827 (HY000): The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. == | ||