Author |
Topic |
headmaster
Starting Member
16 Posts |
Posted - 27 December 2002 : 18:15:54
|
Yes, I did. I noticed at the top of the db setup script, it is: Private Messages Mod (Default) [CREATE] PM <--- Should this be FORUM_PM ?? M_ID M_SUBJECT#varchar (100)#NULL# M_FROM#int#NULL#
UPDATE... No matter which way I run the dbs script, I get an error "Table Already Exists". I missed this the first time around so the update is not working. Any Ideas?
Thank you, headmaster
|
Edited by - headmaster on 27 December 2002 18:42:00 |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 27 December 2002 : 18:55:14
|
quote: PM <--- Should this be FORUM_PM ??
No, it's taken care of automatically and the FORUM_ is added. Can you open your database and look inside to see if the table is actually there and all the columns too despite what the script says?
@tomic |
SportsBettingAcumen.com |
|
|
headmaster
Starting Member
16 Posts |
Posted - 27 December 2002 : 18:58:40
|
How? When I open it via FrontPage, it starts access and propmts me for a PW. What is the default ID and PW for opening the DB?
headmaster |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 27 December 2002 : 19:10:32
|
So far as I know you can't open Access with Frontpage. You would open it with Access. Do you have MS Office Professional? If not opening the database might not be an option for you. There is no ID and password for your database unless you added them yourself.
The indication I see is that the table does not exist. Which connection string are you using in config.asp?
@tomic
|
SportsBettingAcumen.com |
|
|
headmaster
Starting Member
16 Posts |
Posted - 27 December 2002 : 19:17:29
|
I did not add a database logon and password but when I copy it to my loacl PC, it still asks me for one.
I used the DSN option for my config.asp. The forum has been running great otherwise.
Thanks for taking the time to help me.
headmaster. |
|
|
@tomic
Senior Member
USA
1790 Posts |
|
headmaster
Starting Member
16 Posts |
Posted - 27 December 2002 : 20:04:52
|
quote: Originally posted by headmaster
I did not add a database logon and password but when I copy it to my loacl PC, it still asks me for one.
I used the DSN option for my config.asp. The forum has been running great otherwise.
Thanks for taking the time to help me.
headmaster.
UPDATE!
The db script did not work on ACCESS 2000. I had to create the table manually. However, the update functions in the script DID work.
I was not sure about the M_ID field so I created it as autonumber and everything seems to work!
varchars were created as "text" and numeric was created as "number" and set to the appropriate default value.
The login was an error on my version of Access and did not pertain to the PM mod at all.
The PM's seem to be working fine! Thanks @tomic for pointing me in the right direction!
As usual... your a great help and very patient!
headmaster. |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 27 December 2002 : 20:37:13
|
You're welcome. I'm glad it's going And you are correct. M_ID is an autonumber field.
@tomic |
SportsBettingAcumen.com |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 30 December 2002 : 03:53:01
|
Just to let you all know...I am almost done with an ignore feature and just need to test it some more. I should have that ready for download as well as a few other fixes people have been asking about within a few days.
@tomic |
SportsBettingAcumen.com |
|
|
Hasheba
New Member
USA
97 Posts |
Posted - 04 January 2003 : 16:12:49
|
Holy crap! I just uploaded everything to my forum... Now I read on the readme that I wasn't supposed to upload like 5 files!! AHH! I just messed my forum up! HELP ME |
-Jeff http://www.leo-land.net |
|
|
Hasheba
New Member
USA
97 Posts |
Posted - 04 January 2003 : 16:26:44
|
OMG! I had to reinstall those pages! Good thing I only had one mod installed! lol
|
-Jeff http://www.leo-land.net |
|
|
gareth_moore_2000
Junior Member
United Kingdom
262 Posts |
Posted - 04 January 2003 : 19:21:51
|
Hi
Great work here- its quite sometime since I installed this MOD and since has been running smoothly ! However I just noticed.... in the pm_options.asp page, I turned the option on for e-mail alerts when a new PM is recieved. I have tested this but have never recieved an e-mail alerting me !
Has this been addressed ? -I have browsed this entire topic and cant see it !
Ignore feature sounds cool ! |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 04 January 2003 : 20:06:46
|
I don't know what's up with email notification. The code looks fine but it just doesn't seem to work. I read through archived posts about it and it has been a nagging problem for a long, long time. I wish I had something better to tell you but for now that's all I can say for now.
@tomic |
SportsBettingAcumen.com |
|
|
gareth_moore_2000
Junior Member
United Kingdom
262 Posts |
Posted - 06 January 2003 : 16:18:26
|
It does work !!!!
I never thought this before because I took away the pm_options page, so I never gave this option to my visitors ! However I added this page back and have found it does work !
But interestingly you only recieve an e-mail alert if someone send you a NEW Private Message !
If you send them one, and they REPLY to it.... you dont recieve an e-mail ! Maybe its supposed to work like that ?! -But it would be good if that could be changed to work either way ?! |
|
|
retro
Junior Member
123 Posts |
Posted - 11 January 2003 : 01:09:29
|
I have the mod installed and functional, but I can never see my Outbox or Send PM buttons. I only see the Recieve, Member List, and Preferences buttons.
I went into the Admin section and set the PM limit to 500 to see if that made a difference (I only have 10 pms in my box from my upgrade).
Any help???
Thanks!!
Sean |
Sean |
Edited by - retro on 11 January 2003 01:11:14 |
|
|
Topic |
|