Just applied SP1 to a new CS2008 installation. It appears to be causing an error with the site. (Assumption based on site working, apply service pack, site no longer (completely) working).
Summary of error message: Must declare the scalar variable "@localRowsToReturn
Tracked down this var to two sprocs both of which modified by SQL Script that came with Service Pack.
Sprocs are : cs_Media_Posts_Get, cs_shared_Threads_GetThreadSet
Offending line in each sproc is : exec sp_executesql @sqlPopulate, N'@localRowsToReturn int', @localRowsToReturn = @RowsToReturn
Hope that helps with a fix/solution/suggestion
Regards
Anthony
Did you run the SQL Script which updates the database to for CS 2008 SP1.
There area quite a few minor bugs in this service pack, so I wouldn't expect this to be one. Strange tho, I don't get this error on my site.
Nick - nb development
Anthony,
That was an issue in Community Server 2008, but was address in SP1. If you have updated your sql files as Nick suggested that issue should be corrected.
Thanks,David L. Penton
David, Nick
Thanks for replying.
I did run the SQL - those lines aren't in the shipped versions of those sprocs...are they. I thought they were introduced with SP1.
Anyway, beside the point really and your general inference is correct, the error lies elsewhere and is merely 'bubbling up' in these routines.
We are utilising some third party plug-ins which were not updated by us after applying the Service Pack. Now they have been our testing appears to show the errors have gone.
Good stuff !
Thanks again.
Ant
OK, good to hear the issues have gone
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com