User Tools
faq:sqlstate-errors
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
faq:sqlstate-errors [2013/12/24 10:31] Alia created |
faq:sqlstate-errors [2014/01/27 08:18] (current) Alia Approved |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| This document lists most common SQLSTATE errors reported by Oxwall community members and ways to deal with them. | This document lists most common SQLSTATE errors reported by Oxwall community members and ways to deal with them. | ||
| - | =====Message: SQLSTATE[42000]===== | + | =====Message: SQLSTATE[42000] General error: 126===== |
| + | |||
| + | <code php> Message: SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/var/tmp/#sql_3ce9c_0.MYI'; try to repair it </code> | ||
| + | |||
| + | * Reported to happen when: varies | ||
| + | * Status: Server configuration. Not a bug. | ||
| + | * Caused by: /tmp folder running out of space on client's server. | ||
| + | * Links to discussions on Oxwall forum: | ||
| + | * * http://www.oxwall.org/forum/topic/16126?page=1#post-81101 | ||
| + | * * http://www.oxwall.org/forum/topic/16031?page=1#post-81098 | ||
| + | |||
| + | =====Message: SQLSTATE[42000] Syntax error or access violation: 1064===== | ||
| <code php> | <code php> | ||
| Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 1' at line 1 | Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 1' at line 1 | ||
| Line 14: | Line 25: | ||
| * Status: Oxwall Software bug. Fix planned for 1.6 | * Status: Oxwall Software bug. Fix planned for 1.6 | ||
| * Caused by: special symbols in user's name on Facebook. Example: Öliya | * Caused by: special symbols in user's name on Facebook. Example: Öliya | ||
| - | * Link to discussion on Oxwall forum: http://www.oxwall.org/forum/topic/3834?&page=2 | + | * Link to discussion on Oxwall forum: |
| + | * *http://www.oxwall.org/forum/topic/3834?&page=2 | ||
| + | * *http://www.oxwall.org/forum/topic/16031?page=1#post-81098 | ||
| =====Message: SQLSTATE[42S02]===== | =====Message: SQLSTATE[42S02]===== | ||
faq/sqlstate-errors.1387881061.txt.gz · Last modified: 2015/09/15 09:10 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
