YAFLogo

dillegummin
15 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
15 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
15 years ago

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

Jaben wrote:

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
15 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
15 years ago
Bad permissions... YAF doesn't have write or READ access to your db.config file -- it needs read access.
dillegummin
15 years ago

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

Jaben wrote:

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
15 years ago
Go into Admin->Host Settings->Display

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

dillegummin
15 years ago

Go into Admin->Host Settings->Display

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

Jaben wrote:

Cheers for your help Jaben! :-d

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

dillegummin
15 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
15 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?

dillegummin 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.

dillegummin
15 years ago

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.

Jaben wrote:

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
15 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
15 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.

Mek wrote:

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.