| Author |
 Topic  |
|
ramongece
Starting Member
Bhutan
40 Posts |
 Posted - 14 January 2006 : 13:54:53
|
I have a problem with admin_count.asp file.
I changed my access bd to mysql few time ago.
I click at Update Forum Counts in admin section, and Updating Counts Step 5 of 5, answer this error:
Totals: error '80020009'
/foros/admin_count.asp, line 498
Also desappeared archive topics from my forum, and Topics and Post numeric results changed to '0'.
I donīt understand what happened?.
Please help me to comeback to before situation.
Archive topics show again and topics and posts numerics views show again too.
|
Edited by - ramongece on 14 January 2006 15:15:16 |
|
|
ramongece
Starting Member
Bhutan
40 Posts |
Posted - 14 January 2006 : 16:01:19
|
This line set:
if rs("SumOfF_TOPICS") <> "" then
Response.Write "Total Topics: " & rs("SumOfF_TOPICS") & "<br />" & vbNewline
intSumOfF_TOPICS = rs("SumOfF_TOPICS")
|
Edited by - ramongece on 14 January 2006 16:01:37 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 January 2006 : 16:02:25
|
| Access to MySQL conversion is a situation that needs to be dealt with some care. It is quite likely that your problems result from the way the conversion was done. Do you still have the Access Db? I would advise you to follow the recommendations available at this forum on that subject. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ramongece
Starting Member
Bhutan
40 Posts |
Posted - 14 January 2006 : 16:48:40
|
quote:
Originally posted by ruirib
Access to MySQL conversion is a situation that needs to be dealt with some care. It is quite likely that your problems result from the way the conversion was done. Do you still have the Access Db? I would advise you to follow the recommendations available at this forum on that subject.
Sorry, my forum runs correctly, but only I have this mistake in updating counts.
Can you help me?
I think error is in null parameters fixed in mysql traslation. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ramongece
Starting Member
Bhutan
40 Posts |
Posted - 14 January 2006 : 17:54:46
|
Only answer:
Updating Counts Step 5 of 5
Totals: error '80020009'
/foros/admin_count.asp, line 498
Thank you for all.
I donīt understant why donīt show archive topics in default page, now.
You know how show archive topics in default page? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ramongece
Starting Member
Bhutan
40 Posts |
Posted - 14 January 2006 : 18:29:06
|
No
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 January 2006 : 18:45:31
|
| I guess that is the problem, in this case. Those counts should be updated in the previous update counts steps, but something must be wrong with the DB. Hard to say what without looking. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ramongece
Starting Member
Bhutan
40 Posts |
Posted - 15 January 2006 : 03:03:21
|
Ok.
Maybe somebody knows a same problem.
Iīm waiting some help. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 January 2006 : 05:13:57
|
Ramon,
I don't remember reading about something like this, but it is possible that someone faced something similar. I have upgraded several Access forums to MySQL and never experienced this. If there is no such experience, only a look at the DB will allow someone to understand what is happening. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ramongece
Starting Member
Bhutan
40 Posts |
Posted - 15 January 2006 : 11:21:57
|
| Ok. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 15 January 2006 : 17:33:00
|
Take a look at the counter fields, if any of the count fields are null try setting them to 0 manually. I had a similar problem long ago with a bad migration to sql server that caused missing default values for the counter fields.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ramongece
Starting Member
Bhutan
40 Posts |
Posted - 16 January 2006 : 10:08:01
|
quote:
Originally posted by Doug G
Take a look at the counter fields, if any of the count fields are null try setting them to 0 manually. I had a similar problem long ago with a bad migration to sql server that caused missing default values for the counter fields.
Where is the counter field are you telling?, please.
In my MySQL server or in admin_count.asp file.
If in my SQL server, can you tell me in what DB table? _forum, _topics, _totals.
Thank you. |
Edited by - ramongece on 16 January 2006 10:10:33 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 January 2006 : 17:19:19
|
| Look in the FORUM_TOTALS table. |
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ramongece
Starting Member
Bhutan
40 Posts |
Posted - 16 January 2006 : 19:56:52
|
Iīve seen in FORUM_TOTALS table and all fields are zero.
Please, another idea. |
|
|
|
Topic |
|
Topic Locked
