10
Views
1
Comments
[SEO Utils on Steroids] URL_GetSEOURL gives error when used on Oracle
seo-utils-with-steroids
Reactive icon
Forge asset by João Marques
Application Type
Reactive

Hi,

I want to use this module but on the action URL_GetSEOURL I get an oracle error.
Is the module oracle compatible?

Error executing query. Error in advanced query GetSEOData in URL_GetSEOURL in SEOUtils_Lib (SELECT      TOP 1      CASE WHEN {SiteRule}.[Id] IS NOT NULL THEN {SiteRule}.[Incoming] ELSE {Parameter}.[Val] END [Domain],      CASE WHEN {SiteRule}.[Id] IS NOT NULL THEN 1 ELSE 0 END [IsSiteRule],      {PathRule}.[Incoming] [PathRule],      CASE WHEN {PageMetaRule}.[Id] IS NOT NULL THEN 1 ELSE 0 END [IsPageMeta],      {PageMetaRule}.[Incoming],      CASE WHEN {Application}.[ApplicationKind] = @RuntimeKindId_WebResponsiv THEN 1 ELSE 0 END  FROM      {PathRule}      CROSS JOIN      {Espace}      INNER JOIN      {Module}      ON {Espace}.[Id] = {Module}.[Espace_Id]      INNER JOIN      {App_Definition_Module}      ON {App_Definition_Module}.[Module_Id] = {Module}.[Id]      INNER JOIN      {Application}      ON {App_Definition_Module}.[Application_Id] = {Application}.[Id]          AND {Application}.[Is_Active] = 1      LEFT JOIN      {SiteRule}      ON {PathRule}.[ExclusiveToSiteRule] = {SiteRule}.[Id]          AND {SiteRule}.[Is_Active] = 1      LEFT JOIN      {PageMetaRule}      ON {P ...): ORA-00923: FROM keyword not found where expected 

Kind regards,

Johan

2018-10-29 08-31-03
João Marques
 
MVP

Hi Johan,


Thanks for bringing this to our attention.

Indeed, this action was leveraging on an advanced SQL node written with SQL Server-specific syntax, and thus not working on Oracle.

I uploaded a new version of the component which leverages now in an Aggregate instead, thus working regardless of the database provider.


Kind Regards,
João

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.