15,020
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→SQL and Query Errors
No edit summary |
|||
| Line 320: | Line 320: | ||
Further reading: | Further reading: | ||
* [https://dev.mysql.com/doc/mysql-reslimits-excerpt/5.6/en/subquery-restrictions.html MySQL :: MySQL Restrictions and Limitations :: 4 Restrictions on Subqueries] | * [https://dev.mysql.com/doc/mysql-reslimits-excerpt/5.6/en/subquery-restrictions.html MySQL :: MySQL Restrictions and Limitations :: 4 Restrictions on Subqueries] | ||
=== Error: MySQL Incorrect datetime value: '0000-00-00 00:00:00' === | |||
Workaround solution<pre>[https://stackoverflow.com/questions/35565128/mysql-incorrect-datetime-value-0000-00-00-000000 MySQL Incorrect datetime value: '0000-00-00 00:00:00' - Stack Overflow]</pre>: | |||
<pre> | |||
SET SQL_MODE='ALLOW_INVALID_DATES'; | |||
</pre> | |||
== Connection and Network Errors == | == Connection and Network Errors == | ||