jkadin Posted March 13, 2011 Share Posted March 13, 2011 Sorry, but this is a copy/paste from another site, thought it would be helpful here. Support Request Template What version of phpBB are you using? phpBB 3.0.7-PL1 What is your board's URL? http://asersmia.com/twenty-thirteen Who do you host your board with? webhostingpad.com How did you install your board? I used a tool provided by my host Is your board a fresh install or a conversion? Fresh Install Do you have any MODs installed? Yes Is registration required to reproduce this issue? Yes What MODs do you have installed? profile comments blogs mchat What styles do you currently have installed? dark grunge/custom/prosilver What language(s) is your board currently using? english Which database type/version are you using? MySQL 5 What is your level of experience? Comfortable with PHP and phpBB What username can be used to view this issue? n/a What password can be used to view this issue? n/a When did your problem begin? Just a few days ago. My hosting provider will not do squat about it, even though I did nothing to the database to cause this issue. Please describe your problem. it is a problem that has suddenly developed in the mysql database. I have several members that have previously registered with a " ' " (apostrophe special symbol) in their name. No problem for nearly a YEAR till just a few days ago, when the server was being sluggish yet again ( NOTE: DO NOT HOST WITH WEBHOSTINGPAD.COM as this is not an isolated incident with their server messing up a database). Now, people who have registered names cannot log in, they get a 404 not found error. Additionally, I cannot change their name to something without a ' in it through ACP, I get the same error... 404. I have to go into the DB to change it there and then I can pull up their name. And finally, when someone tries to register with a ' in their name like O'Brady, for instance, it will throw the same error. Has anyone seen this, and if so, how can it be resolved? Generated by SRT Generator ($Rev: 4778 $) Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted March 13, 2011 Share Posted March 13, 2011 So what's your question, exactly? Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 13, 2011 Author Share Posted March 13, 2011 Here it is again, hope this helps: I have a problem that has suddenly developed in the mysql database. I have several members that have previously registered with a " ' " (apostrophe special symbol) in their name. No problem for nearly a YEAR till just a few days ago, when the server was being sluggish yet again ( NOTE: DO NOT HOST WITH WEBHOSTINGPAD.COM as this is not an isolated incident with their server messing up a database... I had a bunch of standard accounts suddenly turned to MODERATORS when their server flipped out last time). Now, people who have registered names with the special character apostrophe (Like "O'Malley" or something like that) cannot log in, they get a 404 not found error. Additionally, I cannot change their name to something without a ' in it through ACP, I get the same error... 404. I have to go into the DB to change it there and then I can pull up their name. And finally, when someone tries to register with a ' in their name like O'Brady, for instance, it will throw the same error. Has anyone seen this, and if so, how can it be resolved if at all? Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted March 13, 2011 Share Posted March 13, 2011 When you view the data in the database directly, are there backslashes in it? Is magic_quotes_gpc() set to on in your php.ini file? How are you escaping the data when it's inserted into the database to begin with? Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 14, 2011 Author Share Posted March 14, 2011 I am viewing through PHP Admin. You will have to forgive me. I am just a beginner. There are no backslashes when I go in and look at the tables in PHP MyAdmin. And I will look in the php.ini file, but I am not sure where that is located. Will have a look around and let you know. Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 14, 2011 Author Share Posted March 14, 2011 yeah, no luck in finding the file. I am so clueless, but I will try to make this painless for you, and I really really appreciate the help. So, steer me in the right direction, please? Thank you. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted March 14, 2011 Share Posted March 14, 2011 First, let's find out if magic quotes is on or not. Create a new script and in it put the following code, then upload it and browse to its url. <?php phpinfo(); ?> Then find the magic quotes values in the list of values it returns, and post those values (should be three different magic_quotes_* value sets). Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 14, 2011 Author Share Posted March 14, 2011 name this as "newscript.ini" or something else? I totally understand the rest of your instructions, though. Again, clueless. I'm more of a designer. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted March 14, 2011 Share Posted March 14, 2011 Name it anything that doesn't already exist. phpinfo.php would probably be just fine. Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 15, 2011 Author Share Posted March 15, 2011 magic_quotes_gpc Off Off magic_quotes_runtime Off Off magic_quotes_sybase Off Off All off. How might I turn them on? Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted March 15, 2011 Share Posted March 15, 2011 You don't want them on, they're evil. So now that we've figured that out, let's have a look at the scripts that are having the problems, and the one that does the user registration database insert. Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 15, 2011 Author Share Posted March 15, 2011 Ok so, what would you need from me? Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted March 15, 2011 Share Posted March 15, 2011 You'd need to post the code for those scripts so we can try to rule out any coding issues that may contribute to the problem. Remove any usernames/passwords, of course. Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 15, 2011 Author Share Posted March 15, 2011 Ok I don't know what particular scripts they are. But it's not only limited to new users. It's all users with ' in their user name that try to log in and get the error. And now I have one user, across all of her accounts that when she tries to make a post in a thread using any special characters at all, and it throws the same message. I do not know how to find scripts on the server, and what scripts do what. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted March 15, 2011 Share Posted March 15, 2011 Well, that's a problem then. It's going to be impossible to solve this without seeing the code that is exhibiting the problem. All anyone would be able to do is guess, and that's not a great way to fix anything. Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 15, 2011 Author Share Posted March 15, 2011 Would you private message me? I am willing to pay you or someone to fix this. Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 15, 2011 Author Share Posted March 15, 2011 OK maybe that was a stupid question. I mean, I can attempt to puzzle out what exactly a 'script' is. is it the .php files themselves or the tables that I see in phpmyadmin. If someone could kindly point me in the right direction, it would be greatly appreciated. I think I can work things out, and try to post some 'scripts' for you. Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 16, 2011 Author Share Posted March 16, 2011 Problem was with my host's mod_security blocking anything with an apostrophe/special character in it. Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted March 16, 2011 Share Posted March 16, 2011 Problem was with my host's mod_security blocking anything with an apostrophe/special character in it. Move to a better host. That's a stupid way of being "secure". Ken Quote Link to comment Share on other sites More sharing options...
jkadin Posted March 16, 2011 Author Share Posted March 16, 2011 That's what I'm gonna do. Once I figure out how to move the forum I run over, too. I panic when I look at MySql! PS, this is a constant issue with them, Webhostingpad. Their servers are just crappy! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.