Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 Reference: MySQL Error 1054

MySQL Error 1054 : SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR) Unknown column '%s' in '%s'

FileMaker Error Codes

Lasso Error Codes

MySQL Error Codes

Windows System Errors

About this database
This is a free public resource. It is unmoderated and operates on the "public virtue" system. I hope you find it useful!

User Contributed Notes

2017-11-04 02:59:35

This errors appears when trying to INSERT a TEXT value into a field, without placing it inside of inverted commas, 'example'. This does not apply to INTERGER (numbers) values.

E.g. [wrong syntax]
INSERT INTO Customers (firstName)
VALUES (Scott); = ERROR 1054

[Correct syntax]
INSERT INTO Customers (firstName)
VALUES ('Scott');

This is my note and I want to edit it | Report an inappropriate comment

+ Add your own note