Author |
Topic  |
|
currington
Starting Member
26 Posts |
Posted - 28 July 2002 : 04:47:38
|
Private Messages Mod for Snitz Forums v3.3.03 (Updated on 22 November 2001)
New Table: FORUM_PM <----------- What does this mean?
New Fields in FORUM_MEMBERS: M_PMEMAIL <----------- What does this mean? M_PMRECEIVE <----------- What does this mean? All files included in this zip file are to be uploaded to your main forum directory.
I have done the mod update but I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_PM'. Make sure it exists and that its name is spelled correctly.
/forum/privatemess.asp, line 54
Please help! Your help with be greatfully received
Matt
Edited by - currington on 28 July 2002 04:50:33 |
|
Hamlin
Advanced Member
    
United Kingdom
2386 Posts |
Posted - 28 July 2002 : 05:33:17
|
Did you ru the dbs_setup file that came with the mod. The error you are receiving means that the table is not in the database, before change the files you should have gone to the admin options > MOD Setup > and then picked the PM mod from the drop down list.
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it. http://www.ian-hamlin.co.uk ™ |
 |
|
currington
Starting Member
26 Posts |
Posted - 28 July 2002 : 05:52:20
|
forum/admin_mod_dbsetup.asp <- the drop down box in this page? Yes I have done that.
|
 |
|
currington
Starting Member
26 Posts |
Posted - 28 July 2002 : 05:53:34
|
I have looked at the db and ther is no table called FORUM_PM
|
 |
|
currington
Starting Member
26 Posts |
Posted - 28 July 2002 : 05:58:28
|
Ok, I am not sure what I did wrong in the first place but I have uploaded the dbs file and ran it again and we are now fully functional.
Thankyou for for help.
Matt
|
 |
|
Hamlin
Advanced Member
    
United Kingdom
2386 Posts |
Posted - 28 July 2002 : 05:58:52
|
Did you get any errors when you ran the mod setup? Also what connection string and database are you using...
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it. http://www.ian-hamlin.co.uk ™ |
 |
|
currington
Starting Member
26 Posts |
Posted - 28 July 2002 : 06:19:20
|
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("2600/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
I am sure That I had errors when I fisrt ran the dbs_setup file (Red text?) but I was half asleep when I did it. My fault for operating a pc without a suficient caffine fix.
|
 |
|
currington
Starting Member
26 Posts |
Posted - 28 July 2002 : 06:23:31
|
Also, I got this msn messenger addon but I am even more confused with this one. I got 2 files : 1. inc_msnmessenger2b 2. mc
What do I do with these? there is no readme.txt with this one and now info from the site that provided it http://www.ls3k.com/snitz/mods.asp?action=details&ID=78

|
 |
|
Hamlin
Advanced Member
    
United Kingdom
2386 Posts |
Posted - 28 July 2002 : 06:32:28
|
Just put the files in your forum directory and then include the file somewhere, maybe like this around line 386 of default.asp
rs.MoveNext loop rs.close set rs = nothing end if
%> <!-- #include file ="inc_msnmessenger2b.asp" --> <%
if strShowStatistics = "1" then WriteStatistics end if Response.Write " </table>" & vbNewline & _
it say addon tho, so you mite need another mod installed or something.
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it. http://www.ian-hamlin.co.uk ™ |
 |
|
currington
Starting Member
26 Posts |
Posted - 28 July 2002 : 07:07:57
|
ok, that did it but this addon is crap, it calls for an icon that is not there /forum/icon_msn.gif, it shows icons for your online contacts but doesn't display who they are.
Do you know ov a good MSN addon?
|
 |
|
|
Topic  |
|