YAFLogo

dillegummin
13 years ago
Is there any issues with upgrading from version 1.9.1.2 (NET v2.0) - 27.09.2007 to v1.9.3 FINAL?

I have a forum running version 1.9.1.2 and wonder if I should install the latest version. The forum is used daily and my time is limited. Is there an isntaller that will do everything for me, or will it be a lot of hassle doing the upgrade?

Dille...

Sponsor

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
13 years ago
Depends on your skill level and how big a forum it is... The latest version will be simpler in regard to upgrades.
dillegummin
13 years ago
Jaben wrote:

Depends on your skill level and how big a forum it is... The latest version will be simpler in regard to upgrades.

Cheers Jaben,

So if I get the bin files I can run the install routine and it should be ok? Apart from some changes to the web.config I mean. I am just running the stock BIN version without any modifications or intergration.

dillegummin
13 years ago
I still get a

"There has been a serious error loading the forum. No further information is available.

Please contact the administrator if this message persists."

When I try to run through the install.

In the event log I see:

"Exception information:

Exception type: ConfigurationErrorsException

Exception message: An error occurred loading a configuration file: Access to the path 'C:\Sites\forum\db.config' is denied. (C:\Sites\forum\db.config)"

I read this as the app do not have access to the db.config file?!?

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
13 years ago
Bad permissions... YAF doesn't have write or READ access to your db.config file -- it needs read access.
dillegummin
13 years ago
Jaben wrote:

Bad permissions... YAF doesn't have write or READ access to your db.config file -- it needs read access.

Yeah, I had to add it manually to that file. Weird.

It actually worked like a charm then. Nice with the new version. The only issues I have left now is;

1) The front page takes forever to respond. Every sub page is lightning fast, but the first page takes forever. "This page was generated in 26.385 seconds." You can see the forum here . (Might be much slower for me seeing all the hidden sections though). Other pages are about half a second.

2) This is more of an older issue I always had since the very beginning when we started to use YAF. I can´t delete certain forum categories for some reason. Certain sections gives me a timeout error. I see some "System.Data.SqlClient.SqlException: Timeout expired" in my log.

Are these known issues and something I can fix somehow?

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
13 years ago
Go into Admin->Host Settings->Display

Turn OFF the moderator column... see if that helps.

dillegummin
13 years ago
Jaben wrote:

Go into Admin->Host Settings->Display

Turn OFF the moderator column... see if that helps.

Cheers for your help Jaben! :-d

I already had turned it off. Seems to be something slowing everything down giving SQL timeouts... hmm.

dillegummin
13 years ago
The slow response seems to be related to sub-forums.

I have tried with a user that I revoked permissions to some sections containing many sub-forums, and then it is faster.

Is there a lot of recursive parsing going on now compared to earlier? I see that sub-forums now are visible on the first page, but it shouldn't take that much juice to render those right?

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
13 years ago
dillegummin wrote:

The slow response seems to be related to sub-forums.

I have tried with a user that I revoked permissions to some sections containing many sub-forums, and then it is faster.

Is there a lot of recursive parsing going on now compared to earlier? I see that sub-forums now are visible on the first page, but it shouldn't take that much juice to render those right?

The code is a little slower then I would like... but I haven't had time to try and optimize it. Recursion is rather slow.

dillegummin
13 years ago
Jaben wrote:

The code is a little slower then I would like... but I haven't had time to try and optimize it. Recursion is rather slow.

Ok, I will have to change the structure a bit then I guess. :)

I like the new version a lot though. Nice work!

PS: Any suggestion about certain older sections of the forum that cannot be deleted? I just get a time out. While other forum sections can be deleted without problem withing the same cetegory. So they are all the same age (posts, and when they were created), but some just can't be deleted. I have been running YAF since 2005 though, so the database is old and have been through many YAF updates. Read: This problem was there long before 1.9.3.

Mek
  • Mek
  • 100% (Exalted)
  • YAF Developer
13 years ago
The delete suffers from the same problem of recursion (I have the same prob on my forum) especially with subforums and alot of posts. It could be replaced with Delete statements with joins in them as oppose to recursively delete them.

But I haven't looked at doing yet as we are moving away from the SPROCS to LINQ at some point in the near future.


UserPostedImage

"It's a case of RTFM.. the only problem being we don't have a manual!"

When I post FP:Mek in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Ederon 🙂 )

dillegummin
13 years ago
Mek wrote:

The delete suffers from the same problem of recursion (I have the same prob on my forum) especially with subforums and alot of posts. It could be replaced with Delete statements with joins in them as oppose to recursively delete them.

But I haven't looked at doing yet as we are moving away from the SPROCS to LINQ at some point in the near future.

Thanks Mek.

I actually did some more testing at it seems that if there is any Polls in topics you can't delete those topics or forum sections.