- 🇺🇸United States smustgrave
Believe this can be marked complete. Going to mark fixed so those that kept up get their credit.
Automatically closed - issue fixed for 2 weeks with no activity.
I am trying to implement this module for my site which uses MSSQL database and it gives error on database logs report
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'REGEXP'.: SELECT base_table.[vid] AS [vid], base_table.[nid] AS [nid] FROM {node} base_table INNER JOIN {node_field_data} node_field_data ON node_field_data.nid = base_table.nid WHERE ( ([node_field_data].[type] = :db_condition_placeholder_0) AND ([node_field_data].[status] = :db_condition_placeholder_1) AND ([node_field_data].[title] REGEXP :db_condition_placeholder_2) ); Array ( [:db_condition_placeholder_0] => article [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => [[:<:]]sample\ test[[:>:]] ) : SELECT base_table.[vid] AS [vid], base_table.[nid] AS [nid] FROM {node} base_table INNER JOIN {node_field_data} node_field_data ON node_field_data.nid = base_table.nid WHERE ( ([node_field_data].[type] = :db_condition_placeholder_0) AND ([node_field_data].[status] = :db_condition_placeholder_1) AND ([node_field_data].[title] REGEXP :db_condition_placeholder_2) ); Array ( [:db_condition_placeholder_0] => article [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => [[:<:]]sample\ test[[:>:]] ) in Drupal\scanner\Plugin\Scanner\Node->replace() (line 109 of /var/www/html/hrcms/modules/contrib/scanner/src/Plugin/Scanner/Node.php).
It works fine for Mysql database site.
Please let me know if any solution is available for this issue. I need to implement this on the site using mssql.
Thanks!
Fixed
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Believe this can be marked complete. Going to mark fixed so those that kept up get their credit.
Automatically closed - issue fixed for 2 weeks with no activity.