Troubleshooting of MySQL errors: Difference between revisions

Troubleshooting of MySQL errors (edit)

583 bytes removed , 12 May 2024

14,953

edits

@@ Line 122: / Line 122: @@
 Solution: Fix the typo in the function name
-== 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>
 == Database and Table Operation Errors ==