| Author |
 Topic  |
|
withanhdammit
Junior Member
USA
236 Posts |
|
|
cripto9t
Average Member
USA
881 Posts |
 Posted - 28 March 2005 : 08:23:16
|
quote:
Originally posted by nsukz
I managed to implement edit time limit by the guides of cripto9t, but now administrator cannot delete the users, im getting this error message
"Microsoft JET Database Engine error '80040e37'
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.
/snitz/pop_delete.asp, line 654"
nsukz, that's the private messages mod causing the error. It looks like you haven't added it to the database yet.
Do you have private messages working?
You might want to post a new topic in the Help Forum< |
_-/Cripto9t\-_ |
 |
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 01 April 2005 : 09:00:56
|
Ello,
I got these erros when updating the db.... any ideas?
-2147217900 | ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column 'F_EDIT_TIME' cannot be added to table 'FORUM_FORUM' because it does not allow nulls and does not specify a DEFAULT definition.
Thanks.< |
Edited by - Doughnut on 01 April 2005 10:03:51 |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 02 April 2005 : 07:50:45
|
Doughnut,
I've never seen that  . Anyway
There should be an uninstall folder in the download. Copy the dbs file in that folder and put it in you main forum folder. Then update with that file "Uninstall Edit Time". It will remove any thing that was added in the first update. When your through delete that file in your main folder.
Now replace this line in dbs_edit_time.asp
ADD#F_EDIT_TIME#varChar(7)##
Replace it with this
ADD#F_EDIT_TIME#varChar(7)#NULL#
Then update again with "Edit Time Mod"
I think that will do it.< |
_-/Cripto9t\-_ |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 02 April 2005 : 13:04:31
|
Thanks, I'll give it a go later and let you know  < |
|
|
|
nsukz
Starting Member
20 Posts |
Posted - 03 April 2005 : 11:06:08
|
What is Private Message?
I have added anything like PM? All i have added is "the timelimit for the message edit/delete"< |
|
|
|
nsukz
Starting Member
20 Posts |
Posted - 04 April 2005 : 04:48:21
|
Sorry typing mistake in above post.
What is Private Message?
I havent added anything like PM? All i have added is "the timelimit for the message edit/delete"< |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 04 April 2005 : 10:19:24
|
nsukz, find this code and remove it.
'## Forum_SQL - Delete Private Messages that the user has sent or received
strSql = "DELETE FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE " & strTablePrefix & "PM.M_TO = " & Member_ID
strSql = strSql & " OR " & strTablePrefix & "PM.M_FROM = " & Member_ID
my_Conn.Execute(strSql)
The reference files in the download contain the private messages mod and probably a few others.
That's why you should always back-up your original files and make the code changes instead of overwriting your files with the reference files.
If you are using the other files in the download you may run into other problems.< |
_-/Cripto9t\-_ |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 04 April 2005 : 13:37:58
|
quote:
Originally posted by cripto9t
Now replace this line in dbs_edit_time.asp
ADD#F_EDIT_TIME#varChar(7)##
Replace it with this
ADD#F_EDIT_TIME#varChar(7)#NULL#
Then update again with "Edit Time Mod"
I think that will do it.
I think that did the trick mate...
I did get an error but I think it's just because something is being duplicated is that right?
-2147217873 | Cannot insert duplicate key row in object 'FORUM_CONFIG_NEW' with unique index 'C_VARIABLE'.
Thanks..< |
Edited by - Doughnut on 04 April 2005 13:38:26 |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 04 April 2005 : 14:50:36
|
quote:
Originally posted by Doughnut
I did get an error but I think it's just because something is being duplicated is that right?
-2147217873 | Cannot insert duplicate key row in object 'FORUM_CONFIG_NEW' with unique index 'C_VARIABLE'.
Thanks..
That's what it sounds like. The uninstall was supposed to delete those variables in config_new, but maybe it didn't work.
Anyway the mod won't work without them . If you want to make sure they are there, you can look in "admin options > forum variables" for "STREDITTIME" and "STRDELETETIME". They will be listed there along with thier settings.< |
_-/Cripto9t\-_ |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 04 April 2005 : 14:54:13
|
Yea they are there, thanks!
It's a good addition as it goes, something I'd been looking for < |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 06 April 2005 : 05:05:50
|
Ello again,
Getting a bit of an error from a few people..
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'split'
/forum/post.asp, line 304
When I try to reproduce this with an ordinary acount I can't so I'm not sure why they're getting it, it doesn;t seem to be in all sections.
Any ideas?
Thanks..........< |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 06 April 2005 : 05:07:08
|
This is line 304 by the way;
arrEditTime = split(rs("F_EDIT_TIME"),"|")
Thanks...< |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 06 April 2005 : 07:45:38
|
Try this Doughnut
change this line, its just above line 304
if (rs.EOF or rs.BOF) or trim(rs("F_EDIT_TIME")) = "" or then
to this
if (rs.EOF or rs.BOF) or (trim(rs("F_EDIT_TIME")) = "") or (isNull(rs("F_EDIT_TIME"))) then
Probably have to do the same for delete.
< |
_-/Cripto9t\-_ |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 06 April 2005 : 08:21:23
|
Yea, if that works, you'll need to make the same code change in pop_delete.asp.
My line number is 732.
I think that will do it for the null setting.
Sorry about the errors, I'm going to do some testing this morning with these changes. Let me know what happens, I want to update the download. If your members still get errors, you can turn this off in "admin options".< |
_-/Cripto9t\-_ |
|
|
|
Topic |
|
Edit/Delete Post Time Limits
