InstantASP Community Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        


Instant KB Search Expand / Collapse
Author
Message
Posted 30/01/2007 04:38:37
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 31/01/2007 00:18:45
Posts: 1, Visits: 2
Hi guys,

We bought InstantKB 1.3 and we've been running it on a client site since 2004. The search functionality has been working fine... until now... when searching we get the following error "Cannot sort a row of size 8200, which is greater than the allowable maximum of 8094"

Are there any selected columns that can be removed from the ikb_Search stored procedure (to make the rows smaller)
OR can some of the columns be truncated
OR should we start using the Full Text Search
OR ????

Thanks.
Post #12310
Posted 30/01/2007 12:30:10


Support Supremo

Support SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport Supremo

Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568, Visits: 2,507
DotSlash (1/30/2007)
Hi guys,

We bought InstantKB 1.3 and we've been running it on a client site since 2004. The search functionality has been working fine... until now... when searching we get the following error "Cannot sort a row of size 8200, which is greater than the allowable maximum of 8094"

Are there any selected columns that can be removed from the ikb_Search stored procedure (to make the rows smaller)
OR can some of the columns be truncated
OR should we start using the Full Text Search
OR ????

Thanks.

Hi DotSlash,

I would suggest you to truncate the contents of one or more of the columns in the row that exceeds 8000 bytes for now.  The good news is that probably next week InstantKB 2.0 Beta will be released, which will correct this issue.

 

Post #12314
« Prev Topic | Next Topic »

Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ryan Healey, Mark Christianson, James Trott

Permissions Expand / Collapse

All times are GMT, Time now is 1:44pm

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.031. 11 queries. Compression Disabled.
Home | Products | Purchase | Support | Company | Contact Us
Privacy Statement | © 1999-2007 InstantASP Limited. All Rights Reserved.