Anonymous | Login | Signup for a new account | 2024-04-19 05:05 UTC |
My View | View Issues | Change Log | Roadmap | Site Issue Support Ranking | Rules | My Account |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0001069 | Site | [All Projects] Bug | public | 2012-09-26 15:13 | 2018-12-01 06:46 | ||||
Reporter | Qent | ||||||||
Assigned To | Blzut3 | ||||||||
Priority | normal | Severity | minor | Reproducibility | always | ||||
Status | closed | Resolution | no change required | ||||||
Platform | Microsoft | OS | Windows | OS Version | XP/Vista/7 | ||||
Summary | 0001069: Weird error in posts | ||||||||
Description | limit 1, limit 2, gets replaced with LIMIT OFFSET 1LIMIT OFFSET 2 | ||||||||
Attached Files | |||||||||
Notes | |
(0004820) Blzut3 (administrator) 2012-09-27 01:09 |
Steps to reproduce? |
(0004824) Qent (reporter) 2012-09-27 04:15 edited on: 2012-09-27 04:18 |
Make a post containing the phrase "limit 1, limit 2, fin" and then refresh the page. The actual post was'http://zandronum.com/forum/showthread.php?tid=1167&pid=14583#pid14583 [^]'Quote Test thread:'http://zandronum.com/forum/showthread.php?tid=1175 [^]' |
(0004828) Blzut3 (administrator) 2012-09-27 18:32 |
'http://dev.mybb.com/issues/2110 [^]' I don't think I can fully fix the issue, but I changed the regex so that it's more difficult to trigger. "LIMIT ([0-9]+),(?:[ ]+)?([0-9]+)" In other words to trigger now you need the word "limit" followed by a space, followed by a number, followed by a comma, followed by optionally any number of spaces, followed by another number. Before "limit <number>, " was enough. |
(0004897) Qent (reporter) 2012-10-01 15:57 |
Thanks. Is there some feature that it's backing, that would be useful to know about? |
(0004904) Blzut3 (administrator) 2012-10-01 21:37 |
What do you mean? All forum database queries pass through that regular expression, so just avoid the phrase "limit number, number" and it should be fine. |
(0005047) Qent (reporter) 2012-10-07 23:56 |
What I mean is, is there something useful that we would want to use "limit number, number" for? |
(0005052) Blzut3 (administrator) 2012-10-08 18:10 |
No. That's why I'm telling you to avoid the phrase. It will trigger the bug on the forums as before. The only difference is it's restricted only to that specific phrase now. |
(0007285) Dusk (reporter) 2013-09-27 10:59 |
This was fixed in 1.6.11 and was closed a month ago. |
(0007296) Blzut3 (administrator) 2013-09-29 05:16 |
Right, although if there hasn't been any one triggering my version of the fix. I don't really see a reason to back port the official fix until 1.6.11 comes out. |
(0014595) Dark-Assassin (administrator) 2016-03-20 16:14 |
The forum software change invalidated this issue. It can now be closed. This seemes to have been fixed anyway. |
This issue is already marked as resolved. If you feel that is not the case, please reopen it and explain why. |
|
Supporters: | No one explicitly supports this issue yet. |
Opponents: | No one explicitly opposes this issue yet. |
Issue History | |||
Date Modified | Username | Field | Change |
2012-09-26 15:13 | Qent | New Issue | |
2012-09-27 01:09 | Blzut3 | Note Added: 0004820 | |
2012-09-27 04:15 | Qent | Note Added: 0004824 | |
2012-09-27 04:16 | Qent | Note Edited: 0004824 | View Revisions |
2012-09-27 04:18 | Qent | Note Edited: 0004824 | View Revisions |
2012-09-27 18:32 | Blzut3 | Note Added: 0004828 | |
2012-09-27 18:33 | Blzut3 | Assigned To | => Blzut3 |
2012-09-27 18:33 | Blzut3 | Status | new => acknowledged |
2012-10-01 15:57 | Qent | Note Added: 0004897 | |
2012-10-01 21:37 | Blzut3 | Note Added: 0004904 | |
2012-10-07 23:56 | Qent | Note Added: 0005047 | |
2012-10-08 18:10 | Blzut3 | Note Added: 0005052 | |
2013-09-27 10:59 | Dusk | Note Added: 0007285 | |
2013-09-29 05:16 | Blzut3 | Note Added: 0007296 | |
2016-03-20 16:14 | Dark-Assassin | Note Added: 0014595 | |
2016-03-20 19:44 | Blzut3 | Status | acknowledged => resolved |
2016-03-20 19:44 | Blzut3 | Resolution | open => no change required |
2018-12-01 06:46 | Blzut3 | Status | resolved => closed |
Copyright © 2000 - 2024 MantisBT Team |