| Author |
 Topic  |
|
kolucoms6
Average Member
845 Posts |
 Posted - 17 March 2008 : 10:47:02
|
But i am failed to under I just modified few codes in 2 -3 files for that MOD.
How it affected other lines which I didnt even touch ?
|
 |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 17 March 2008 : 11:09:34
|
You had to have touched those lines above cause those are not in the default snitz. I have a package with about 6 mods installed that I can just uploaded but you have to keep like 3-4 files of the original snitz code so I can update the database. This seems to be what is the problem with yours. You have new files or lines of code before updating the database. This is why there is a invalid argument cause those database fields don't exist.
I could be wrong on this but I am pretty sure this is what is happening. |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 11:45:10
|
I am thinking of trying
try downloading a fresh copy of the forum and placing a normal inc_func_common.asp from there until you update your database. then you can put the one you are using back in.
|
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 12:13:54
|
:-( Nope...
Didnt work... My own Stupidity !!! |
|
|
|
leesh695
Junior Member
101 Posts |
Posted - 17 March 2008 : 12:56:01
|
| You need to place a normal copy of inc_func_common.asp & inc_header.asp |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 18 March 2008 : 10:00:44
|
| How about if I directly use dbs_activeusers.asp file ? |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 March 2008 : 10:06:36
|
| no you can't run the dbs_xxxxxx file by itself, it needs to be run by admin_mod_dbsetup.asp |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 March 2008 : 10:07:42
|
| have you tried uploading an unmodified copy of inc_func_common.asp & inc_header.asp ?? if not then do so. |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 18 March 2008 : 10:12:54
|
But i already have Other MOD also Installed.
Wont that break the entire ? [ Though it is so ]
Another thing is :In Active User MOD, I dont see any 'AU_FORUM_ID' field .... |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 18 March 2008 : 10:15:52
|
Below line give me an Error :
quote:
'my_conn.execute (strSql)
else 'Is a new user, make new record
if strLoginStatus = 0 then
strSql = "INSERT INTO " & strTablePrefix & "ACTIVE_USERS (" & _
"MEMBER_ID, AU_IP, AU_LOGINTIME, AU_LASTACTIVETIME, " & _
"AU_LASTPAGE, AU_QUERYSTRING, AU_USER_AGENT, AU_FORUM_ID) VALUES(" & _
MemberID & ", " & _
"'" & Chkstring(strUserIP, "SQLString") & "', " & _
"'" & Chkstring(strCurrentTime, "SQLString") & "', " & _
"'" & Chkstring(strCurrentTime, "SQLString") & "', " & _
"'" & Chkstring(strScriptName, "SQLString") & "', " & _
"'" & Chkstring(strQueryString, "SQLString") & "', " & _
"'" & Chkstring(strUserAgent, "SQLString") & "', " & _
"'" & Chkstring(intAUForumID, "SQLString") & "')"
my_conn.execute (strSql)
end if
end if
quote:
INSERT INTO FORUM_ACTIVE_USERS (MEMBER_ID, AU_IP, AU_LOGINTIME, AU_LASTACTIVETIME, AU_LASTPAGE, AU_QUERYSTRING, AU_USER_AGENT, AU_FORUM_ID) VALUES(1, '59.165.44.15', '20080318191902', '20080318191902', 'Default.asp', ' ', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 2.0.50727; .NET CLR 1.1.4322)', ' ')
|
Edited by - kolucoms6 on 18 March 2008 10:16:51 |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 18 March 2008 : 11:01:34
|
Used a RAW method.
Delete AU_FORUM_ID from the SQL.
Now, its working fine. |
|
|
|
leesh695
Junior Member
101 Posts |
Posted - 18 March 2008 : 12:02:13
|
quote:
Originally posted by kolucoms6
But i already have Other MOD also Installed.
Wont that break the entire ? [ Though it is so ]
Another thing is :In Active User MOD, I dont see any 'AU_FORUM_ID' field ....
Just incase it happens again, copying the older files would not break the mod, it would remove the code looking for database fields that are not there.
You use the original files to update your datebase then copy the ones you moded back over. |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 18 March 2008 : 13:15:04
|
:-) Thanks.
Thats why I love this forum for guiding always in Correct direction, whatever the Topic is. |
|
|
|
Topic |
|
Topic Locked
