| Author |
 Topic  |
|
AnonJr
Moderator
United States
5768 Posts |
 Posted - 13 March 2008 : 13:04:12
|
you'd probably want to add:
Response.Write strSql
Response.End
so it stops before it moves on to the error page.  < |
 |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 13 March 2008 : 13:45:11
|
Cheers tried that, I now get this
SELECT FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T_MESSAGE, FORUM_TOPICS.T_AUTHOR, FORUM_TOPICS.T_REPLIES, FORUM_TOPICS.T_DATE, FORUM_TOPICS.T_LAST_POST, FORUM_MEMBERS.MEMBER_ID, FORUM_MEMBERS.M_NAME, FORUM_MEMBERS.M_TITLE, FORUM_MEMBERS.M_LEVEL, FORUM_MEMBERS.M_AVATAR_URL, FORUM_MEMBERS.M_POSTS FROM FORUM_TOPICS, FORUM_FORUM, FORUM_MEMBERS WHERE FORUM_FORUM.F_PRIVATEFORUMS = 0 AND FORUM_TOPICS.FORUM_ID = FORUM_FORUM.FORUM_ID AND FORUM_FORUM.FORUM_ID = 18 AND FORUM_TOPICS.T_AUTHOR = FORUM_MEMBERS.MEMBER_ID AND FORUM_TOPICS.T_STATUS < 2 AND FORUM_TOPICS.T_STATUS > 0 ORDER BY FORUM_MEMBERS.M_NAME, FORUM_TOPICS.T_DATE DESC;
< |
Edited by - thelodger on 13 March 2008 13:45:29 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 13 March 2008 : 14:09:48
|
Not sure why you're getting the error, but I do wonder why its checking for the status to be less than 2 and greater than 0 ... wouldn't it be easier to just check and see if its 1? 
I'm also wondering why you're getting a storage error on a SELECT statement...
How many replies are there to this topic?< |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 13 March 2008 : 15:15:20
|
There are 2 test posts which I managed to do before I realised I was getting forum errors.
Problem is it wont let me delete them, I keep getting this error when I try
Active Server Pages error 'ASP 0113'
Script timed out
/pop_delete.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 13 March 2008 : 15:19:58
|
| I'm not sure if the MOD required any changes to existing files, but if there were any changes needed, I'd start checking them. Something just doesn't seem right, but I can't seem to put my finger on it...< |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 13 March 2008 : 15:21:17
|
| Yeah a few changes were needed, I will start again I think and see what happens.< |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 13 March 2008 : 16:00:32
|
Whats the best way to delete this forum catagory? when I try I get
quote:
Active Server Pages error 'ASP 0113'
Script timed out
/pop_delete.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
I have tried to do the mod from scratch again and I get the same error, I cannot delte the old catagory or posts because of this error< |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 14 March 2008 : 12:04:39
|
Yes mate the contents of weblogvars is
dim strWeblogsForum, strWeblogsDisplayName, strSMMReplyText, strSMMReadRepliesText, strSMMNoReplies
dim strSMMPostedby, strSMM1Reply, strSMMNReplies2, strSMMNListClosed, strNewsAllNewsItems, strNewsPostAnItemText
dim strSMReply, strSMReplies
strWeblogsForum = "18"
strWeblogsDisplayName = "Laddies Blogs"
strSMMReplyText = "post a reply"
strSMMReadRepliesText = "read the replies"
strSMReply = "reply"
strSMReplies = "replies"
strSMMNoReplies = "there are no replies"
strSMMPostedby = "posted by [user] on [date] at [time]"
strSMM1Reply = "there's one reply by [user] on [date] at [time]"
strSMMNReplies2 = "there are [n] replies, with the last one by [user] on [date] at [time]"
strSMMNListClosed = "closed"
strNewsAllNewsItems = "all items"
strNewsPostAnItemText = "submit a new item"
'Change the line below to "No" or include your own ads in the file inc_468x60.asp
strEnableAdsInWeblogs = "Yes" < |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 14 March 2008 : 13:58:32
|
Ok, just to be sure that it's not that that is causing the problem.
Does that forum also have an archive?< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 14 March 2008 : 14:23:24
|
| Yes it does mate.< |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 14 March 2008 : 14:43:11
|
Mmmm....I must admit I haven't dared to do any archiving in the weblogsforum.
If you open up the db, do you see anything strange about the weblogsposts/replies compared to other posts/replies (for example missing fields, empty fields, stuff like that).< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 14 March 2008 : 14:51:39
|
| I dont know how to open the database, I have never done that, I have only ever added stuff in it from the admin with the help of commands from this site.< |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 14 March 2008 : 15:40:49
|
| No its mysql< |
|
|
|
Topic |
|
Blogs
