Database JSON support required

Created on 10 January 2023, almost 2 years ago
Updated 16 January 2024, 10 months ago

Problem/Motivation

This module is currently incompatible with Drupal 10. The main issue stems from the policy decision that all databases must support JSON functionality ( https://www.drupal.org/node/3192484 β†’ ). SQL Server itself does, but it uses different function names and the module/driver does not translate the commonly used JSON requests.

Is a solution actively being worked on?

πŸ“Œ Task
Status

Fixed

Version

4.4

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States tevans

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.

  • πŸ‡¬πŸ‡§United Kingdom pstewart

    I ran into some trouble applying #5 as the file was formatted as UTF-16. This version of the patch is reformatted as UTF-8, but is otherwise identical to #5. Can confirm it works as expected talking to an SQL Server 2017 database.

    As far as I can tell the hasJson method is the only thing we need to do at this stage, other stuff relating to json appears to be still active in core at the moment, such as mapping json data types in the schema API etc.

  • πŸ‡¬πŸ‡§United Kingdom pstewart
  • Assigned to pstewart
  • πŸ‡¬πŸ‡§United Kingdom pstewart
  • πŸ‡¬πŸ‡§United Kingdom pstewart

    I've now committed this to 4.4.x for inclusion in the next dev release. I've encountered no issues with this when running the Drupal 10 installer with an SQL Server database, and have confirmed the Status Report shows 'Database support for JSON' as being 'Available'. I think this is therefore all done, however I'll keep this issue at 'Needs Review' while the 4.4.x branch is in development and testing, and we'll move to 'Fixed' once we're ready to release 4.4.0 as stable.

  • πŸ‡ΊπŸ‡ΈUnited States .Kris.

    Hello,

    I have installed 4.4.x-dev, but I am still getting this error when I run update.php, and it is not allowing me to do the upgrade:

    Requirements problem
    Errors found
    Database support for JSON
    Not available
    Is required in Drupal 10.0.

  • πŸ‡ΊπŸ‡ΈUnited States .Kris.

    Here are the files in question (on left), compared to a clean install of Drupal 10.1 on the right:

  • πŸ‡¬πŸ‡§United Kingdom pstewart

    @.Kris. What version of SQL Server are you currently using? Note that JSON support is only available in SQL Server 2016 (13.x) and later.

  • Status changed to Fixed 11 months ago
  • πŸ‡¬πŸ‡§United Kingdom pstewart
  • Automatically closed - issue fixed for 2 weeks with no activity.

Production build 0.71.5 2024