22635

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

Question:

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:

<blockquote>

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

</blockquote>

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?

Answer1:

Try again to remove the space after 'LOWER'.

--<br /> SELECT LOWER(...

Answer2:

Fixed the problem by updating the mysql software.

Recommend

  • Datetime field overflow with IBM Data Server Client v9.7fp5
  • Why is this query not working in Sybase?
  • Can't connect with PDO using ssl but mysqli with ssl works
  • How to get the sql state from libpq?
  • ZipList with Scalaz
  • Alamofire and Reachability.swift not working on xCode8-beta5
  • New Firebase failed: First argument must be a valid firebase URL and the path can't contain “.”
  • JSON encode and decode on PHP
  • Building Qt project for C++11 standard
  • Question about instantiating object
  • Updating both a ConcurrentHashMap and an AtomicInteger safely
  • Xcode 4 NSLog Macro link in Xcode 3
  • Can you perform a UNION without a subquery in SQLAlchemy?
  • Email verification using google app script and google forms
  • PostgreSQL Query without WHERE only ORDER BY and LIMIT doesn't use index
  • NHibernate Validation Localization with S#arp Architecture
  • How to rebase a series of branches?
  • How can I send an e-mail from a vbs script
  • Accessing IRQ description array within a module and displaying action names
  • Display Images one by one with next and previous functionality
  • Build own AppleScript numerical error handling
  • Websockets service method fails during R startup
  • ORA-29908: missing primary invocation for ancillary operator
  • How to get next/previous record number?
  • Google cloud sdk not working when python points python3
  • Is there a mandatory requirement to switch app.yaml?
  • SQL merge duplicate rows and join values that are different
  • Hits per day in Google Big Query
  • How do you join a server to an Active Directory (domain)?
  • FormattedException instead of throw new Exception(string.Format(…)) in .NET
  • Getting Messege Twice Using IMvxMessenger
  • File not found error Google Drive API
  • How does Linux kernel interrupt the application?
  • Qt: Run a script BEFORE make
  • Linking SubReports Without LinkChild/LinkMaster
  • XCode 8, some methods disappeared ? ex: layoutAttributesClass() -> AnyClass
  • Observable and ngFor in Angular 2
  • How to Embed XSL into XML
  • UserPrincipal.Current returns apppool on IIS
  • Conditional In-Line CSS for IE and Others?