When I look at My Topics -> Favorite Topics, I cannot see any marked topics.

Tried all the "since then" options in the dropdown, but nothing showed.

So I changed to the "Show All" option, and then it crashes. See attached screendump.

Have tried to mark some more topics as Favorites, but to no avail. Still crashes with "Show All" and I can't get out of it since I can't change the dropdown box due to the crash...

---

The fix was included in 1.9.4 RC1 as was posted after it was tagged. Everyone can simply modify the sql script.
http://yafnet.codeplex.c...2fmssql%2fprocedures.sql 

---

Should I run the whole script procedures.sql to fix it?

What should the "ObjectQualifier" be? The yaf_ prefix?

Of course everyone can, if they know how... 😁


So in short - How?

---

Took the bull by the horn and ran the script on my test server, produced a lot of errors but fixed the crash indeed.

Ran it on the production site too, and all seems well - so far....

Edit: Crashes everywhere now... Not good at all😱

---

Ooops...did not work well at all... All normal topics crashing due to missing sp's....

But fixed it by copying the updated procedures.sql to the live /install/mssql and ran a new install... Then it all worked....
Still cold-sweating after the operation, but now relieved... Pheeeww....


So the proper support tip would be:

1 - Download the package from the link given

2 - Copy the updated procedures.sql to the /install/mssql folder on your site.

3 - Go to http://yoursite/forum/install and run a new install/upgrade.

Much easier than just pointing to the updated source and say "everyone" can do it if they know how to modify the script... 😉
No need to modify the script manually using the method described... Makes life a lot easier... 😄

---