Tripp_UK

+Clients
  • Content count

    636
  • Joined

  • Last visited


4 Followers



About Tripp_UK

  • Rank
    Nobody to see here, move along

IPS Marketplace

  • Resources Contributor Total file submissions: 1

Recent Profile Visitors


6,818 profile views

Tripp_UK's Activity

  1. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    ​Dumb it down? In a few words... Wait for IPS. xP
    In seriousness; you're basically putting Emoji into a field that (in the database) can't support it. Instead of stripping the incompatible character out - it blanks the whole field. 
    DO NOT FOLLOW MY STEPS IN "FIXING IT" because (and I only found this out this morning) it will lockout the other accounts saying it's not in the database. I will look at how a clean install of IPS4 does it and see if I can come up with a working solution, although I don't recommend doing anything until IPS Support tells you to, as I am still learning about all of this stuff myself and just sharing what I find out. At the moment I get the following error "The Display Name you entered does not belong to any account. Make sure that it is typed correctly."
    ​In the converter (the thing we had to run before upgrading) I did select utf8mb4_unicoode_ci. For some reason the converter didn't work properly. I'm going to go out on a limb here and say @Dorian Gray used the UTF8 converter before updating from 3.4.x to 4.0.x which would make sense because we had to. I have no idea if s/he used utf8mb4_unicoode_ci or utf8_unicoode_ci but I know for sure I picked the former, definitely not the latter - because it was conscious decision that had to be debated with my fellow administrators for our site. 
    For example:
    utf8mb4_unicoode_ci: Slower Speed + Emoji Support <--- Which we wanted
    utf8_unicoode_ci: Faster Speed + No Emoji Support
    My guess is for whatever reason the converter failed, and whilst I did make a backup; I did the conversion way before Christmas and I was only told to back up incase it didn't work and after it did work I wouldn't need the backup. If this is a bug that was fixed in the converter that I will need to convert my old database again I'd be rolling back to before September 2014; which is unacceptable, or... I can restart my forums which is outrageously unacceptable. My only choice is to hope that the converter can do it properly or manually change the types and collations myself; or wait and see if IPS can suggest anything better.
    I sort of did this whilst I was waiting, in the hopes that it could help locate and track down where the problem was and what was causing it. I also tried to see in what circumstance would it cause one's account to be deleted; I can't answer that because I don't know. I wasn't able to get an account to be deleted, just their username.
    Edit:
    A fresh install has all tables set to utf8mb4_unicode_ci and the display name table is set to varchar(255) utf8mb4_unicode_ci not blob utf8mb4_unicode_ci which didn't work for me when I played around with it yesterday from a converted one.  I should have known it wasn't that simple. 
  2. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    Okay; yep. It seems to be upgraded installations that it's reproducible on. I wonder if this is why it couldn't be reproduced by staff...

    This happened after setting username to: 🐼A Username
    It still didn't "Delete" the account though, so I suspect (and hope) the account is still there, somewhere, Dorian. I have my fingers crossed for you.
    BUT... I had a look at my database; more specifically Collation's. Take a peak at this noise:

    Now I would like to say Collation doesn't imply causation... xP
    But then I remembered what @Ralf H. said earlier:
    ​An emoji is a 4byte character, right? So I looked into it and found that it was utf8_unicode_ci which I changed to utf8mb4_unicoode_ci. This didn't fix it, and I found that the actual name was also stuck on this collation, so I changed that to utf8mb4_unicoode_ci and all. This didn't work either. But silly me, it's also varchar(255) -> Which I changed to BLOB, (As a type)... Low and behold:

    Fixed it.
  3. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    ​Do they have anything in common like did they all use Facebook/Twitter/Google/Steam or something to sign in? I had a problem like this in the past; it turned out it was a malformed Facebook Connect request or something. I'm just guessing here; but I try to look for something they all have in common between the accounts.
    ---
    Okay, so I just installed a fresh copy of IPS4 as a Dev (Not upgraded 3.4.7) and I can no longer reproduce this:

    Next I will be trying upgrading from 3.4.8 to 4.0.6.1 directly and seeing if I can reproduce it.
  4. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    I find it very curious that IPS couldn't reproduce it yet we could. I'm actually quite interested in testing this out on a fresh installation. =/ I think I will use their downtime over the weekend to do some more tests with it, but I suspect @Ralf H. is absolutely spot on with his assessment. 
  5. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    ​Then your best bet is waiting for IPS, I'm afraid. All the posts should be tied to a User ID not a Display Name. I've asked them in my ticket to give yours priority over mine (I have no idea if that was the plan) purely because your board is live at the moment, where as mine is private and a test.
    The only other thing I can think of (And just tested) is going into the ACP and go to edit a user (doesn't matter which because you just need the URL). If you have the affected account's User ID you can edit the URL so where it says:
    app=core&module=members&controller=members&do=edit&id=XXXyou change XXX to the user ID of the affected account. That way it's all done through the IPS software, like it was done to change it in the first place. You shouldn't need to do anything with the posts but then this bug could be affecting you in a different way. I'd happily look into it for you right now, but I think it's most certainly better to let IPS take a crack at it in all honesty.
  6. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    ​No, neither have I. IPS are generally good for it, but with a lot on their plates it might take them a little time. I wish you the best of luck. 
  7. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    I would imagine you are confused seeing as this missing email (I assume on Update) issue is something else completely, and has nothing to do with this topic =/ 
    Although I fixed mine through PHPMyAdmin too.

    The Red Arrow is pointing to the field that is causing the problems, this just needs a name in it. Nothing else needs to be done. You can search core_members for the members email address and set the username to her username and put "(OLD)" next to it. As I have already said you don't need to remake an account, just edit the one in the database that has no username anymore. If you don't know how to do it, I suggest opening a support ticket to IPS.
    If she's already made a new account, you can simply name the account something else, for a temporary measure and "Merge" the two accounts together, in the ACP. This should merge the two accounts back into one. 

     
    Be very careful here, make sure to read properly as if you do it wrong you will lose track of what you've done. Everything at the end of it should all be back on "A Username (OLD)" and the new "A Username" should be merged with the old one, then it'd just be a simple case of resetting "A Username (OLD)" back to "A Username".
    This will require DB Access for the initial bit, so again, if you are going in there to mess around - Make a Backup of your Database First! If you have literally no idea what I'm talking about (Which I'm starting to suspect) then open a support ticket like many have requested you to do already. =/
    ​Done. Has anyone else got a ticket open about this specific issue? 
  8. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    My guess would be to "Merge" the accounts?
  9. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    Alright, they apparently couldn't reproduce it on their end, which is very strange. I'll go forth and put in a ticket.
  10. Tripp_UK added a post in a topic: Introducing ForumMob! - White label mobile apps for IPB   

    Interesting. I'd love to see how it pans out, so I'll probably test it out with anyone who uses it, as a user first. I appreciate you answering my rather blunt questions. Thank you very much HeadStand. But I'm rather concerned about the fifth point, I meant encoded with IonCube or something like that, and as far as I am aware the stuff on the marketplace isn't... Not usually anyway. Perhaps I should have said "Is the source code of the file we put on our servers, encrypted, or can we view it ourselves?" 
    But cheers... If my site ever gets that popular, I'd definitely consider it, right now though I am not sure I'd be able to afford it. Not saying $30 is a bad price; at all. I assume you get what you pay for, like the app (that we put on the store, if I am getting this correctly) will always be updated as long as we're active clients to suit the iOS or Android version, tech support for it, etc. So I am definitely interested and I think it's a fantastic idea. Perhaps when it's released and I can play around with it as a user (I assume you'll have it set up for ForumMob's forums) I'd definitely like to play with it.
    Then maybe one day I will be able to afford it, or can justify putting it on my site. 
    Thanks again @HeadStand!
  11. Tripp_UK added a bug in Bug Tracker   

    [???] Display Name Issue
    From Thread: http://community.invisionpower.com/topic/414899-so-ipb4-deletes-users-accounts-without-warning/
    Spotted By: @Dorian Gray

    User Changes Display Name to: 🐼A Username
    I confirmed it somewhat, user account isn't deleted but it will not show up in the ACP, and the user wouldn't be able to access the site it would be as if they were deleted; it is still in the MySQL Database, however the person's username is now blank. When I put a username for them in the database by doing a manual edit through PHPMyAdmin it fixed it, the test account was restored and could be accessed again, minus a trouble causing panda. 
    @The Heff suggested it might be due to a limitation; however... Mine was set to unlimited and no, it was completely locked out. So I don't think that's it. That said I don't think I was logged out either, I couldn't access anything and yet there wasn't a "Sign in" or "Register" button. It was more like as if I were banned, and instead of seeing and error message where ever I went, I just saw the registration form where ever I went. 
    Enviroment for me: 
    IPS: 4.0.6 (Upgraded from 3.6.7 -> 4.0.4 -> 4.0.5 -> 4.0.5.1 -> 4.0.6)
    PHP Version: 5.5.29 (Updated since I last posted)
    MySQL Version: 10.0.19-MariaDB
    Collation: utf8mb4_unicode_ci
    HTTPS on everywhere

    Ryan Ashbrook asked for a support ticket (I assume) however I only tested it on a test board, I assume Dorian is running a live site. So it's more appropriate for him/her to submit the support ticket. However if s/he doesn't, please let me know and I'll happily do it.
    • 2 replies
    • 67 views
  12. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    @Ryan Ashbrook: I will get a bug submitted to the tracker. I have submitted a ticket to the bug tracker. As Dorian is offline, I will submit a support request if still required (Although mine was done on a test board, not a live site) where as I assume Dorian is doing it on a live site, thus... Not really appropriate for me to do it.
    @Dorian Gray: I think I'll leave the submitting as a support ticket up to you. It can be fixed with PHPMyAdmin, but you might want to do it through IPS Support like Ryan suggested.
  13. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    Mine was set to unlimited and no, it was completely locked out. So I don't think that's it. That said I don't think I was logged out either, I couldn't access anything and yet there wasn't a "Sign in" or "Register" button. It was more like as if I were banned, and instead of seeing and error message where ever I went, I just saw the registration form where ever I went. 
  14. Tripp_UK added a post in a topic: Introducing ForumMob! - White label mobile apps for IPB   

    $30 a month? That's not much less than I pay for my hosting. Before anyone jumps down my throat for being "entitled" or "Demanding it be free" - try again, I'm not, at least I'm not demanding it to be free. I mean it's a great idea but there are some huge concerns for me.
    Privacy questions. 
    Will this work for HTTPS only sites, and honour that HTTPS?Does any data go through any of your servers? What data do you collect and why?If 2 is yes, then is the data that goes to your servers HTTPS too?Can notifications come up on people's phones?How much of a strain will this put on our servers, or there some kind of "Push" notification thing going on, which leads me back to question 2; if not who's servers are they going through or is it done from our server(s)?This "Server Component" that we need to install, what exactly is it for? Is it encoded or can the file be viewed and verified by us?
  15. Tripp_UK added a post in a topic: So IPB4 deletes users accounts without warning?   

    I can confirm that this happens for me too; I just tested it. It seems it keeps going to the registration form.
    Used: 🐼A Username
    Edit: User account isn't deleted but it will not show up in the ACP, and the user wouldn't be able to access the site it would be as if they were deleted; it is still in the MySQL Database, however the person's username is now blank. When I put a username for them in the database (field: name) and it fixed it, the test account was restored and could be accessed again. @Dorian Gray @Rhett
    Enviroment for me: 
    IPS: 4.0.6 (Upgraded from 3.6.7 -> 4.0.4 -> 4.0.5 -> 4.0.5.1 -> 4.0.6)
    PHP Version: 5.5.21
    MySQL Version: 10.0.19-MariaDB
    Collation: utf8mb4_unicode_ci
    HTTPS on everywhere