lordmage
  •  lordmage
  • 62.6% (Friendly)
  • YAF Camper Topic Starter
2014-04-22T14:23:28Z
How solvent is giving sql search button issue does not search my site in google and yandex search is doing thanks in advance.

Selim's Place Management



Turkish :

Arama butonu sql sorunu veriyor nasıl çözücem sitemin içinde arama yapmıyor google ve yandex'te arama yapıyor teşekkürler şimdiden.

Selim'in Yeri Yönetim
Waiting Selim's Place Forum members Everyone I'm glad you are.
http://seliminyeri.net/forum.aspx 
Sponsor
tha_watcha
2014-04-23T11:55:21Z
That is a known issue in the current version and will be fixed in 2.1.2 Final.

But you can quickly fix this issue by updating the Stored Procedure. All you have to do is...


  • Go to Admin -> Database -> Run SQL Query
  • Enter the following content:


IF  exists (select top 1 1 from sys.objects WHERE object_id = OBJECT_ID(N'[{databaseOwner}].[{objectQualifier}message_gettextbyids]') AND type in (N'P', N'PC'))
DROP PROCEDURE [{databaseOwner}].[{objectQualifier}message_gettextbyids]
GO

IF  exists (select top 1 1 from sys.objects WHERE object_id = OBJECT_ID(N'[{databaseOwner}].[{objectQualifier}message_GetTextByIds]') AND type in (N'P', N'PC'))
DROP PROCEDURE [{databaseOwner}].[{objectQualifier}message_GetTextByIds]
GO

CREATE PROCEDURE [{databaseOwner}].[{objectQualifier}message_GetTextByIds] (@MessageIDs varchar(max))
AS 
    BEGIN
    -- vzrus says: the server version > 2000 ntext works too slowly with substring in the 2005 
    DECLARE @ParsedMessageIDs TABLE
          (
                MessageID int
          )
      
    DECLARE @MessageID varchar(11), @Pos INT      
 
    SET @Pos = CHARINDEX(',', @MessageIDs, 1)

    -- check here if the value is not empty
    IF REPLACE(@MessageIDs, ',', '') <> ''
    BEGIN
        WHILE @Pos > 0
        BEGIN
            SET @MessageID = LTRIM(RTRIM(LEFT(@MessageIDs, @Pos - 1)))
            IF @MessageID <> ''
            BEGIN
                  INSERT INTO @ParsedMessageIDs (MessageID) VALUES (CAST(@MessageID AS int)) --Use Appropriate conversion
            END
            SET @MessageIDs = RIGHT(@MessageIDs, LEN(@MessageIDs) - @Pos)
            SET @Pos = CHARINDEX(',', @MessageIDs, 1)
        END
        -- to be sure that last value is inserted
        IF (LEN(@MessageIDs) > 0)
               INSERT INTO @ParsedMessageIDs (MessageID) VALUES (CAST(@MessageIDs AS int)) 
        END 
 
        SELECT a.MessageID, d.Message
            FROM @ParsedMessageIDs a
            INNER JOIN [{databaseOwner}].[{objectQualifier}Message] d ON (d.MessageID = a.MessageID)
    END


  • And click on Run Query

UserPostedImage
lordmage
  •  lordmage
  • 62.6% (Friendly)
  • YAF Camper Topic Starter
2014-04-23T12:15:01Z
My version 2.1.0 Does it solved my problem if I did that?
Waiting Selim's Place Forum members Everyone I'm glad you are.
http://seliminyeri.net/forum.aspx 
tha_watcha
2014-04-23T12:29:22Z
Originally Posted by: lordmage 

My version 2.1.0 Does it solved my problem if I did that?



Yes, if you follow the steps above the search function will start working with your version.

UserPostedImage
lordmage
  •  lordmage
  • 62.6% (Friendly)
  • YAF Camper Topic Starter
2014-04-23T12:37:20Z
tamam teşekkür ederim.Thank you.
Waiting Selim's Place Forum members Everyone I'm glad you are.
http://seliminyeri.net/forum.aspx 
micki
  •  micki
  • 50.6% (Neutral)
  • YAF Forumling
2014-04-23T18:45:10Z
Originally Posted by: lordmage 

How solvent is giving sql search button issue does not search my site in google and yandex search is doing thanks in advance.

Selim's Place Management



Turkish :

Arama butonu sql sorunu veriyor nasıl çözücem sitemin içinde arama yapmıyor google ve yandex'te arama yapıyor teşekkürler şimdiden.

Selim'in Yeri Yönetim



Testing

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved