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.
我一直在使用FuelPHP开发一个新的web应用程序。今天，当我试图向数据库添加信息时，突然出现了错误。
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:
我仍然可以从数据库中检索信息，所以登录信息必须是正确的。但是当我尝试添加信息时，我得到了以下错误信息:
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) FROMcountriesWHEREname= 'costa rica'" in /home/danlucas/public_html/portfolio-dir/music-online/fuel/core/classes/database/pdo/connection.php on line 167错误- 2012-08-06 15:48:37——>错误- SQLSTATE[42000]:语法错误或访问违规:1305函数dan_monline。更低的不存在查询:“从名称= '哥斯达黎加'的国家中选择较低的(姓名)，在/home/danlucas/public_html/portfolio-dir/music-online/fuel/core/classes/数据库/pdo/连接。php在第167行
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?
我不确定这是FuelPHP特有的错误，还是MySQL导致了问题。从我的理解来看，“低”是不存在的?
Has anyone seen this error before or know how to fix it?
有人见过这个错误吗?
2 个解决方案
#1
2
Try again to remove the space after 'LOWER'.
再试着在“下”后删除空格。
--
SELECT LOWER(...
——选择低(…
#2
1
Fixed the problem by updating the mysql software.
通过更新mysql软件解决了这个问题。
#1
2
Try again to remove the space after 'LOWER'.
再试着在“下”后删除空格。
--
SELECT LOWER(...
——选择低(…
#2
1
Fixed the problem by updating the mysql software.
通过更新mysql软件解决了这个问题。