| Author |
 Topic  |
|
|
tuttostranieri
New Member
53 Posts |
 Posted - 05 October 2006 : 12:19:48
|
Hi :)
I have some problem with the function update forum counts on my upgraded installation....
I have checked the forum and i think that all is working fine but when i click on update forum counts the screen freeze on the :"Updating Counts Step 1 of 5
Topics: ................................................
"
no errors will showed olso after 20 minutes.
On the old version all is working fine, the procedure end in 5 minuts (35 mb database on my sql)
Can you help me ???
THX :) |
www.tuttostranieri.it
www.tuttostranieri.org
admin@tuttostranieri.it |
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 05 October 2006 : 14:03:07
|
| well, the admin_count.asp file was not actually updated so there is no difference in the code at all. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tuttostranieri
New Member
53 Posts |
Posted - 06 October 2006 : 19:17:42
|
yes
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=62.149.XXX.XXX;user=Sql77XXX;password=XXXXXXXX;DATABASE=Sql77XXX_Y;" '##MySQL w/ MyODBC v3.51
|
www.tuttostranieri.it
www.tuttostranieri.org
admin@tuttostranieri.it |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 06 October 2006 : 19:29:49
|
| try changing option=16387 to option=4 |
|
|
|
tuttostranieri
New Member
53 Posts |
Posted - 06 October 2006 : 19:59:52
|
now i receive:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/forum/inc_header.asp, line 502
:( |
www.tuttostranieri.it
www.tuttostranieri.org
admin@tuttostranieri.it |
Edited by - tuttostranieri on 06 October 2006 20:00:04 |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 07 October 2006 : 03:38:26
|
OK, I guess you need to set it back to option=16387 then.
could you provide us with the following information.
1) What version of MySQL is your database
2) What version of MyODBC is installed on your server
It generally helps if you provide this information when you ask for help, otherwise we are just guessing |
|
|
|
tuttostranieri
New Member
53 Posts |
Posted - 09 October 2006 : 13:02:01
|
| ok i'll get the information with my provider... |
www.tuttostranieri.it
www.tuttostranieri.org
admin@tuttostranieri.it |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 09 October 2006 : 17:50:28
|
| ok, that would be a great help thanks |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 October 2006 : 18:37:13
|
When you say "upgraded installation" all you did was upgrade your forum files to the latest version?
Do you have any mods installed?
From what Snitz Forums version did you upgrade from? |
Support Snitz Forums
|
|
|
|
cobrachen
Starting Member
48 Posts |
Posted - 31 December 2007 : 16:41:42
|
I didi some search on this forum and did not find the exact problems I have. I am moveing data to MySQL with ODBC 3.51 and forum 3.4.6.
I am moving my live data from SQL server to MySQL and so far I have Config_New, Forum, Members, two archive tables moved over. When I ran the forum count to update the number, the code will count the archive topics with correct number, but return a very high number of replies number which should be none. Then I received a type mismatch error at step 4.
So, I have correct topic number, 0. Correct archive archive topic number, correct replies number, 0 and very high archived replies number, almost as 1.5 times of the total replies and this error.
I compare the Forum_count table and find out the column order are different from the SQL Server and I did changes to make it matched. The same also happened to Forum table and changes I made with the order of columns.
I believe due to this error, The link to open the archive posts were missing and how can i correct this and have the link and counts works?
Thanks. |
Edited by - cobrachen on 31 December 2007 16:55:50 |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 01 January 2008 : 09:36:58
|
quote:
Originally posted by HuwR
could you provide us with the following information.
1) What version of MySQL is your database
2) What version of MyODBC is installed on your server
Hi, I am also having a problem running this, (and have for a couple of years), my drivers are this:
MySQL ODBC 3.51 Driver
MySQL v 4.0.26
The server operating system for the MySQL is Linux .
In my config I use the DSN option as I was never able to get a connect string to work. Is there a suggestion that I might try so that I can update my counts?
|
-=NiteOwl=-
|
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
cobrachen
Starting Member
48 Posts |
Posted - 01 January 2008 : 10:03:14
|
quote:
Originally posted by modifichicci
You can use this routine written by ruirib
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61685
It worked great and update the count correctly. Also brought back the link to archive topics.
Thank you very much. |
|
|
| |
Topic |
|
Topic Locked
