-
SQL could not be executed
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!
-
2 Replies
-
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.aspxIf 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
community.avid.com
is deleting _SearchDB_ just a regular thing? - Avid Community
Go where the pros know Avid. A community of creative professionals is waiting to assist you on our Forums. While you're here, brush up your skills with Tips and Tutorials or read up about the latest industry trends in Community … Continue reading
-
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!
Reply to this Discussion! Login or Sign Up