SERP Hacker support forum - serposcope

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)

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.

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.