Approving Altered Helps

This forum contains bugs which the test team think are fixed are awaiting confirmation from the initial reporter of the bug.
Post Reply
User avatar
Harroghty
Staff
Staff
Posts: 9695
Joined: Tue Jul 27, 2004 5:38 pm

Approving Altered Helps

Post by Harroghty » Sun Apr 15, 2012 3:38 pm

I had some problems dealing with a changed help. Help files themselves are easy to fix with a quick disconnect and reconnect, but this appears to be a deeper issue with the help file editing system. You can edit a file easily enough with hedit filename, and it will work fine if you can edit without needing outside approval, but approving those completed by others appears to have issues.
approve list
1. Update of content in SKILL LEVELS
newhelp skill levels
Log: Reconnecting to database...
Error while attempting to retrieve help: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2994' at line 1
approve yes skill levels
Error while retrieving pending helps: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2994' at line 1
approve yes 'skill levels'
Couldn't find any help file to deny changes to that matches keyword ''skill levels''
approve yes skill levels
Error while retrieving pending helps: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2994' at line 1
Disconnected from database.
Reconnected to database!
approve yes skill levels
Error while retrieving pending helps: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2994' at line 1
"A man may die yet still endure if his work enters the greater work, for time is carried upon a current of forgotten deeds, and events of great moment are but the culmination of a single carefully placed thought." - Chime of Eons
User avatar
Raona
Staff
Staff
Posts: 4944
Joined: Fri Aug 19, 2005 3:40 pm
Location: Waterdeep - Halls of Justice
Contact:

Re: Approving Altered Helps

Post by Raona » Sat Apr 21, 2012 10:55 am

I've got something in on Bugzilla relating to this. I think Mask updated the MySQL version, but might not have updated the pending help edits database to reflect the update. That's my best guess, based on the symptoms, anyway.

As an interim fix, I've found that if you HEDIT the edited helpfile, it will come up with the edits in place. Then just save it, and it amounts to approval. The downside is that you can't compare old and new very readily, and it doesn't work for changes involving HSET, you have to re-perform those manually.
Post Reply