Catlog crash

[mago]

Hello: after the last update PM + failed in the catalog scan, and today I wanted to reindex and it gives me an error. Please, how can I resolve this bug?
Thanks

PN Idon't no upload image, but in the message it says something like:

"query_command_stream failed CILA::PROTO::RPCException
query_command_stream failed SQLite3:::SQLExcetion:table search has no column named colorval_sort"

[Kirk Baker]

Hello: after the last update PM + failed in the catalog scan, and today I wanted to reindex and it gives me an error. Please, how can I resolve this bug?
Thanks

PN Idon't no upload image, but in the message it says something like:

"query_command_stream failed CILA::PROTO::RPCException
query_command_stream failed SQLite3:::SQLExcetion:table search has no column named colorval_sort"

Perform the "Update Catalog Version" first.  Then you should be able to "Re-index Catalog".

-Kirk

[mago]

Thank you very much for your reply. I already started yesterday after this message and it has not finished yet (there are a few minutes left, there are 150K images), a few minutes left, then Re-index.
I understand that a catalog update is required after an update or it was an isolated episode that occurred in my catalog. Thanks again Kirk

[mago]

Synchronization has finished and it gives me an error in the Re-indexing again.
In the status catalog it says:

[Sat 11:38:02] Error: RPCServerConn.rpc_dispatch: exception: CILA::PROTO::RPCException/query_command_stream failed: ["SQLite3::SQLException: table search has no column named colorval_sort"] to=22 msg="query_command_stream" location=C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/proto/rpc.rb:729:in `block in msgstream', ./archive/common/catalog.rb:274:in `call', ./archive/common/catalog.rb:274:in `read_and_forward_stream', ./archive/common/catalog.rb:154:in `query_command_stream', C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/proto/rpc_object.rb:69:in `block in initialize', C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/proto/rpc.rb:1114:in `call', C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/proto/rpc.rb:1114:in `block in do_rpc_dispatch', C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/proto/rpc.rb:1113:in `catch', C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/proto/rpc.rb:1113:in `do_rpc_dispatch', C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/proto/rpc.rb:1062:in `block in rpc_dispatch', C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/fiberpool.rb:60:in `call', C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/fiberpool.rb:60:in `block in add_fiber'
[Sat 11:38:02] Error: CatalogManager.maintenance__run_in_fiber: query_command_stream failed: ["query_command_stream: CILA::PROTO::RPCException/query_command_stream failed: [\"SQLite3::SQLException: table search has no column named colorval_sort\"]"] - ["C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/proto/rpc.rb:729:in `block in msgstream'", "./archive/common/catalog_manager.rb:2170:in `call'", "./archive/common/catalog_manager.rb:2170:in `block in maintenance__run_in_fiber'", "C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/fiberpool.rb:60:in `call'", "C:/Program Files/Camera Bits/Photo Mechanic Plus/pmruby/lib/ruby/site_ruby/2.2.0/cila/fiberpool.rb:60:in `block in add_fiber'"]

[mago]

Hi Kirk:

It is already solved, reindexed in progress. Thanks again

[Kirk Baker]

Thank you very much for your reply. I already started yesterday after this message and it has not finished yet (there are a few minutes left, there are 150K images), a few minutes left, then Re-index.
I understand that a catalog update is required after an update or it was an isolated episode that occurred in my catalog. Thanks again Kirk

Actually, it was my fault.  When I made the catalog update, it wasn't marked as required and this allows users to do other maintenance operations prior to doing the catalog update, which in turn causes the problems that you and another user experienced.

The next build of Photo Mechanic Plus will correct that problem.

-Kirk