SERP Hacker support forum - serposcope

Support forum for open-source softwares built by serphacker.com : serposcope the rank checker.

You are not logged in.

#1 2018-09-18 08:10:41

ronzy
Member
Registered: 2017-12-06
Posts: 5

Some SERPS are stored as NULL in MySQL so rankings are not displayed

Hello,

This is an ongoing issue with Serposcope, requesting someone to please look into it. There are times that SERPS are stored as NULL in the database hence keywords rankings are not shown due to this. This happens once or twice every 10 requests. What could be the issue?

Below are some of the logs:

[2018-09-18 00:02:52,495] [google-6] INFO  c.s.s.s.c.s.RandomCaptchaSolver - anticaptcha failed with NETWORK_ERROR
[2018-09-18 00:02:52,495] [google-6] INFO  c.s.s.s.c.s.RandomCaptchaSolver - all captcha solver failed
[2018-09-18 00:02:52,495] [google-6] ERROR c.s.s.s.g.s.GoogleScraper - solver can't resolve captcha error = NETWORK_ERROR


[2018-09-18 05:04:13,943] [google-10] INFO  c.s.s.s.g.s.GoogleScraper - GOT status=[403] exception=[none]
[2018-09-18 05:04:14,943] [google-10] DEBUG c.s.s.s.g.s.GoogleScraper - GET https://www.google.com/search?q=&gl=in&num=100 via proxy:http://192.126.211.112:3128/ try 2
[2018-09-18 05:04:15,616] [google-10] INFO  c.s.s.s.g.s.GoogleScraper - GOT status=[403] exception=[none]
[2018-09-18 05:04:15,711] [google-15] INFO  c.s.s.t.g.GoogleTaskRunnable - search "shopping" | try 1 | total search done : 7733/15706

Don't know if the above logs can help, but strangely there are few keywords which are successful in logs but not stored in Database

Last edited by ronzy (2018-09-18 08:29:58)

Offline

#2 2018-10-05 08:46:55

serphacker
Administrator
Registered: 2014-06-13
Posts: 411

Re: Some SERPS are stored as NULL in MySQL so rankings are not displayed

Can be due to rate limiting (use more proxy, increase pause, configure all captcha service) or to [this bug](https://github.com/serphacker/serposcope/issues/200) I will fix.

Offline

#3 2018-10-12 05:56:02

ronzy
Member
Registered: 2017-12-06
Posts: 5

Re: Some SERPS are stored as NULL in MySQL so rankings are not displayed

This is fixed now. Thank you so much.

Offline

Board footer