SQLSTATE[42000]: Syntax error or access violation: 1305

database fuelphp
xonorageous picture xonorageous · Aug 6, 2012 · Viewed 8.6k times · Source

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:

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

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?

Answer

mamor picture mamor · Aug 8, 2012

Try again to remove the space after 'LOWER'.

--
SELECT LOWER(...

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More