Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to renew my OSM Foundation membership (“Payment Processor Error message :DB Error: unknown error”) #973

Closed
amandasaurus opened this issue Oct 9, 2023 · 14 comments

Comments

@amandasaurus
Copy link

amandasaurus commented Oct 9, 2023

The autorenew of my OSMF membership didn't work (probably because I got a new credit card a few months ago after being pickpocketed). So I clicked on the link, and tried to fill in the form, and got: “Payment Processor Error message :DB Error: unknown error”

image

I tried to sign up new at https://supporting.openstreetmap.org/normal-membership/ and got the same error:

image

I posted this on the #osmf-membership IRC channel on 2023-10-07, and emailed MWG on 2023-10-09, and also chatted to @Firefishy on IRC that day. He thinks #972 might be relevant too.

@Firefishy
Copy link
Member

Have you retried since then?

@amandasaurus
Copy link
Author

amandasaurus commented Oct 9, 2023 via email

@Firefishy
Copy link
Member

@grischard Assigning this one to you. Let me know if you'd like me to investigate.

@amandasaurus
Copy link
Author

Same thing happened today when trying to sign up for active contributor membership

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error

Return to home page.

Screenshot 2023-10-10 at 09-09-40 Return – OpenStreetMap Foundation

@amandasaurus
Copy link
Author

amandasaurus commented Oct 10, 2023

I changed my OSM username and got it to work. Through trial and error, I could reproduce the error when I had a 🏳️‍🌈 character at the end of my username. The Ogham letters (…ᚐᚋᚐᚅᚇᚐ…) are not a problem.

I was able to crash the civicrm OSMF membership system by changing my OSM username. That's not good.

@Firefishy
Copy link
Member

Firefishy commented Oct 10, 2023

Likely a mysql utf8 issue then. 🏳️‍🌈 flag is 4 characters and 14 bytes. By default mysql utf8 only supports I believe 3 character. Needs further investigation.

@Firefishy
Copy link
Member

Firefishy commented Oct 10, 2023

Confirmed our civicrm uses utf8mb3_unicode_ci and not the mb4 version, looks like there may be a process to convert to mb4. @grischard

@tomhughes
Copy link
Member

It's basically homophobia. 😜 /s

I don't care if you added a smiley - that comment is totally inappropriate.

That comment is the first indication that the problem has anything to do with your username and without giving anybody a chance to address what is fairly obviously a bug you essentially imply that is a deliberate act of discrimination.

@grischard
Copy link
Collaborator

Confirmed our civicrm uses utf8mb3_unicode_ci and not the mb4 version, looks like there may be a process to convert to mb4. @grischard

Running the upgrade process.

@amandasaurus
Copy link
Author

amandasaurus commented Oct 10, 2023 via email

@grischard
Copy link
Collaborator

MySQL upgrade done.

@grischard
Copy link
Collaborator

@amandasaurus lmk if this can be closed

@amandasaurus
Copy link
Author

amandasaurus commented Oct 10, 2023 via email

@Firefishy
Copy link
Member

I am going to close this now. If the issue remains we can re-open.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants