Search box not working

[mfusion]

Hi,

We're running LS 4.0 here, and I must admit, I have been tweaking it a bit to fit the company. I've only changed things on the custom computer page, commenting out lines that we do not use to register our computers at our company, to avoid the clutter. I have also renamed some of the custom fields, to things that make more sense when you're building a query (e.g. I renamed Custom1 to Vendor, because we register from which vendor we bought the machine), I have changed these on the extrainfo.aspx page, the update.aspx and in the MS SQL database. these modifications work without a hitch, but somehow, after making these adjustments, the search bar won't auto-complete anymore, and it always brings up 0 items found when I search for a name or computer I'm sure is in the database.

My first question is, will updating to version 4.0.27 resolve this? and If I do update, will it overwrite the adjustments I made in the database and the web interface on the custom page?

if it wont, do you have any ideas on how to fix the problem with the search bar?

thank you and regards

[Facilities]

Ok so after some fantasic support from the team they discovered what the issue was.

We manually changed the data type of the CustomX Column in the CompCustom table from the default nvarchar(255) to something else.
Changing it back to the default fixed the issue.

Man those support guys are good, great service!

[Facilities]

Hi

I have the same issue, I have just upgraded to the latest version from version 4.0 and now the search bar doesn't return any results.

I have looked in the SQL scripts folder and cannot find the files that you refer to, all I have is:

Volume in drive C has no label.
Volume Serial Number is 1C7E-784C

Directory of C:\Program Files\lansweeper\SQL script

2011/05/24 06:55 AM <DIR> .
2011/05/24 06:55 AM <DIR> ..
2009/04/27 08:20 PM buildobjects.sql
2009/09/07 05:51 PM createdatabase.sql
2010/01/29 01:30 PM createdatabase2000.sql
2011/04/05 09:21 AM populatedata.sql
2011/02/15 12:22 PM procedures.sql
2011/02/08 03:17 PM tables.sql
2010/04/19 10:15 AM upgradebeta.sql
2010/09/23 01:21 PM upgradescript1.sql
2011/01/25 10:05 AM upgradescript10.sql
2011/02/14 04:07 PM upgradescript11.sql
2011/02/15 12:19 PM upgradescript12.sql
2011/04/05 09:33 AM upgradescript13.sql
2010/04/19 10:16 AM upgradescript2.sql
2010/04/28 03:35 PM upgradescript3.sql
2010/05/27 11:24 AM upgradescript4.sql
2010/08/12 11:35 AM upgradescript5.sql
2010/11/02 02:04 PM upgradescript6.sql
2011/01/31 04:11 PM upgradescript7.sql
2011/01/18 04:38 PM upgradescript8.sql
2011/01/18 08:38 PM upgradescript9.sql
2011/04/05 09:32 AM views.sql
21 File(s) 10ÿ238ÿ662 bytes
2 Dir(s) 82ÿ829ÿ459ÿ456 bytes free

Please advise as to how I can get this working?

[mfusion]

I had renamed "Barcode" to "Owner" in the compcustom table, which both stored procedures refer to. Changing them in the stored procedures fixed the problem. Thank you very much!

[Hemoco]

mfusion wrote:
I had renamed "Barcode" to "Owner" in the compcustom table, which both stored procedures refer to. Changing them in the stored procedures fixed the problem. Thank you very much!

Don't rename these fields, use one of the custom fields instead.

[mfusion]

Okay, I've upgraded to 4.0.27. I've upgraded all 3 aspects of the program, and the web interface indeed changed back to what it was. The search bar, unfortunately, still doesn't work.

I'm taking a look at the it-quicksearch.aspx file. I assume this is the file the searchbar uses to search? in there I see: CommandText="dbo.web40fullsearch", which is non-existent in our database. Might it have something to do with that?

[Hemoco]

mfusion wrote:
CommandText="dbo.web40fullsearch", which is non-existent in our database. Might it have something to do with that?

The stored procedures used are web40fullsearch and web40quicksearch.
You can find their definition in the SQL scripts folder in your lansweeper installation folder.

[Hemoco]

mfusion wrote:

My first question is, will updating to version 4.0.27 resolve this? and If I do update, will it overwrite the adjustments I made in the database and the web interface on the custom page?

Upgrading will overwrite your custom changes.
I have no idea if it will solve your problem, because I don't know all that has been changed.