|
Hermes
Junior Member
Croatia
113 Posts |
 Posted - 14 April 2007 : 19:13:49
|
I have installed Archive One Topic Mod 1.0a
After archiving first topic I get this error:
error '80020009'
Exception occurred.
/forum/admin_topics.asp, line 1519
Line 1519 goes like this:
rs.Open strSql, my_Conn
Response.Write "Total Topics: " & RS("SumOfF_TOPICS") & "<br />" & vbNewline
strSumOfF_TOPICS = rs("SumOfF_TOPICS")
rs.Close
The topic did not been archived. He just disappear.
After search for problem I find this thread:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61115&SearchTerms=archive,topic,Exception,occurred,
According to given advice I first change all mentioned Integer field types in that tables to Double, and run "Update Forum Counts", and it works.
With same logic I changed Archive One Topic fields in MySql and everything worked.
The archived topic appeared, and I thought that it was lost for good.
So if you run on this problem on MySql 5.0 do the following:
In UA_TOPICS table change
UA_TOPIC_ID
TOPIC_ID
type (who was by default int(11) in my table) to double, remove 11 in Length/Values.
Everything should work.
Problem solved.
Best regards Hermes
|
ASP Snitz Forum Upute za instalaciju
http://www.kairos.com.hr http://www.hermetizam.com Forum
not so newbie any more :) |
|
Topic Locked
