| Author |
 Topic Search  Topic Options
|
Andersen 
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 25 December 2004 at 5:10pm |
If I comment this line out from forum_topic.asp (line 424) then it all works fine:
'strFirstPostMsg = Mid(rsTopic("Message"), 1, 275)
Can anyone tell me, what´s happning?
What does this line do, why does it work without, and why is this given me problems when upgrading from 7.01 to 7.9 when the databases is identical?
Btw this line is not in the forum_topic.asp from version 7.01
|
|
Greets
Andersen
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 December 2004 at 7:05am |
|
This line gives a preview of the first message when you hover the mouse over the link to the topic in the active topics page
|
|
|
|
Andersen
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 December 2004 at 7:28am |
Can you tell me why this line gives the error then?
I am a bit afraid to "open" the new upgraded forum yet, untill I know whats the problem here, and hopefully how to fix it.
|
|
Greets
Andersen
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 December 2004 at 8:02am |
|
the field either isn't being bought in via the query Select table.fieldname
Fieldname = "message" (or whatever its called)
is that in the query above , that brings in the topic details... if not
add it to the begining after SELECT it may be a Stored procedure then
in that case you will need to check the stored procedure named above
the query.
else
it might be that the topic table doesn't hold the new field check the topic table to make sure the table holds the field.
|
|
Andersen
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 December 2004 at 8:20am |
I have very little idea what you´re speaking of boRg. I know very little asp, and nada sql.
I have however found out how to open a tabel, and I can tell for sure, my two databases (7.01 and 7.9) is identical as far as topic tabel goes. So my guess is that the field is missing.
Now, how do I add it, and whats the name of it?
(and why is it missing?).
|
|
Greets
Andersen
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 December 2004 at 8:34am |
|
There are no fields added to the database between different version 7 databases.
|
|
|
|
Andersen
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 December 2004 at 9:24am |
 Is there anyone who is capable of telling me, whats going on, and how I get version 7.9 to work from this point I have reached?
I am getting more confused for each answer to this topic and close to give it all up 
|
|
Greets
Andersen
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 December 2004 at 9:32am |
|
i thought that was the case -boRg- ,
the only thing i can think is that your .asp files are corrupt, as the database should be correct.
the first error message suggests the value isn't bought into the page.,
to downloading a new version of the forum_posts.asp, also if you want
you can send me an email with the existing file, to check,
Aaron[AT]emagine-hosts.com
also if you need you can contact me via MSN (aaronhoc[at]hotmail.com)
|
|
