{"schemaVersion":3,"id":"CVE-2014-0080","aliases":["GHSA-hqf9-rc9j-5fmj"],"status":"published","duplicateOf":null,"title":null,"description":"SQL injection vulnerability in activerecord/lib/active_record/connection_adapters/postgresql/cast.rb in Active Record in Ruby on Rails 4.0.x before 4.0.3, and 4.1.0.beta1, when PostgreSQL is used, allows remote attackers to execute \"add data\" SQL commands via vectors involving \\ (backslash) characters that are not properly handled in operations on array columns.","dates":{"published":"2014-02-20T11:00:00.000Z","modified":"2024-08-06T09:05:37.826Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":6.8,"severity":"medium","version":"2.0","versionLabel":"v2.0","source":"NVD","vector":"AV:N/AC:M/Au:N/C:P/I:P/A:P","computed":false,"selection":"backend-summary"},"metrics":[{"version":"2.0","versionLabel":"v2.0","source":"NVD","score":6.8,"severity":"medium","vector":"AV:N/AC:M/Au:N/C:P/I:P/A:P","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.01266,"percentile":0.69336,"severity":"low","asOf":"2026-10-20T00:00:00.000Z","change":{"pp":0,"baselineDate":"2026-09-20T00:00:00.000Z","baselineScore":0.01266},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-20T00:00:00.000Z","score":0.01266,"percentile":0.69336}],"last30":[{"date":"2026-09-20T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01266,"percentile":null},{"date":"2026-10-20T00:00:00.000Z","score":0.01266,"percentile":0.69336}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-89","name":"Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')","description":"The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.","type":"weakness","status":"Stable","abstraction":"Base","likelihoodOfExploit":"High","url":"https://cwe.mitre.org/data/definitions/89.html"}],"affected":[{"vendor":"RubyGems","product":"activerecord","name":"activerecord","label":"activerecord","ecosystem":"RubyGems","cpePart":null,"purl":"pkg:gem/activerecord","purlType":"gem","versions":[{"text":"≥ 4.0.0, < 4.0.3","noFixRecorded":false,"fixedIn":null},{"text":"≥ 4.1.0.beta1, < 4.1.0.beta2","noFixRecorded":false,"fixedIn":null}],"versionsText":"≥ 4.0.0, < 4.0.3 | ≥ 4.1.0.beta1, < 4.1.0.beta2","eol":null,"hubHref":null},{"vendor":"rubyonrails","product":"rails","name":"rails","label":"rails","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"4.0.0","noFixRecorded":false,"fixedIn":null},{"text":"4.0.0:beta","noFixRecorded":false,"fixedIn":null},{"text":"4.0.0:rc1","noFixRecorded":false,"fixedIn":null},{"text":"4.0.0:rc2","noFixRecorded":false,"fixedIn":null},{"text":"4.0.1","noFixRecorded":false,"fixedIn":null},{"text":"4.0.1:rc1","noFixRecorded":false,"fixedIn":null},{"text":"4.0.1:rc2","noFixRecorded":false,"fixedIn":null},{"text":"4.0.1:rc3","noFixRecorded":false,"fixedIn":null},{"text":"4.0.1:rc4","noFixRecorded":false,"fixedIn":null},{"text":"4.0.2","noFixRecorded":false,"fixedIn":null},{"text":"4.1.0:beta1","noFixRecorded":false,"fixedIn":null}],"versionsText":"4.0.0 | 4.0.0:beta | 4.0.0:rc1 | 4.0.0:rc2 | 4.0.1 | 4.0.1:rc1 | 4.0.1:rc2 | 4.0.1:rc3 | 4.0.1:rc4 | 4.0.2 | 4.1.0:beta1","eol":{"isEol":null,"eolDate":null,"matchMethod":"cpe","cycle":null,"product":{"name":"rails","label":"Ruby on Rails","category":"framework"}},"hubHref":"/vendor/rubyonrails/rails"}],"affectedCount":2,"eol":{"hasEol":false,"count":0},"references":[{"url":"https://groups.google.com/forum/message/raw?msg=rubyonrails-security/Wu96YkTUR6s/pPLBMZrlwvYJ","label":"groups.google.com/forum/message/raw?msg=rubyonrails-security/Wu96YkTUR6s/pPLBMZrlwvYJ","hostname":"groups.google.com","tags":["Mailing List","X Refsource MLIST"]},{"url":"http://openwall.com/lists/oss-security/2014/02/18/9","label":"openwall.com/lists/oss-security/2014/02/18/9","hostname":"openwall.com","tags":["Mailing List","X Refsource MLIST","WEB"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2014-0080","label":"nvd.nist.gov/vuln/detail/CVE-2014-0080","hostname":"nvd.nist.gov","tags":["Advisory"]},{"url":"https://github.com/advisories/GHSA-hqf9-rc9j-5fmj","label":"github.com/advisories/GHSA-hqf9-rc9j-5fmj","hostname":"github.com","tags":["Advisory"]},{"url":"https://github.com/rails/rails/tree/main/activerecord","label":"github.com/rails/rails/tree/main/activerecord","hostname":"github.com","tags":["PACKAGE"]},{"url":"https://github.com/rubysec/ruby-advisory-db/blob/master/gems/activerecord/CVE-2014-0080.yml","label":"github.com/rubysec/ruby-advisory-db/blob/master/gems/activerecord/CVE-2014-0080.yml","hostname":"github.com","tags":["WEB"]},{"url":"https://web.archive.org/web/20210301004521/https://groups.google.com/forum/message/raw?msg=rubyonrails-security/Wu96YkTUR6s/pPLBMZrlwvYJ","label":"web.archive.org/web/…","hostname":"web.archive.org","tags":["WEB"]}],"lineage":{"upstream":[],"downstream":["MGASA-2014-0191"],"duplicates":[],"related":[]},"timeline":[{"kind":"published","date":"2014-02-20T11:00:00.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2024-08-06T09:05:37.826Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":27,"level":"medium","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-20T20:11:19.955Z","stale":false,"partial":false}}