| Author |
 Topic  |
|
kolucoms6
Average Member
845 Posts |
 Posted - 17 March 2008 : 09:19:39
|
Referrring to below post,
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=42436
I have tried to implement it but
Microsoft JET Database Engine error '80040e14'
The INSERT INTO statement contains the following unknown field name: 'AU_FORUM_ID'. Make sure you have typed the name correctly, and try the operation again.
/forum/inc_func_common.asp, line 121
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 17 March 2008 : 09:21:36
|
| you have not installed the MOD correctly, try re-running the database update script for the MOD |
 |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 09:26:54
|
I didnt want to post it twice, but it gave me an error saying Error while posting the URL.Plz contact Admin.
Reg Database , I dont find any changes in DB in that post. |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 09:28:03
|
How to find out whether I have
"Active Users 4 mod" or Not. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 17 March 2008 : 09:34:04
|
| if you are getting an error related to db fields that start AU_ then you have the code for active users but not the database fields, so you need to run the database script for the MOD |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 09:36:23
|
But I cant open the page to do DB update. |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 09:55:22
|
| any solutions :-( ? |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 17 March 2008 : 10:05:13
|
It because you have included the active users files in inc_header.asp put your old inc_header.asp in there and then run the script the re upload your new one. That should work for you.
Jeff |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 10:11:22
|
Below line gave me an Error.Though I didnt even touch those lines.I just added few codes as per above post i.e
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=42436
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)
|
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 10:13:56
|
Even after backing up and replacing the file inc_header.asp , it giving me the same Error. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 17 March 2008 : 10:20:00
|
link to the site?
|
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 10:22:57
|
| www.ulcindia.com/forum |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 17 March 2008 : 10:27:31
|
Sorry upload your old inc_func_common.asp file as well.
|
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 17 March 2008 : 10:32:31
|
I made a mistake..
Didnt back up my old file before updating as I tght its a small change which I have to do :-(( |
|
|
|
leesh695
Junior Member
101 Posts |
Posted - 17 March 2008 : 10:43:33
|
| 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. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 17 March 2008 : 10:44:48
|
| perhaps you should just replace ALL your files with the default snitz forum files and then reinstall the MODS that you require. |
|
|
|
Topic |
|
Topic Locked
