ouestfrance-multimedia/google-search-console-archive

Search Console Archive store your Search Console (Webmaster Tools) data to exceed the 90 days history in a web SEO tool with search & analysis features.

google-search-console-archive's Issues

خطای 403 (ممنوع)!! 1

https://store.google.com/?playredirect=true

[email protected]

https://github.com/users/DominikStyp/achievements/starstruck

Enhancement Ideas

I really appreciate your tool, merci beacoup. Unfortunately I am not a developer, otherwise I would try to add the enhancements myself.

This is not a Bug but an enhancement request, see attached screenshots.

• The Table shows a maximum of 5000 keywords. I often have more results than are shown. Could you add the possibility to download all the filtered results as a CSV, see attachment?

• Could you add a new box on top of the colum which sums up the total impressions, Clicks, CTR... for the filtered results?

Anyway thank you so much for your work, really love it!

Cheers.

Error 500 calling Google searchAnalytics

Salut !

Merci d'avoir mis ce projet à dispo.

Lorsque j'exécute "cron.php 2016-12-20", le script semble tourner correctement puis au bout d'un moment : PHP Fatal error: Uncaught exception 'Google_Service_Exception' with message 'Error calling POST https://www.googleapis.com/webmasters/v3/sites/http%3A%2F%2Fwww.observatoiredelafranchise.fr/searchAnalytics/query: (500) {
"error": {
"code": 500,
"message": null
}
}
' in /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php:110

Merci par avance,
Patrice

Extrait de la console :

$ php cron.php 2016-12-20
.
....8ob.
o88888888888b.
..o888888888888888b..
888888888888888P""888P
8888888888888888888888.
d88888888888888888888888bc.
o8888888888888888" ""38888Poo..
.8888888888P888888 "38888888
88888888888 8888888eeeeee. ""38"8
P" 888888888 """"" `""o._.oP
8888888888.
88888888888
'888888888 8b.
"88888888b """"3booooooo..
"888888888888888b "b.
"8888888888888888888888b "8
"8888888888888888888888888 b
""888888888888888888888 c
"8888888888888888888 P
"88888888888888888888"
.88888888888888888888
.88888 ><)))°> 88888P Google Console API Query
od888888888888888888P"

Configuration :
Database : root@localhost:3306/google_search_console
Usage : php cron.php $from
$from : days of data history to check from now
Docs : https://developers.google.com/webmaster-tools/v3/searchanalytics/query

Calling Search Console API ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................PHP Fatal error: Uncaught exception 'Google_Service_Exception' with message 'Error calling POST https://www.googleapis.com/webmasters/v3/sites/http%3A%2F%2Fwww.observatoiredelafranchise.fr/searchAnalytics/query: (500) {
"error": {
"code": 500,
"message": null
}
}
' in /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php:110
Stack trace:
#0 /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php(62): Google_Http_REST::decodeHttpResponse(Object(Google_Http_Request), Object(Google_Client))
#1 [internal function]: Google_Http_REST::doExecute(Object(Google_Client), Object(Google_Http_Request))
#2 /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Task/Runner.php(174): call_user_func_array(Array, Array)
#3 /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php(46): Google_Task_Runner->run()
#4 /var/www/local.dev/Google-Search-Console-Arch in /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php on line 110

Fatal error: Uncaught exception 'Google_Service_Exception' with message 'Error calling POST https://www.googleapis.com/webmasters/v3/sites/http%3A%2F%2Fwww.observatoiredelafranchise.fr/searchAnalytics/query: (500) {
"error": {
"code": 500,
"message": null
}
}
' in /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php:110
Stack trace:
#0 /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php(62): Google_Http_REST::decodeHttpResponse(Object(Google_Http_Request), Object(Google_Client))
#1 [internal function]: Google_Http_REST::doExecute(Object(Google_Client), Object(Google_Http_Request))
#2 /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Task/Runner.php(174): call_user_func_array(Array, Array)
#3 /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php(46): Google_Task_Runner->run()
#4 /var/www/local.dev/Google-Search-Console-Arch in /var/www/local.dev/Google-Search-Console-Archive-master/vendor/google/apiclient/src/Google/Http/REST.php on line 110

PHP > Fatal error sur fetch_all()

Bonjour,
En voulant essayer d'installer votre script sur mon environnement je rencontre un problème.
J'ai (normalement) bien suivi toutes les instructions : la connexion à la Search Console se fait sans problème, les données s'insèrent bien dans la BDD, jusqu'ici tout va bien !

Lorsque j'essaie de restituer les données en accédant à /index.php, j'ai en revanche une erreur PHP qui remonte :

Fatal error: Call to undefined method mysqli_result::fetch_all() in /*/models/database.php on line 534

J'utilise pourtant la version 5.6 de PHP, donc il ne devrait pas y avoir de problème de compatibilité, peut-être un problème lié à des types de variables ? Je suis plutôt débutant sur PHP, je vais essayer de creuser de mon côté mais si jamais vous avez la solution cela me serait d'une grande utilité.

Merci par avance,