On my site's status page, I am seeing this error...

MSSQL Server Custom Functions
SUBSTRING:YES | SUBSTRING_INDEX:YES | GREATEST:YES | MD5:YES | LPAD:YES | REGEXP:NO | IF:YES | CONNECTION_ID:YES | CLREnabled:YES
Some custom functions are not available. Make sure you deploy them.

What is the meaning of "REGEXP:NO"? What do I need to install to address this?

My Drupal version is 9.5.10.

CommentFileSizeAuthor
#5 Screenshot 2024-01-19 at 1.37.25 PM.png73.86 KBkeshavv

Comments

arnoldbird created an issue. See original summary.

arnoldbird’s picture

arnoldbird commented
Issue summary: View changes
beakerboy’s picture

beakerboy
Primary language English
Location Kentucky
commented

From the README:

Drupal core allows module developers to use regular expressions within SQL statements. The base installation does not use this feature, so it is not required for Drupal to install. However, if any contrib modules use regular expressions, a CLR will need to be installed that is equivalent to CREATE FUNCTION {schema}.REGEXP(@pattern NVARCHAR(100), @matchString NVARCHAR(100)) RETURNS bit EXTERNAL NAME {name_of_function}

pstewart’s picture

pstewart commented
Status: Active » Closed (outdated)
keshavv’s picture

keshavv commented
Status: Closed (outdated) » Active
StatusFileSize
new Screenshot 2024-01-19 at 1.37.25 PM.png73.86 KB

I have found the same issue on Drupal 10.2.2. The site is hosted on Windows IIS Server.
Is this a critical issue?

pstewart’s picture

pstewart commented
Status: Active » Closed (outdated)

No, it's only a problem if you're using contrib modules that use REGEXP in their SQL queries. This status error is going to be downgraded to a warning - see #3415331: MSSQL Server Custom Functions Error on Status Report page should be a warning.