Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Problem moving posts
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Problem moving posts

 Post Reply Post Reply
Author
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post Topic: Problem moving posts
    Posted: 23 March 2009 at 7:21pm
One of my moderators is unable to move any posts. He receives the following error:
 
Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert duplicate key row in object 'dbo.tblTopic' with unique index 'tblTopic$Start_Thread_ID'.

/forum/move_post.asp, line 143
 
It used to happen on our old Access db, but I couldn't replicate the problem on my test server. I'd hoped moving to SQL might magic up a fix, but alas not. All other mods and admins can move posts with no issues. Any help gratefully accepted!!
 
Ric
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: 24 March 2009 at 8:04am
As you are posting in the version 8 forum I take it you are still using version 8.

Try upgrading to the latest 9.56 release as you may find the issue has been fixed as I do recall an issue with moving posts in version 8 but it has been quite a few years since version 8 was superseded by version 9.
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post Posted: 24 March 2009 at 7:27pm
Hi Bruce, yes it's v8. We moved over to hosting with you a few weeks back (aircooled.org...), as explained then, it's not a simple job for us to upgrade yet. :(
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: 25 March 2009 at 7:34am
Try using the move_post.asp file from the latest release. It may work as I don't think there are any changes to this file that are specific to version 9.

Make a backup of your present move_post.asp file first though incase it doesn't work.
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post Posted: 25 March 2009 at 6:48pm
Ok, thanks, will give it a try. If that doesn't work, I might make him re-register as non of the other mods are affected.
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.