Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Edit posts/quote other user not working
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Edit posts/quote other user not working
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
AliasInsider View Drop Down
Newbie
Newbie


Joined: 23 October 2003
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote AliasInsider Quote  Post ReplyReply Direct Link To This Post Topic: Edit posts/quote other user not working
    Posted: 16 January 2004 at 1:02pm

I'm using the SQL version - everything was working fine until my webhost moved my SQL db to a new server. The site was screwed up for a couple weeks, but they finally got everything working. One of the guys there told me he got my forum working again by using a DSN, but I get no replies from them, so I thought I'd see if anyone here could offer advice.

Since I got back up & running, I can do pretty much everything except when users go to "edit posts" they've already made, the input field is completely blank (so they can't edit anything cause there is nothing there). Also, when you go to "quote" something from someone else's post, the code for quotes ("[quote]") is there, but there is no text between the delimiters. Also, been having problems with Private Messages (can send them, but when I go to open/delete them the page just sits there forever and never works).

Anyone have any advice other than continue to nag my dumb webhost? They suck, and I have a feeling I'll never get a straight answer. :(

Thanks!
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 16 January 2004 at 1:13pm
The forum is designed to use a DNS-less OLE connection to the SQL server.

When I was making the forum I did find that if a DSN or other driver was used there is problems like you mention that I couldn't find a way to over come.

Your only solution is to get your hosts to sort out the SQL srever problem so that you can connect to it using the forums default SQL OLE DSN-less driver.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
AliasInsider View Drop Down
Newbie
Newbie


Joined: 23 October 2003
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote AliasInsider Quote  Post ReplyReply Direct Link To This Post Posted: 16 January 2004 at 3:53pm
Thank you, boRg! I was afraid that was the answer, but I'll fight it out with them some more~
Back to Top
JohnKn View Drop Down
Groupie
Groupie


Joined: 22 March 2003
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnKn Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2004 at 2:17pm
I just did an upgrade to SQL as well and ran into the same problem, however I worked out a solution without having to change the connection string. The connection string I'm using is:

strCon = "Driver={SQL Server};Server={serverName};Database=dbName;trusted_connecti on=true;"
On to the fix...If you move strMessage = rsCommon("Message") from line 153 to line 132 in edit_post.asp (ww version 7.6a), just after you open the record set, it  should solve the problem, it did for me. For whatever reason ASP is losing the value of the variable if it comes later.

It also seems to be a problem only with the standard text editor, if you have the WYSIWYG editor turned on it correctly reads the post into the edit field without having to modify the code since it gets the value in a different manner.

I hope this helps.

John




Edited by JohnKn
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2004 at 2:50pm
Could this have to do with the order the text is retrieved for the database? I recall there being a problem if a text field from a recordset was stored to variable without the text field being the last field called in the SQL statement.

.... or something like that.
L. Jamal Walton

L. Jamal Inc : Web/ Print Design and ASP Programming
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.