How to not show one result if another is not empty

Submitted by marcv on Sun, 2009-05-03 04:52.Troubleshooting

What is the syntax to not show one result if the other one has a value in it (is not empty).
In our display template there are cases there the subject appears twice. This is because the original thread title and reply title are the same. Since we do not search reply titles that is just for display purposes. So if there is a hit on the thread title it shows both the real title and the title again as the "subject_for_display" only value too.
Here is the line:
So what I need is an if statement where if the "subject" has a value in it and is not null/empty/blank then we do NOT show the "subject_for_display" part.
I'm knowledgeable in asp, php syntax but not this one (yet) and I don't have this setup on dev server as it is live so can't experiment hit or miss so if you can let me know if this can be done in template and how that would be perfect. thank you.

Locked up and never completed incremental

Submitted by marcv on Sat, 2009-05-02 18:28.Troubleshooting

Today we ran an incremental and it got most of the way through up to the updatetempindex part and then hung there for 7 hours. There was nothing that would stop the hang from the browser. Tried to stop indexing and do all the other functions but nothing worked.

Then tried restarting process. when it started back up it hung again even though it did serve requests correctly excluding any new content.

Tried rebooting and same thing. I am not deleting the entire 6GB plus index and will see if it will start from beginning.

We are in live beta now with our members and rebuild will take about 5 hours. I just want to know what to do in the future if this happens again and why it would happen. Is there something we can do to avoid it?

Fixed: FreeMarker template error! ... please help

Submitted by hanumant on Sat, 2009-04-25 07:53.Troubleshooting

Hi All,

I have installed DBSight and done all the required setup. I am able to index my database. But I am getting error while using search functionality. Its because of some template parsing issue.
Have anyone faced such issue before. Please help me to solve this issue.
Following is the stacktrace.

Error parsing included template templates/iknow/iKnow/documents.ftl
Unexpected end of file reached.
Unclosed foreach directive.

The problematic instruction:
==> include "documents.ftl" [on line 20, column 23 in templates/iknow/iKnow/main.ftl]
in user-directive layout [on line 5, column 1 in templates/iknow/iKnow/main.ftl]

narrowby feature problem

Submitted by garyp on Sat, 2009-04-11 11:36.Troubleshooting

I am using v2.1.0(build 354).
my main sql has 'select ID, Category, SiteName, Description from links4'. ID and Category are type keyword.
my configure search has booleanOperator = or, filterable cols as
Column Type Display Name Filter
ID Number(KeyWd) ID No
Category Number(KeyWd) Category Yes
All other values on this page are default.
So, then I search: and get "Results 1 - 30 of 87 for portrait" plus link for "NarrowBy Category +254(63)"

Spell Check doesn't work anymore

Submitted by jons911 on Fri, 2009-03-27 12:57.Troubleshooting

Hi, I have upgraded to 2.1.1 beta build 369 and spell check has stopped working. Whenever I request "Re-build Spell Check Dictionary", the log shows this:

INFO 2009-03-27 16:50:51,164- unlock temp files if exists
INFO 2009-03-27 16:50:51,164- unlocking temp direcotory:D:\Program Files\DBSight\webapps\dbsight\WEB-INF\data\indexes\CompanyLocation\_temp
INFO 2009-03-27 16:50:51,186- ~~~~~~~ companylocation@default:reBuildDictionary ...
INFO 2009-03-27 16:50:51,911- Opened index companylocation
INFO 2009-03-27 16:50:51,912- Building Directory For Column locationName...
INFO 2009-03-27 16:50:52,026- Processing 1 of 22176

Error when getting the index:forum_index

Submitted by marcv on Thu, 2009-03-19 21:00.Troubleshooting

We have just finished setting up dbsight for testing on our development server and indexing is completed. I can see the data is there when I go to Status Report > Index Content

When I do a search from the front page I get this error:

"Error when getting the index:forum_index "

I tried restarting the dbsight and also tried running it in the background and as a service to no avail.

Any ideas why it might be getting this "error when getting the index" message instead of returning results?

Sortable Columns when change column name or display column

Submitted by jordinini on Thu, 2009-03-19 20:10.Troubleshooting

I don't know what I'm doing wrong but I receive the follow error

Searching Error:field "sprecio" does not appear to be indexed. Has Indexing been started yet? If you manually added index, please use "Refresh Index" action in Dashboard. If Error shows Null and wildcard is used, it's because of too many matches and please consider increase the minimal prefix length

when I changed the column name in SQL subsequent query,
for example:
SELECT user AS usename FROM users WHERE id_user=?
and then I try to do search with this specified sortable column.

In Sortable column Table appears correct as 'username' , and I've configured to be displayed as 'username' in the same table, however when I try a order search by this column , it doesn work.

No results template is not displayed

Submitted by jordinini on Thu, 2009-03-19 09:39.Troubleshooting

When there is no results with one query search, no results template is not displayed

doesn't seem to work in Search Engine alike template. only returns '1'

Submitted by Peter_H on Sun, 2009-03-08 07:07.Troubleshooting

I'am trying to implant search suggestions to one of my input boxes. The DBSight server is not available to the outside world, so I had to write a wrapper for

It's basically a script which reads the post and get data and calls with that data. I have also tried without the wrapper, but had the same result.

The problem is that only returns '1', and I can't find what is causing this problem. I have rebuild the spellcheck index for the field that has to show the suggestions, and the files are on the server. Also is called with the correct parameters, these are indexName and q, both contain the correct data.

Incremental Indexing - Dangling meta character '?' near index 0

Submitted by jons911 on Wed, 2009-03-04 08:12.Troubleshooting

I'm trying to configure the advanced SQL for incremental indexing, and I keep getting this error when running the update.
Any help would be greatly appreciated.
Here's my SQL (trimmed down) :
from ... i
where ...
and i.updateDate > ?
and details from the index log:
INFO 2009-03-04 11:00:17,571- Preparing the statement...
ERROR 2009-03-04 11:00:17,597- Error During Main Query:java.util.regex.PatternSyntaxException: Dangling meta character '?' near index 0
^:Dangling meta character '?' near index 0
ERROR 2009-03-04 11:00:17,599- Detailed Error
java.util.regex.PatternSyntaxException: Dangling meta character '?' near index 0
at java.util.regex.Pattern.error(Unknown Source)
at java.util.regex.Pattern.sequence(Unknown Source)
at java.util.regex.Pattern.expr(Unknown Source)
at java.util.regex.Pattern.compile(Unknown Source)
at java.util.regex.Pattern.(Unknown Source)
at java.util.regex.Pattern.compile(Unknown Source)
at java.lang.String.split(Unknown Source)
at java.lang.String.split(Unknown Source)
at net.javacoding.xsearch.config.IncrementalDataquery.setTimestamp(DBSight:15)
at net.javacoding.xsearch.core.task.a.a.c.a(DBSight:107)
at net.javacoding.xsearch.core.task.a.a.c.execute(DBSight:140)
at net.javacoding.xsearch.core.task.a.c.execute(DBSight:45)

XML feed