| Author |
 Topic  |
|
master of puppets
Junior Member
Canada
117 Posts |
 Posted - 10 January 2001 : 00:04:06
|
Hey slemieux, remember me?
lol
Ignore user, that was back in the day.
anyway, is the release of the private messages in the first post the most recent?
"If I close my mind in fear, Please pry it open" - Metallica |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 January 2001 : 00:13:18
|
No, there have been some cookie changes.
Download the one in the first post, and then download this as well:
http://www11.ewebcity.com/dssdbs/files/pm4sr4.zip
unzip the first .zip file and then unzip the pm4sr4.zip to the same directory and let it overwrite all of the files. the pm4sr4.zip just contains the .asp files and not the setup or image files, or the instructions to install it. |
|
|
|
Till
Starting Member
Australia
31 Posts |
Posted - 10 January 2001 : 07:51:26
|
If I try any of the preferences in private messages, I get this error 
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forums/sf_forum/pm_options.asp, line 62
Line 62 is this:
62:my_Conn.Execute(strSql)
63:if strSetCookieToForum = 1 then
64: Response.Cookies(strCookieURL & "paging").Path = strCookieURL
65: end if
I get this error with all the different mods, yours, HuwR's, I can't remember the other one....
I'm using the Access2000 connection string!
I use Internet Explorer
5.0 because the other one
Your Comment_____________ |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 January 2001 : 07:57:05
|
| did you make sure to uncomment the database type in config.asp? |
|
|
|
Till
Starting Member
Australia
31 Posts |
Posted - 10 January 2001 : 08:06:25
|
yes, this is how it is:
strDBType = "access" '## access, sqlserver or mysql
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Websites\SportsFish\db\snitz2000.mdb;" '## MS Access 2000
I use Internet Explorer
5.0 because the other one
Your Comment_____________ |
|
|
|
Till
Starting Member
Australia
31 Posts |
Posted - 10 January 2001 : 08:10:49
|
The rest works fine though!
I use Internet Explorer
5.0 because the other one
Your Comment_____________ |
|
|
|
Till
Starting Member
Australia
31 Posts |
Posted - 10 January 2001 : 11:03:54
|
Ok its sorted out, it appears you need to have all selections checked before submiting or you get the error. Confusing for newbies, as none are checked by default?
Cheers Till
I use Internet Explorer
5.0 because the other one
Your Comment_____________ |
|
|
|
CrAzY
New Member
USA
50 Posts |
Posted - 10 January 2001 : 13:18:16
|
Can someone post all the tables(properties) for Pm since the mod_dbsetup.asp isn't working properly for me.
« [url=http://www.nokturnal.net/]Nokturnal.Net[/url] »
Seize The Night
|
|
|
|
bugzy
Junior Member
USA
147 Posts |
Posted - 10 January 2001 : 13:23:45
|
whats the link for the up to date PM mod for SR4 ?
www.nokturnal.net
|
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 12 January 2001 : 14:49:19
|
I have found a small bug, well I didn't, someone testing my forum did, if you try to send an ICQ message to anyone from inside PM, you get an Object expected eror.
This is because it is doing this
<a href="JavaScript:openWindowICQ
There is no openWindowICQ function in any of the PM code.
Slemieux, any chance of posting the function.
'Resistance is futile' |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 14 January 2001 : 14:21:18
|
i found a bug in all the files.....
if soemone names there member table something different then there forum table they will get a ton of errors. this mod has switched a couple minor things that are easy to fix. on all the sql strings you need to look at if it is accessing the MEMBERS table or the PM table. there are alot of spots where
" & strMemberTablePrefix & "MEMBERS
is switched with
" & strTablePrefix & "MEMBERS
and it is also the same way with the PM table also
Brad |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 14 January 2001 : 14:24:37
|
oh and another one would be in pm_delete2.asp
strSqL = "UPDATE " & strTablePrefix & "PM "
strSql = strSql & "SET FORUM_PM.M_OUTBOX = 0 " & _
"WHERE M_ID IN (" & strRemoveList & ")"
my_Conn.Execute (strSql)
It has all ready specified that PM starts with FORUM, which mine does not.
Brad |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 14 January 2001 : 14:43:54
|
and another bug
in pm_view.asp it uses CColor as the background color of some of the tables when displaying the messages. you have to specify the color of CColor which was not specified. here is just a quick little sample that shows ABOUT what it should look like...
intI = 0
do until rs.EOF or rs.BOF
If intI = 0 then
CColor = strAltForumCellColor
else
CColor = strForumCellColor
end if
' do some code here
rs.MoveNext
intI = intI + 1
if intI = 2 then
intI = 0
end if
rec = rec + 1loop
Brad |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 14 January 2001 : 15:24:52
|
ok im going to quit working on my PM cause i hate tellin people they have bugs. i know i hate hearing it but this is the last one for today, but this is nothing major at all...
in pm_pop_members.asp where it displays each letter for them to choose what members to show, one of them has two commas. i think it is letter C or D but im not for sure. i cant tell you a line number cause im edited my code so much that it wouldnt be close 
Brad |
|
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 14 January 2001 : 17:29:07
|
Thanks for posting all those!
I am always leary about releasing any mods, simply because I do them for use on my forum. So when they work for me, I am happy with them.
It's good to see everyone here take whatever I release and fix these things for everyone else 
Scott LeMieux
NDesigns.net |
|
|
|
Topic |
|
Topic Locked
