TechNote (Archived)

ColdFusion MX 7: Error 127 from table handler when querying MySQL

Issue

---

When using ColdFusion MX 7 and MySQL, an error may be encountered when attempting to query a MySQL database. Customers experiencing this issue receive the following error when attempting to query a MySQL database from ColdFusion MX 7:

 Error Executing Database Query. General error: Got error 127 from table handler java.sql.SQLException: General error: Got error 127 from table handler  at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)  at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)  at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source) 

Reason

---

The above error is caused by corruption in the MySQL database table that is being queried.

Solution

---

Repair the MySQL database table. For details on repairing MySQL database table, please refer to the MySQL Documentation.

Search Support

---