Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Activity Forums Avid Media Composer SQL could not be executed

  • SQL could not be executed

    Posted by Fabrizio Corday on April 5, 2024 at 3:19 pm

    Hello community.

    I have a question regarding this error:

    Search Error: SQL could not be executed. sql: SELECT DISTINCT binmob.id, mob.smpteid, mob.type, bin.name FROM columndata, mob, binmob, bin WHERE bin.type=0 AND columndata.value LIKE ‘%’ ||:binText || ‘%’ AND columndata.binmobbid=bin.id AND (binhostid IS NUL OR binhostid=1) AND binmob.userplaced!=0

     

    We’re working on a Nexis Storage workflow (MC Ultimate) and at the moment of searching for audio & sound files in the MC’s FINDER (ctrl + F), it appears to be an issue (Search Error: SQL could not be executed).

    I was thinking deleting some Search_DB files may be the solution, but as I working in a multiuser setting, this have implications for the other users? Or any idea about this error?

    I hope you can comment about this or if you have any ideas for the solution will be greatly appreciated.

     

    Best regards!

    Fabrizio Corday replied 1 month, 1 week ago 2 Members · 2 Replies
  • 2 Replies
  • Mads Nybo jørgensen

    April 6, 2024 at 12:45 pm

    Hey Fabrizio,

    What a pain in the…

    Have you done a search on the Avid support forums?
    If you do, you will find Chuck Kahn (who you replied to on the other CreativeCow thread on the same issue), has already raised that issue, and got some interesting replies as to why that is happening.

    You can read it here:
    https://community.avid.com/forums/t/198188.aspx

    If that doesn’t work, I know one of the top AVID support companies in the world, but they are based in Denmark and when it comes to storage, they prefer to be there in person.
    But maybe they might just know someone “local” to you, who would have the magic touch.
    https://in-site.tv/

    Hope that you get it fixed.

    Atb
    Mads

  • Fabrizio Corday

    April 8, 2024 at 3:33 pm

    Thank you Mads.

    The Avid forum was very informative, i‘m going to read furder about this problem.

    The main doubt is about deleting the Search_DB files in a storage situation, but i’m gonna keep reading in the forums.

    I hope to fixed soon…

    Thanks again!

We use anonymous cookies to give you the best experience we can.
Our Privacy policy | GDPR Policy