User Tools

Site Tools


Dealing with SQLSTATE errors

You got 500phtml error >enabled debug mode >saw SQLSTATE error. What to do next?

SQLSTATE errors indicate that something is wrong in the way script communicates with your database. This document lists most common SQLSTATE errors reported by Oxwall community members and ways to deal with them.

Message: SQLSTATE[42000] General error: 126

 Message: SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/var/tmp/#sql_3ce9c_0.MYI'; try to repair it 

Message: SQLSTATE[42000] Syntax error or access violation: 1064

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[42S02]

Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'table_name” doesn't exist.

Message: SQLSTATE[23000]

Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2145871224for key “PRIMARY”

Message: SQLSTATE[08S01]

Message: SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes


Message:SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine. Unknown: write failed: No space left on device (28) File: Unknown Line: 0


Message:SQLSTATE[28000] [1045] Access denied for user 'user@localhost(using password: YES)

faq/sqlstate-errors.txt · Last modified: 2014/01/27 08:18 by Alia