Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

Search Issues
Last Post 01/25/2008 4:42 PM by Peter Donker. 5 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Don Schaening
New Member
New Member
Posts:5


--
01/23/2008 5:02 PM

    I followed instructions in the past as it relates to integrating DMX with the DNN search and it has been working fine, until now.

    now on the results page I get this error...

    An error occurred in the following search:
    SELECT e.*, ext.Icon16, (SELECT Description FROM {objectQualifier}DMX_Entries AS p WHERE p.EntryId = {objectQualifier}DMX_Entries.CollectionId) AS CollectionName, 1 AS Rank FROM {objectQualifier}DMX_Entries e INNER JOIN {objectQualifier}DMX_Extensions ext ON e.EntryType = ext.ExtensionKey WHERE ((e.PortalId = 0) AND (ext.PortalId = 0) AND (e.EntryId = e.LastVersionId)) AND ((e.Description LIKE '%fha%'))
    Error: The column prefix 'DMX_Entries' does not match with a table name or alias name used in the query.
    <script src="http://bring2mind.net/DesktopModules/Bring2mind/DMX/DataGridSelection.js" type="text/javascript"></script>
    <!-- End_Module_577 -->

    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4495


    --
    01/23/2008 10:05 PM
    Hi Don,
    The error message should enable you to go into SQL server and run the query yourself to see what's up. Have you tried that yet? Replace the {objectQualifier} with the correct value and you should see something.
    Peter
    Aaron
    New Member
    New Member
    Posts:7


    --
    01/24/2008 6:48 PM

    I recently patched my DMX 3.0 module and am experiencing the same problem (search failure).  I checked the version 3 'demo' module you have for DMX 3.0 (here at bring2mind) and found that the error is occurring here as well.   This was not an issue prior to performing the patch upgrade.  

    Aaron
    New Member
    New Member
    Posts:7


    --
    01/24/2008 9:22 PM

    As you suggested, I tested out the SQL Statement replacing {objectqualifier} with dbo and determined the problem to be at the following point highlighted in black:

    An error occurred in the following search:
    SELECT e.*, ext.Icon16, (SELECT Description FROM {objectQualifier}DMX_Entries AS p WHERE p.EntryId = {objectQualifier}DMX_Entries.CollectionId) AS CollectionName, 1 AS Rank FROM {objectQualifier}DMX_Entries e INNER JOIN {objectQualifier}DMX_Extensions ext ON e.EntryType = ext.ExtensionKey WHERE ((e.PortalId = 0) AND (ext.PortalId = 0) AND (e.EntryId = e.LastVersionId)) AND ((e.Description LIKE '%fha%'))

    If you change the highlighted portion to "p.CollectionId" the statement will not error. 

    Incidently, the error code you get in SQL Server is the following:

    "Msg 4104, Level 16, State 1, Line 1

    The multi-part identifier "dbo.DMX_Entries.CollectionId" could not be bound." 

    This seems to point at the qualifier as being the culprit.

    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4495


    --
    01/25/2008 4:06 PM
    Yes, you're right. But it should be e.CollectionId ;-)
    Thanks,
    Peter
    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4495


    --
    01/25/2008 4:42 PM
    I just posted 03.05.05 which should take care of this.
    Peter
    You are not authorized to post a reply.