Screen goes white HTTP 500 after log in

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Log in
2. Create OP
3. Put an ' in the name of the Op

What is the expected output? What do you see instead?

Expect to have an Op with an ' in it
Instead, HTTP 500, No usage anymore

What version of the product are you using? On what operating system?

Hostet by you

Was this an upgrade or new install?

hostet by you

Please provide any additional information below.

http://miningbuddy.de/ISAF/

You may delete the OP if neccessary, I need no fix if not imminent possible, 
just get it working again. OP name was "Fuu's Plex run' or something.

Original issue reported on code.google.com by fuu.mise...@gmail.com on 10 Feb 2012 at 2:22

[GoogleCodeExporter]

This is actually a customer @ miningbuddy.de hosting

To fix this specific issue I opened the "runs" table in the database and edited 
the specific Op modifying the "location" and removed the invalid ' symbol. 
Alternatively I could of just deleted the run that had the invalid character ' 
in the Op location name.

Please note that this site is hosted from miningbuddy.de and that Mining Buddy 
Plus project is just the provider of the script not the hosting provider just 
to be clear.

If a fix could be made to rather not allow special character in the op name. 
Alternatively fixing the op names to allow special characters would resolve 
this issue as well.

Original comment by AaronWin...@gmail.com on 10 Feb 2012 at 6:37

[GoogleCodeExporter]

I will look at adding some format checking so invalid characters can not be 
entered into the field.

Original comment by miningbu...@thedarth.com on 10 Feb 2012 at 6:42

• Changed state: Accepted

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

preg_replace('/[^a-zA-Z0-9_-]/s', '', $String);

You could add this to the sanitize function, or perhaps specifically on lines 
138 and 148 of addEventToDB.php?

I've just now loaded the code for the first time, so perhaps those locations 
are wrong. But that regex would remove the special characters.

Original comment by jclasp...@wickednewt.com on 5 Jul 2012 at 5:43