| Author |
 Topic Search  Topic Options
|
andry79fi 
Newbie
Joined: 02 April 2009
Status: Offline
Points: 7
|
 Topic: Search Function don't Work
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.  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. 
Any Suggestion?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
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.
|
|
|
|
andry79fi
Newbie
Joined: 02 April 2009
Status: Offline
Points: 7
|
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 ?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
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!
|
|
|
|
sandy
Newbie
Joined: 06 April 2009
Status: Offline
Points: 4
|
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
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
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?
|
|
|
|
sandy
Newbie
Joined: 06 April 2009
Status: Offline
Points: 4
|
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,
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
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.
|
|
|
|
Search Function don't Work