Postgres function FIELD not found

Created on 4 September 2012, over 12 years ago
Updated 27 February 2024, 11 months ago

I've migrated from mysql to postgresql and while trying to read a verse I got this error.

PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR: function field(bigint, integer) does not exist LINE 1: ...N' AND chapter = 14 ORDER BY verse, linemark DESC,FIELD(bid,... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.: SELECT * FROM {bible_context} WHERE bid IN (1) AND book = 'GEN' AND chapter = 14 ORDER BY verse, linemark DESC,FIELD(bid, 1); Array ( ) em bible_all() (linha 1673 de /mydomain.com/sites/all/modules/bible/bible.module).

🐛 Bug report
Status

Closed: outdated

Version

1.0

Component

Code

Created by

🇧🇷Brazil ipsec

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024