# SQLite version and sqlite3-ruby

**URL:** <https://www.ruby-forum.com/t/sqlite-version-and-sqlite3-ruby/117094>\
**Category:** Ruby\
**Created:** [October 12, 2007, 10:41pm UTC](https://www.ruby-forum.com/t/sqlite-version-and-sqlite3-ruby/117094 "2007-10-12T22:41:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Une\_BSSSSvS\_ue](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/2acd7d/32.png) [@Une\_BSSSSvS\_ue](https://www.ruby-forum.com/u/Une_BSSSSvS_ue)\
**Post date:** [October 12, 2007, 10:41pm UTC](https://www.ruby-forum.com/t/sqlite-version-and-sqlite3-ruby/117094/1 "2007-10-12T22:41:37Z")

</div>

When i run a ruby script with a MacOS X 5MacPorts) version of SQLite  
(3.3.15) i get an error :  
SQLite3::SQLException: no such function: get\_zy\_string

BUT this function is used successfully in my mobile phone, then, the  
phone might have a newer version of SQLite (according to the SQLite web  
site the latest is Version 3.5.1).

Then, i’d like to now how to uninstall the gem “sqlite3-ruby” and  
re-install it linked to a newer version of SQLite …

---

<div class="post-metadata">

**Author:** ![Une\_BSSSSvS\_ue](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/2acd7d/32.png) [@Une\_BSSSSvS\_ue](https://www.ruby-forum.com/u/Une_BSSSSvS_ue)\
**Post date:** [October 13, 2007, 8:50am UTC](https://www.ruby-forum.com/t/sqlite-version-and-sqlite3-ruby/117094/2 "2007-10-13T08:50:46Z")

</div>

Une Bévue [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> When i run a ruby script with a MacOS X 5MacPorts) version of SQLite  
> (3.3.15) i get an error :  
> SQLite3::SQLException: no such function: get\_zy\_string
> 
> BUT this function is used successfully in my mobile phone, then, the  
> phone might have a newer version of SQLite (according to the SQLite web  
> site the latest is Version 3.5.1).
> 
> Then, i’d like to now how to uninstall the gem “sqlite3-ruby” and  
> re-install it linked to a newer version of SQLite …

Jamis B. (the dev of sqlite3-ruby) gave me the reason why i get this  
error :  
Note that sqlite3 lets applications define their own functions. I  
strongly suspect that the query in question is coming from an app that  
has custom-defined get\_zy\_string and get\_py\_string, because neither of  
those functions are defined by sqlite3 itself.  
You’ll need to determine what those functions are supposed to do, and  
then implement them using the sqlite3 custom-function API’s.