Syntax error or access violation for simple search

Syntax error or access violation for simple search

References

Reference NO 1

http://stackoverflow.com/questions/15194951/syntax-error-or-access-violation-for-simple-search

Reference NO 2

http://stackoverflow.com/questions/14695219/tree-behavior-fails-on-save-with-syntax-error-or-access-violation

Reference NO 3

https://drupal.org/node/1208286

Reference NO 4

http://sourceforge.net/p/magmi/support-requests/25/

Reference NO 5

http://www.magebuzz.com/blog/2012/03/03/syntax-error-or-access-violation-1067-invalid-default-value-for-period/

Reference NO 6

http://www.andreavb.com/forum/viewtopic_4924.html

Reference NO 7

http://www.drupalgardens.com/content/sqlstate42000-syntax-error-or-access-violation-1064-when-adding-contentuser-posted-filter-vi

Reference NO 8

http://www.bigresource.com/VB--VB6-and-Select-syntax-error-i5DaaHMRit.html