Hello, having problems setting up a DB search. The select is straightforward and works, when I 'check' it, it finds all four columns. But when I run the crawler it returns 0 results (although the count is correct). Any ideas?
productBasic 1/7/14 11:31:09 AM 0:00:05 Complete 0 (0) / 470992 (0)
select id, productName, Manufacturer, brandName From myTable
Can u give us more information?A screenshot would be useful.
May i know what "Isolation level" do you use ? and what is the "SQL Update" action you use(It will be in a combo box below the Textarea for "SQL Update")?
Hello, I'm having some like that.. the connection to the database is ok, but always the status is "error" (sorry for my english).. "OpenSearchServer v1.5.1 - build 618b4feee7" screenshots
Sorry for the delay in the reply,
There is one issue in the "Field Map" tab .
The primary key field from the database should be mapped with the default field in the schema.
That way you can have unique documents.