Print Page | Close Window

Search Function don't Work

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27220
Printed Date: 29 March 2026 at 3:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Search Function don't Work
Posted By: andry79fi
Subject: Search Function don't Work
Date Posted: 06 April 2009 at 10:13am
Hello
in my Forum the SEARCH function don't work.
It search only some word. Other word (i take it from some post) don't appear on Search.
What can i do to solve this problem?
 
I Used WebWiz Forum 8.02 + Access Database.
Now i've Update ALL to Last Release + Access Database. LOL
I've try to compact database.....nothing.
 
Someone has suggest me to analize the page encoding (eg iso-8859-1 to UF-F8), but i've no option in includes/setup_options_inc.asp. Cry
 
Any Suggestion?
 



Replies:
Posted By: WebWiz-Bruce
Date Posted: 06 April 2009 at 11:05am
You want to change the page encoding found towards the bottom of the includes/setup_options_inc.asp.

I thing you also mean UTF-8 not UF-F8.

Once you change the page encoding to one that works then only new posts will be searchable. Also you may have coursed encoding issues moving from Access to SQL Server.

You should also check you are not using a case sensitive collation on the SQL Server and that the collation you are using supports the character set you are using.

If the Access to SQL Server migration has made your tblThread -> Message data type to nvarchar you may want to change this to text to see if that helps.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: andry79fi
Date Posted: 06 April 2009 at 11:38am
I've not SqlServer in my Structure.
 
But...i think this is a great BUG of this Software.
On the server....i never change nothing from intallation to...now!
Why some message are been stored with different encoding ?
 


Posted By: WebWiz-Bruce
Date Posted: 06 April 2009 at 1:22pm
This is NOT a bug in the software.

As I have told you in previous posts you have made this is a setup issue. You have changed the encoding of your forum.

Change the encoding and it will break the search and the text will be stored in a different format.

The only way the search will work is if you keep the same eocding throughout and this includes the forum frontend and the database.

I have already given you many hints on how to fix this and I can't keep going over the same thing again, and again!


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: sandy
Date Posted: 06 April 2009 at 5:04pm

I have same problem, if I change encoding to UTF-8, it will searchable. but how can I change 3000 message records of encoding  to UTF-8 at one time??? should I just copy each of them to the txt file ,change to UTF-8 then past to Message field. that will take a long time to process. right?

thank you  


Posted By: 123Simples
Date Posted: 06 April 2009 at 5:08pm
Can these people who are reporting such issues provide their forum addresses? It does help others who may be able to help, to track down any potential problems?

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design


Posted By: sandy
Date Posted: 06 April 2009 at 5:26pm
I've installed on my local machine for the test. just want to know if I have 3000 records of messages , how can I convert encoding to UTF-8 at one time? if I don't convert to UTF-8 , then the system won't let me search, but only new post.
thank you,
 


Posted By: WebWiz-Bruce
Date Posted: 06 April 2009 at 5:57pm
You can't covert them, without going through every single message end editing it and saving it back to the database.

What you need to do is keep the same encoding as you had previously with version 8 then both old and new posts will remain searchable.

If you go changing the encoding then you get problems like you have.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: sandy
Date Posted: 06 April 2009 at 7:12pm

do you have the way that serch function for the different encoding? this seems a problem for the people that have different encoding.



Posted By: sandy
Date Posted: 06 April 2009 at 8:58pm
can somebody answer this question?


Posted By: WebWiz-Bruce
Date Posted: 07 April 2009 at 9:09am
Your question has already been answered!!

The search works with all encodings, as I mentioned previously what breaks the search from working is if you change the encoding.

I will try and explain it as plainly as possible your issue so that you might get the idea, please read carefully so I don't have to explain it again:-

When you create a post it is saved in the database using the encoding set at the time, if you search the post the same encoding is used to encode the search words and so a match can be found.

If you change the encoding then any new posts will be encoded with the new encoding, if you do a search it will use the new encoding which will be able to match search results of new posts saved in the same encoding. However, old posts saved under the old encoding will be saved in a different format so the search will not be able to match them.

I will close this topic now as can't really keep explaining the same thing over and over as I feel like I am hitting my head against a brick wall here.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net