排除 MySQL 技術疑難問題: Difference between revisions

Jump to navigation Jump to search

排除 MySQL 技術疑難問題 (edit)

Revision as of 23:39, 14 October 2024

972 bytes removed ,  14 October 2024
→‎錯誤！：SQLSTATE[HY000]：一般錯誤
Line 298: Line 298:


* 如果 MySQL 用戶具有 {{kbd | key = <nowiki>SUPER</nowiki>}} 權限<ref>[https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html MySQL :: MySQL 8.0 Reference Manual :: 6.2.2 Privileges Provided by MySQL]</ref>，則增加 {{kbd | key = <nowiki>max_allowed_packet</nowiki>}} 的值<ref>[https://stackoverflow.com/questions/5688403/how-to-check-and-set-max-allowed-packet-mysql-variable php - how to check and set max_allowed_packet mysql variable - Stack Overflow]</ref>。
* 如果 MySQL 用戶具有 {{kbd | key = <nowiki>SUPER</nowiki>}} 權限<ref>[https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html MySQL :: MySQL 8.0 Reference Manual :: 6.2.2 Privileges Provided by MySQL]</ref>，則增加 {{kbd | key = <nowiki>max_allowed_packet</nowiki>}} 的值<ref>[https://stackoverflow.com/questions/5688403/how-to-check-and-set-max-allowed-packet-mysql-variable php - how to check and set max_allowed_packet mysql variable - Stack Overflow]</ref>。
== 錯誤！：SQLSTATE[HY000]：一般錯誤 ==
訊息：錯誤！：SQLSTATE[HY000]：一般錯誤
狀況：當我使用 [http://php.net/manual/en/book.pdo.php PHP: PDO]
解決方案：
* "您不應該在 update 或 insert 查詢中使用 {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}}" <ref>[https://stackoverflow.com/questions/12979510/pdo-error-sqlstatehy000-general-error-when-updating-database php - PDO error: " SQLSTATE[HY000]: General error " When updating database - Stack Overflow]</ref>。
* 您不應該在查詢 {{kbd | key=<nowiki>INTO OUTFILE ...</nowiki>}} 中使用 {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}} <ref>[http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/ Save MySQL query results into a text or CSV file]</ref><ref>[https://stackoverflow.com/questions/13369164/cant-create-write-to-file-errcode-22 mysql - Can't create/write to file (Errcode: 22) - Stack Overflow]</ref>。


== 錯誤：SQLSTATE[HY000] [2002] 沒有這樣的文件或目錄 ==
== 錯誤：SQLSTATE[HY000] [2002] 沒有這樣的文件或目錄 ==
Retrieved from "https://wiki.planetoid.info/index.php/Special:MobileDiff/25020"

Navigation menu