SMF Support > SMF 2.0.x Support
error message that says mysql_real_escape_string() expects parameter 2....
Quexinos:
--- Quote from: Arantor on February 23, 2011, 08:05:01 AM ---There isn't, since I'm also running just that patch (mind you I made it work on my modified RC3) but the patch is not something that would cause DB errors, it fixes issues in SSI and manage news.
What mods do you have?
--- End quote ---
It's not a mod. Too many people are having this problem with different mods for it to be a mod.
But, here are the mods I'm using anyway:
--- Quote ---1. Advanced Reputation System 1.8.1
2. Simple Spoiler 1.0
3. YouTube BBCode 2.6
4. SMFShop 3.1.6.1
5. SMF Gallery Lite 3.0.2
6. Auto Refresh Who Index 1.0
7. SMF Articles 1.3.3
8. More Spiders 1.2
9. Stop Forum Spam 0.6
10. SMF 2.0 RC4 Security Patch 1.0
11. Regular smileys to dark background smiley set 1.0
--- End quote ---
and to prove a point, here's my error log from this morning. The error happened over 10,000 times in a MINUTE. That's insane... there's no way a mod can do that... at least I hope so :(
Sorry but I'm getting a little frustrated that several of us are having these problems and no one seems to know how to fix it. There has to be someone. :(
Arantor:
--- Quote ---It's not a mod. Too many people are having this problem with different mods for it to be a mod.
--- End quote ---
I disagree. The most common factor previously was high load (since the function in question requires a DB connection), and I was looking for mods that have a high load about them, like Enotify - or other mods that refresh the page...
Actually, yes there are plenty of ways for mods to screw up a forum - a mod is nothing more than raw code inserted at the right point in the source, they can do quite literally anything.
--- Quote ---Sorry but I'm getting a little frustrated that several of us are having these problems and no one seems to know how to fix it. There has to be someone.
--- End quote ---
Gee, thanks for making me feel like I have some idea what I'm talking about. Even the best doctor in the world can't diagnose the illness of a patient he's never seen, with a symptom that on its own makes no sense whatsoever...
I have to say, that error log didn't help, all it did was quote the same error over and over, it doesn't provide any more information on actually nailing down the problem.
FWIW, I have the patch installed as well, and I'm not seeing the problem at all. (I did have a look at the development stages of the patch and I see no reason for it to be triggering based on anything in the patch, not even with the first drafts of it)
So, looking at the error it's actually giving, it's failing because $connection isn't a connection resource but is a boolean. Since that's defined through smf_db_quote in the DB AL... the only reason I can think of is if there's something really weird going on with the DB connection.
So, what version of SMF, what version of PHP, what version of MySQL, and is this error in the forum error log at all (and if so, the full details will be really handy)?
Quexinos:
--- Quote ---I disagree. The most common factor previously was high load (since the function in question requires a DB connection), and I was looking for mods that have a high load about them, like Enotify - or other mods that refresh the page...
--- End quote ---
Well I just meant we all didn't have a mod in common, I know mods can screw things up but wouldn't we all have to have the same one?
--- Quote ---Gee, thanks for making me feel like I have some idea what I'm talking about. Even the best doctor in the world can't diagnose the illness of a patient he's never seen, with a symptom that on its own makes no sense whatsoever...
--- End quote ---
No you're doing fine, I'm sorry. Like I said I'm just frustrated that this has been going on for almost a week and so far no solution or ideas have been given.
--- Quote ---So, what version of SMF, what version of PHP, what version of MySQL, and is this error in the forum error log at all (and if so, the full details will be really handy)?
--- End quote ---
SMF 2.0 RC 4 (with the security patch)
PHP my admin: 3.3.9
MySQL client version: 5.1.52 (is that what you need?)
and I'm not sure what your question means, that's the error log in its entirety if that's what you're asking.
Arantor:
--- Quote ---Well I just meant we all didn't have a mod in common, I know mods can screw things up but wouldn't we all have to have the same one?
--- End quote ---
Well, since no-one other than you bothered to post what mods you had, you may well have a mod in common for all I know...
--- Quote ---Like I said I'm just frustrated that this has been going on for almost a week and so far no solution or ideas have been given.
--- End quote ---
You're not the only one frustrated.
--- Quote ---SMF 2.0 RC 4 (with the security patch)
PHP my admin: 3.3.9
MySQL client version: 5.1.52 (is that what you need?)
--- End quote ---
OK so that tells me what SMF version, and it sort of explains the MySQL version since phpMyAdmin would be complaining bitterly by now if you had a different client version to server version.
But as for PHP version, I need to know what version of the PHP interpreter you're using, which phpMyAdmin doesn't tell you. SMF does, if you can get into the admin panel, in the 'more detailed' link on the right under 'Support Information'.
--- Quote ---that's the error log in its entirety if that's what you're asking.
--- End quote ---
No, that's not what I'm asking for. SMF maintains its own error log in the admin panel. I was hoping the error was logged in there, a little unlikely maybe, but I figured it didn't hurt to give it a go to ask. If it *is* logged in there, there's a chance we can get some more debug information on it.
Quexinos:
--- Quote ---You're not the only one frustrated.
--- End quote ---
You're right, I guess we're all frustrated. I shouldn't be taking it out on you, you're trying to help.
--- Quote ---But as for PHP version, I need to know what version of the PHP interpreter you're using, which phpMyAdmin doesn't tell you. SMF does, if you can get into the admin panel, in the 'more detailed' link on the right under 'Support Information'.
--- End quote ---
Lemme attach a screenshot here...
--- Quote ---No, that's not what I'm asking for. SMF maintains its own error log in the admin panel. I was hoping the error was logged in there, a little unlikely maybe, but I figured it didn't hurt to give it a go to ask. If it *is* logged in there, there's a chance we can get some more debug information on it.
--- End quote ---
I'm afraid I don't see it... but apparently something is wrong with my spoiler mod.
This error comes up a lot:
Apply Filter: Only show the error messages of this URL
http://www.equestriaforums.com/index.php?topic=64.new
Apply Filter: Only show the errors with the same message
8: Undefined variable: user_info
Apply Filter: Only show the errors from this file
File: /home/nepta/public_html/equestriaforums.com/Themes/default/languages/SimpleSpoiler.english.php (main sub template - eval?)
Line: 382
Think that has anything to do with it?
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version