SQLSTATE [42000]：语法错误或访问冲突：1305 [英] SQLSTATE[42000]: Syntax error or access violation: 1305

问题描述

我一直在使用FuelPHP开发一个新的Web应用程序。
今天，突然，当我尝试添加信息到数据库时，错误开始出现。

I've been using FuelPHP to develop a new web application. Today, all of a sudden, errors started appearing when I try to add information to the database.

我仍然可以从数据库检索信息，所以登录信息必须正确。但是当我尝试添加信息时，我收到以下错误消息：

I can still retrieve information from the database so the login information must be correct. However when I try to add info I'm getting the following error message:

错误 - 2012-08-06 15:48:37 - >错误 - SQLSTATE [42000]：语法错误或访问冲突：1305 FUNCTION dan_monline.LOWER不存在与查询：SELECT LOWER（ name ）FROM <$ c $ /> / / / / core / classes / database / pdo / connection.php on line 167

Error - 2012-08-06 15:48:37 --> Error - SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION dan_monline.LOWER does not exist with query: "SELECT LOWER (name) FROM countries WHERE name = 'costa rica'" in /home/danlucas/public_html/portfolio-dir/music-online/fuel/core/classes/database/pdo/connection.php on line 167

我不知道这是一个FuelPHP特定的错误，如果是MySQL是造成问题。根据我的理解，它是说LOWER不存在？

I'm not sure if this is a FuelPHP specific error or if it is MySQL that is causing the problem. From what I understand it's saying that 'LOWER' doesn't exist?

以前有人看过这个错误或知道如何解决它吗？

Has anyone seen this error before or know how to fix it?

推荐答案

通过更新mysql软件解决了这个问题。

Fixed the problem by updating the mysql software.

这篇关于SQLSTATE [42000]：语法错误或访问冲突：1305的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！