Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Updating forum counts problem		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Webbo
Average Member

United Kingdom
982 Posts
Posted - 11 April 2008 :  17:33:55  Show Profile  Visit Webbo's Homepage
When trying to update my forum counts I get part way through 'Step 2 of 5' and then lock up
Despite trying it on quiet periods (hard to find lol) it doesn't make any difference
It is a very busy forum and website, runs with MySql dbs and resides on its own Windoze2003 server which is fully updated IIS6.0

Does anyone have any ideas how to resolve this?

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 11 April 2008 :  17:36:25  Show Profile  Send ruirib a Yahoo! Message
What MySQL version are you using?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 11 April 2008 :  17:55:40  Show Profile  Visit Webbo's Homepage
4.0.26-nt
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 11 April 2008 :  18:10:26  Show Profile  Send ruirib a Yahoo! Message
You can try running this SQL script: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61685

Updates counts using SQL and I have never seen it timeout.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 11 April 2008 :  18:13:09  Show Profile  Visit Webbo's Homepage
Thanks,

I'll give it a go shortly and report back
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 11 April 2008 :  19:32:59  Show Profile  Visit Webbo's Homepage
Great stuff, it worked a treat

(Took a while to reply to you though as my Mouse batteries died - have you ever tried to find two batteries when you need them lol ?)

Thanks, code saved for future use
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 12 April 2008 :  03:10:15  Show Profile  Send ruirib a Yahoo! Message
Great .

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts
Posted - 12 April 2008 :  11:25:37  Show Profile  Send pdrg a Yahoo! Message
quote:
Originally posted by Webbo
(Took a while to reply to you though as my Mouse batteries died - have you ever tried to find two batteries when you need them lol ?)

That's why none of my remote controls work any more - I always raid them first ;-)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07