Reattribute Post Function - Possible Bug with Apostrophes

[jkdove]

I found one other topic with this, though it was unresolved and not helpful in slightest.   

http://www.simplemachines.org/community/index.php?topic=360378.0

I have used this function with great success.  It is hands down one of my favorite features of 2.0.   I have discovered what I believe is a bug in it though and I'd like to see if anyone else can confirm it and possibly work toward a solution.

I have used it primarily to attach old posts made by deleted users to new accounts.   It works for All the names I've used it on EXCEPT those deleted guest accounts with apostrophes in the name, regardless of position in the name, be it in the middle of the name or at the end of the name. 

Can anyone verify or have a solution?

[jkdove]

I searched for a rule about bumping a thread, but nothing comes up on search.   So, here I am, bumping this thread as it has fallen back to page 4.    Fishing expedition...hope I catch a biggun.

[Kill Em All]

Sorry for not getting to this jkdove.

Have you done this on SMF 2.0 RC3? With no mods?

btw, there is a 24 hour limit till you can bump. You are fine.

[jkdove]

Thank you so much, Kill.   I can't believe I didn't post my version, my bad for that.  Yes, I'm  using RC3 and a boatload of mods.    I have NOT attempted to "Reattribute" on a clean installation of RC3 without modifications.    (And thank you for the bump rule )


My Mod list, just in case:

1.      Personal Messages to Membergroups    1.4.1     
2.   Copy Topics    1.6     
3.   Current Signature Mod    1.1     
4.   Users Online Today    1.5.6     
5.   Post PM    1.0     
6.   Book of Unknown Action    1.0     
7.   Aeva Media    1.2     
8.   [user] BBC Tag    1.0.1     
9.   Move Old Topics    1.3.6     
10.   Aeva Media    1.1b   
11.   Treasury    2.06   
12.   Board Notices    1.0.1     
13.   Active Members In Topic    1.8     
14.   Custom Form Mod    1.6     
15.   Dice Roller BBcode    1.3     
16.   Export Personal Messages    1.3.2     
17.   Spoiler Tag    0.7.2     
18.   Curve_centered_menu    1.1     
19.   Post_Board_Select    1.2     
20.   Board and Topic BBC    1.0     
21.   PM Attachments    1.5 
22.   Topic Note    0.6     
23.   Boilerplates for posts    2.0.3     
24.   Team Page    3.5.5     
25.   Birthday Posts    0.12.1 Beta     
26.   Back to Top    1.1     
27.   Search Focus Dropdown    1.44     
28.   Countdown BBCode    1.3     
29.   Hide Edited Line    1.0.0 
30.   Admin Notepad    2.0.1     
31.   Justify BBCode    2.3.1     
32.   New Topic Button    1.0     
33.   ROT13 BBcode    1.1     
34.   Last Post On MemberList    1.02     
35.   Define BBC    1.0     
36.   Favicon    1.3     (yes, I know this wasn't necessary...discovered that after installation)
37.   Last Active On MemberList    1.03     
38.   Welcome Topic Mod

[smp420]

I tried to test this but I can't even register a name with an apostrophe I get "Invalid character used in Username."

[Kill Em All]

Same. ' is not allowed in a username in SMF.

[jkdove]

Thanks a bunch.     Next question:   Would this be considered a "bug" or just a...hell I don't know actually, a rule?     In other words, should I submit this to the bug board?

[Kill Em All]

Well considering you have close to 40 mods, I would assume one of them is causing the problem. And it isn't a bug in a clean version of SMF.

[jkdove]

Bear with me here, Kill:

You stated that

' is not allowed in a username in SMF.

I have to (safely?) assume you tested this on a clean version, so my site and its mods wouldn't have anything to do with it, right?   Obviously, I'm missing something, I just want to be sure I'm understanding this correctly before I ask anymore questions.     

[Kill Em All]

No problem.

And yes, I have tested this on a clean install. It is like that in 1.1.x to. This is probably a problem with one of your mods. If you want, you can create a SMF install in a new directory of your website and install each mod one by one and testing the functionality to see which mod breaks it.

[jkdove]

  I feel like I'm going a little insane here...

What would I be testing if the apostrophe character isn't allowed in the first place?

[Kill Em All]

Well, apparently it works on your forum for some reason. So you would be testing which mod of yours is causing this to happen. Thus, then getting rid of that mod on your live website and fixing your problem.

[jkdove]

Man, I'm slipping in my old age.    I should have explained the whole scenario instead of leaving you to guess my set up.      My bad for that.   I think this explanation will go a very long way toward this making sense.

The original database, and thus the account in question with the apostrophe, was originally created with a very old Invision Power Board (the version number of the IPB board is forever lost to history).   It was then converted to SMF 1.1.3 (and eventually upgraded to 1.1.11) and the account in question was deleted.   The database was then later converted to SMF 2.0 RC3.     


Having written that out, combined with what you've told me here, it seems that there likely isn't a solution to this issue as SMF does not allow the apostrophe character to begin with.    I'll try editing the the database itself at the source to remove that character.   I'll update when I have it isolated and removed then mark this thread as resolved.

Thanks again.  While I may not have made it entirely easy to figure out, having someone else give input did indeed help.   

[Kill Em All]

Ah, that would make sense.

Good luck with your journey to isolate the problem, I hope you can find it.

[jkdove]

well, after searching the whole database, I can only find the name in question in the various "search" tables.    I find it very difficult to believe that those tables are the only place it exists as I can see the name clear as day on the old posts made by deleted accounts.  Simple logic dictates that the name MUST listed somewhere else,  but after downloading the entire database and doing a "find" using Notepad++, I'm still coming up empty.         

Doesn't make a lick of sense to me whatsoever.      If anyone has a clue, please let me know.    Short of an answer to this most curious and frustrating of mysteries, I'm nearly ready to mark this as solved as there are no other answers to receive.   

[jkdove]

Closing this thread out.  No solution found my own issue found,  however, it does not pertain to SMF per se. 

Simply put, Apostrophes are now allowed in SMF.

thanks again for the help

[excaliburj]

well, after searching the whole database, I can only find the name in question in the various "search" tables.    I find it very difficult to believe that those tables are the only place it exists as I can see the name clear as day on the old posts made by deleted accounts.  Simple logic dictates that the name MUST listed somewhere else,  but after downloading the entire database and doing a "find" using Notepad++, I'm still coming up empty.         

Doesn't make a lick of sense to me whatsoever.      If anyone has a clue, please let me know.    Short of an answer to this most curious and frustrating of mysteries, I'm nearly ready to mark this as solved as there are no other answers to receive.   

If it's being displayed as an apostrophe (single quote), it may well be stored using the HTML code for it:

Code Select Expand

'

So you could search forever for "Bill's Login" and not find it because that is what would be displayed for:

Code Select Expand

Bill's Login

(even has to be put in code blocks here, or it's converted to single quote).

[smp420]

I can register using

Code Select Expand

' rather than an apostrophe, maybe try that when reattributing posts.

[jkdove]

excaliburj -   Excellent work...that did the trick

smp420 -  You are correct.


I was able to successfully reattribute using

Code Select Expand

'

in the older name.     

Topic/Issue is 100% solved.