MySQL username/password error. Not sure what to do. about categorysuggest HOT 11 CLOSED

mysql_real_escape_string() should work if you already have a MySQL database connection open, if not it will try to create a default one. See the $link_identifier argument at http://php.net/manual/en/function.mysql-real-escape-string.php . Are you running MediaWiki with MySQL or are you using a different database?

from categorysuggest.

Yes, running with MySQL, and it appears to be working otherwise (I can edit a page).

Anything I can help with to debug this? Actually it's public right now if you want to pound on it yourself: http://gbit.com.au/mw/Main_Page The only interesting thing I can think of about my installation is that I installed MediaWiki via Cpanel (i.e. not manually).

from categorysuggest.

Any ideas?

from categorysuggest.

I'm getting the same error message. Running Mediawiki 1.23.2 with PHP 5.5.9 and MySQL 5.5.38.

from categorysuggest.

You should verify the //CONFIGURE WITH YOUR LOCAL CREDENTIALS in CategorySuggestSuggest.php is correct.

from categorysuggest.

I just update it with the correct credentials and it still doesn't work. Getting the same error.

I have it running on another wiki server with MW 1.22 and PHP 5.3 and it works without putting in any credential info.

from categorysuggest.

@defconzx Did you get this resolved?

from categorysuggest.

If anyone is still having this issue, I was able to fix it on my own wiki by moving

$dbr =& wfGetDB( DB_SLAVE );

One line above

$searchString = mysql_real_escape_string($query);

So that the final will look like this:

$dbr =& wfGetDB( DB_SLAVE );
$searchString = mysql_real_escape_string($query);

I hope this works for you too.

from categorysuggest.

This didn't get resolved. Tried rajeltomari suggestion and it doesn't work either.

from categorysuggest.

I actually switch to using msCatSuggest which actually works better in my case:

http://www.mediawiki.org/wiki/Extension:MsCatSelect

from categorysuggest.

Confirmed that this has fixed the issue. Thanks alot!

from categorysuggest.