When I run new_mem_pm_setup.asp I get the following error. -2147217900 | Table 'FORUM_USERFILES' already exists. -2147217900 | Table 'FORUM_MODS' already exists. -2147217887 | Field 'M_ALLOWDOWNLOADS' already exists in table 'FORUM_MEMBERS'. -2147217887 | Field 'M_ALLOWUPLOADS' already exists in table 'FORUM_MEMBERS'. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement.
quote: -2147217900 | Table 'FORUM_USERFILES' already exists. -2147217900 | Table 'FORUM_MODS' already exists. -2147217887 | Field 'M_ALLOWDOWNLOADS' already exists in table 'FORUM_MEMBERS'. -2147217887 | Field 'M_ALLOWUPLOADS' already exists in table 'FORUM_MEMBERS'.
because your tables already have those fields.
The second set of errors ( the alter statements )
quote: -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement. -2147217900 | Syntax error in ALTER TABLE statement.
I am unsure about. Is that ALL it prints out or is there more where it actually refers to the table it is trying to alter?
that is all it says. I understand that the first few rows are because the file had already been run once. This MOD was included in a zip file with several other mods I downloaded from HuwR's site. I have seen it running on another site.
Ok, errors aside, what happens if you try to run say the admin_nememPM or register as a new user.
If you have run this several times, then you will probab;y discover your FORUM_MODS table has duplicate entries. remove any dupllicates and then retry the mod, as far as I can see the stuff in the setup that is eroring is to do with file attachments and not the newmember pm
When I run the admin_new_mem_pm.asp the admin page loads but the images are all bad this error occurs when I click to submit. Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression ''Welcome to Pagelord's Realm. This is your first private message.' WHERE M_NAME = 'NewMemPM' AND M_CODE = 'Message''.
Almost got it worked through. I can edite the message without error as long as I dont use any punctuation in the message. images still show as bad. and I cant figure for the life of me where the changes to register.asp should go. The docs dont refer to a line number or include anything that looks like I could blend it into anything that is already there I have made modifications to this file before when installing the email random password MOD so I cant just overwrite the file.
I cant believe that I missed something simple I am humbled. All is working fine ie: no errors But the message is not showing up in the new members inbox when they login.
No it is not being written to the PM table. I have looked at the code in pm_options.asp and changed it so that on is default but that didnt work. should I be looking somewhere else? it appears that the PM options are set individually by the user.
Topic Locked
Posted - 13 April 2001 : 02:06:52
