Hi, my piwigo site was infected long time ago (can't remember the name of the plugin) and after that appears in the eyes of Google as related to sales of cialis, -//:---\spam and other sh**.
I believe that just because of that I can't get any search traffic as google most probably think that the site is infected.
I keep seeing charts like this in search console, just the names of drugs change all the time:
ok, so today it is some "metronidazole 400mg"
went to google and run this search to check it and voila:
but, when you go into source code - the meds are not there at all.. the site seems to be clean:
and
---------
yes, I love piwigo and few of my loyal users are used to it as well, but I will most definitely move over to a different place if I am unable to clean up the site.. I have posted my issue couple of times before, but the problem stays unsolved.
Please help me to stay with piwigo.. :/
Thank you
Helmuts
Piwigo version: 2.8.2
PHP version: 5.5.38
MySQL version: 5.6.31
Piwigo URL: http://www.artforweb.co.uk
Offline
hmm.. finally I know where to look into :)
posted a similar thread at reddit and the people over there actually told me where to look into: https://www.reddit.com/r/bigseo/comment … ghts_on_a/
--------
Helmuts
Offline
scanned db after the kw "metronidazole" and found following thing:
then:
details:
SELECT * FROM `information_schema`.`PROCESSLIST` WHERE ( CONVERT( `ID` USING utf8 ) LIKE '%metronidazole%' OR CONVERT( `USER` USING utf8 ) LIKE '%metronidazole%' OR CONVERT( `HOST` USING utf8 ) LIKE '%metronidazole%' OR CONVERT( `DB` USING utf8 ) LIKE '%metronidazole%' OR CONVERT( `COMMAND` USING utf8 ) LIKE '%metronidazole%' OR CONVERT( `TIME` USING utf8 ) LIKE '%metronidazole%' OR CONVERT( `STATE` USING utf8 ) LIKE '%metronidazole%' OR CONVERT( `INFO` USING utf8 ) LIKE '%metronidazole%' ) LIMIT 0 , 30
-----------
dear piwigo developers > what could you suggest me?
huge thank you in advance,
Helmuts
Last edited by helmuc (2016-08-16 22:06:55)
Offline
can anybody from the support comment here, please? thank you.
.. even 2 lines will do the job.
H
Offline
Uhm, the information_schema.processlist table lists mysql processes.
So, if you execute a query you will find it in the processlist, of course.
That means: your search on "metronidazole" executes a select on processlist, which just finds itself.
As long the result is 1 and the only match is in the information_schema.processlist, it didn't find any match in any table. All is good.
Offline
I checked the google results for your site. There are some URIs like "/index.php?p=inderal-5mg" that directly redirect to some online pharmacy. And it's still working.
It "looks" like Piwigo's index.php is doing the redirect, but I suspect this to be more like a .htaccess hack.
Please check for a .htaccess file in your Piwigo installation folder.
Check your webserver access logs for GET requests on php files that are not part of the Piwigo installation.
Some notes on such redirect hacks: https://aw-snap.info/articles/redirects.php
Last edited by teekay (2016-08-19 10:32:47)
Offline
teekay wrote:
I checked the google results for your site. There are some URIs like "/index.php?p=inderal-5mg" that directly redirect to some online pharmacy. And it's still working.
It "looks" like Piwigo's index.php is doing the redirect, but I suspect this to be more like a .htaccess hack.
Please check for a .htaccess file in your Piwigo installation folder.
Check your webserver access logs for GET requests on php files that are not part of the Piwigo installation.
Some notes on such redirect hacks: https://aw-snap.info/articles/redirects.php
Thank you - will check that. Helmuts
Offline