|
It is currently 19 Apr 2024, 04:02
|
View unsolved topics | View unanswered posts
|
|
|
|
Author |
Message |
laserking
|
Post subject: The apostrophe problem is back (or maybe it never left) Posted: 25 Oct 2012, 19:16 |
Serious fan |
|
|
Joined: 05 Jan 2005, 21:37 Posts: 202 Location: Lexington, Ky, United States Has thanked: 1 time Been thanked: 37 times
|
Hi Julien and Everyone, I hate to have to report this, but the problem we had some time ago with the apostrophe has returned. It's possible that it never truly went away, but I hadn't noticed it again until recently. It's certainly not as bad as it once was. At least that is something to be thankful for, what with Thanksgiving coming soon! The problem now seems to be isolated in the updates to existing titles, i.e. it is not affecting new title submissions as it once was. The specific examples I can point to in my own update submissions are those I did recently for "Lena's Holiday" and "Our Mother's Murder". These have not been validated yet, and are in the "pending updates" section. It seems that anytime one submits an update to an existing listing with an apostrophe in the title, the system adds a backslash (\) right before the apostrophe for some unexplained reason. Has anyone else noticed this? I suppose that this is a problem which doesn't come up too often, as there are only a limited number of titles which include an apostrophe. I was optimistic that we had finally beaten this nagging problem into submission, but it seems to have reared its' ugly head once again. I felt that it was worth mentioning again here. At least it is not running rampant the way it once was. Perhaps we can have one more go at it, and hopefully vanquish it from the site forever! I'm keeping my fingers crossed! Regards, David
|
|
|
|
|
lons_vex
|
Post subject: Re: The apostrophe problem is back (or maybe it never left) Posted: 25 Oct 2012, 22:57 |
Advanced fan |
|
|
Joined: 03 Oct 2003, 10:06 Posts: 729 Location: at home :p Has thanked: 57 times Been thanked: 61 times
|
I submitted an update for Let's Nupunupu [FLLF-8546] a while ago, and in my pending updates list the title is displayed as " Let\'s Nupu Nupu ", so yeah I see that problem too.
|
|
|
|
|
admin
|
Post subject: Re: The apostrophe problem is back (or maybe it never left) Posted: 02 Aug 2013, 12:19 |
Site Admin |
|
|
Joined: 07 Aug 2002, 23:37 Posts: 4548 Location: Tokyo Has thanked: 294 times Been thanked: 1144 times
|
... and how it's back at ALL levels since I upgraded the PHP version. There must be some "escape all entities for safety" set by default now and I'm escaping the escaped ones once more Code review ASAP! Right now I turned ON a lot of debug/logs and I'm fine-tuning the new server. Julien
_________________ HARDWARE DATABASE HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
|
|
|
|
|
admin
|
Post subject: Re: The apostrophe problem is back (or maybe it never left) Posted: 15 Jul 2015, 09:38 |
Site Admin |
|
|
Joined: 07 Aug 2002, 23:37 Posts: 4548 Location: Tokyo Has thanked: 294 times Been thanked: 1144 times
|
Played a little more with the ' " \ issue on submitted titles, it should be much better now. Also the "Misc notes" will not get lost during an Expert insert if any error is detected when clicking on "Submit". I know it must be very frustrating to lose all your hard entered notes without a warning Julien
_________________ HARDWARE DATABASE HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
|
|
|
|
|
laserdisc_fan
|
Post subject: Re: The apostrophe problem is back (or maybe it never left) Posted: 18 Sep 2015, 10:39 |
Jedi Candidate |
|
|
Joined: 29 Jan 2006, 20:05 Posts: 2266 Location: United Kingdom Has thanked: 0 time Been thanked: 23 times
|
publius wrote: Ooh, searching for "Y's", I discovered that, each time I changed from one page to the next of the results, it added another "/" to the search string, until it stopped working at all. Yes this problem has been with us forever.
|
|
|
|
|
muzer
|
Post subject: Re: The apostrophe problem is back (or maybe it never left) Posted: 19 Sep 2015, 15:48 |
Serious fan |
|
|
Joined: 02 Sep 2015, 00:03 Posts: 173 Location: United Kingdom Has thanked: 3 times Been thanked: 24 times
|
Looks like you're incorrectly MySQL-style escaping the search string when generating the URL for the next page. This shouldn't need MySQL-style escaping, just URL encoding. If you're not explicitly escaping anything, it could be caused by PHP Magic Quotes, one of the most insidious, ridiculous and pure evil features known to man (but this is PHP, so that should come as no surprise). If it does turn out to be this, I would recommend disabling PHP Magic Quotes, but the fact that it's enabled already possibly means that there's something relying on it that would become a security vulnerability were it disabled, so tread with extreme caution.
|
|
|
|
|
admin
|
Post subject: Re: The apostrophe problem is back (or maybe it never left) Posted: 02 Oct 2015, 08:38 |
Site Admin |
|
|
Joined: 07 Aug 2002, 23:37 Posts: 4548 Location: Tokyo Has thanked: 294 times Been thanked: 1144 times
|
laserdisc_fan wrote: publius wrote: Ooh, searching for "Y's", I discovered that, each time I changed from one page to the next of the results, it added another "/" to the search string, until it stopped working at all. Yes this problem has been with us forever. Actually this one was fixed when I fine-tuned the search engine back in August to allow for natural and logical searches. Julien
_________________ HARDWARE DATABASE HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
|
|
|
|
|
|
|
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|