Bonjour à tous,
j'ai remarqué que depuis le 10 Mars, le serveur OGSpy de mon alliance ne se mettait plus correctement à jour.
J'ai donc d'abord vérifié que les modules étaient tous à jour (ce qui n'était pas le cas).
La mise à jour des modules s'est passée sans erreur ni problème.
Ensuite, direction Superapix pour faire une mise à jour manuelle.
Et là, c'est le drame... Une erreur se produit
(https://zupimages.net/up/20/13/jaq9.png)
J'ai donc essayé de désinstaller le module superapix, puis de le réinstaller.
Aucun changement.
Est-ce que quelqu'un a le même problème ?
Concernant les paramètres de superapix :
n° d'univers : 160
Nombre de requètes max : 500
pays : fr
mode développeur : non
Options xtense callbacks : tout à "oui"
versions des modules installés :
(https://zupimages.net/up/20/13/c9pa.png)
Merci pour l'aide que vous pourrez m'apporter à la résolution de ce problème.
Et bonne soirée
Hello,
Quelle était la première version de cet OGSpy si tu t'en souviens ?
As tu d'autres erreur si tu actives le log SQL et php dans le panneau d'administration ?
Merci,
Bonjour Artafak,
merci de ton retour.
Peux tu nous préciser les versions ogspy et superapix.
A l'occasion, tu peux activer le mod debug, (ainsi que l'activation des erreurs PHP dans l'administration OGSPY), tu auras dans le journal des element intéressants à nous fournir.
Par avance merci
Bonjour messieurs,
merci pour vos réponses.
Suivant vos consignes, j'ai donc activé l'affichage des erreurs dans les logs (menu Administration/paramètres du serveur -> Enregistrement des erreurs PHP)
En voici un extrait :
25/04/2020 21:23:06 : [admin] kaamelott modifie les paramètres du serveur
[0] =>
fonction => traitement_universe
ligne => 94
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/cron.php
[2]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => sql_query
ligne => 321
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/include/function.php
[1]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => DieSQLError
ligne => 138
file => /srv/www/ogspy.fr/kaamelott/includes/mysql.php
[0]
25/04/2020 21:21:51 : Erreur critique mysql - Req : UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate - Erreur n°1054 Unknown column 'U.player_id' in 'field list'
25/04/2020 21:21:04 : kaamelott se connecte
[0] =>
fonction => traitement_universe
ligne => 94
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/cron.php
[2]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => sql_query
ligne => 321
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/include/function.php
[1]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => DieSQLError
ligne => 138
file => /srv/www/ogspy.fr/kaamelott/includes/mysql.php
[0]
25/04/2020 20:53:26 : Erreur critique mysql - Req : UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate - Erreur n°1054 Unknown column 'U.player_id' in 'field list'
[0] =>
fonction => traitement_universe
ligne => 94
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/cron.php
[2]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => sql_query
ligne => 321
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/include/function.php
[1]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => DieSQLError
ligne => 138
file => /srv/www/ogspy.fr/kaamelott/includes/mysql.php
[0]
25/04/2020 20:52:09 : Erreur critique mysql - Req : UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate - Erreur n°1054 Unknown column 'U.player_id' in 'field list'
[0] =>
fonction => traitement_universe
ligne => 94
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/cron.php
[2]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => sql_query
ligne => 321
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/include/function.php
[1]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => DieSQLError
ligne => 138
file => /srv/www/ogspy.fr/kaamelott/includes/mysql.php
[0]
25/04/2020 20:52:01 : Erreur critique mysql - Req : UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate - Erreur n°1054 Unknown column 'U.player_id' in 'field list'
[0] =>
fonction => traitement_universe
ligne => 94
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/cron.php
[2]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => sql_query
ligne => 321
file => /srv/www/ogspy.fr/kaamelott/mod/superapix/include/function.php
[1]
[0] => UPDATE ogspy_universe as U INNER JOIN ogspy_superapix_universe as T ON ( U.galaxy = T.g AND U.row = T.r AND U.system = T.s ) INNER JOIN ogspy_superapix_players as P ON ( T.id_player = P.id_player ) INNER JOIN ogspy_superapix_alliances as A ON ( A.id_alliance = P.id_ally ) SET U.player_id = T.id_player , U.ally_id = P.id_ally , U.moon = T.moon , U.name = T.name_planete , U.ally = A.tag , U.player = P.name_player , U.status = P.status , U.last_update = T.datadate , U.last_update_user_id = T.sender_id WHERE U.last_update <= T.datadate
fonction => DieSQLError
ligne => 138
file => /srv/www/ogspy.fr/kaamelott/includes/mysql.php
[0]
La totalité du fichier log du jour, disponible ici : https://www.transfernow.net/xGV8dC042020 (https://www.transfernow.net/xGV8dC042020)
De ce que je vois, la ligne Erreur n°1054 Unknown column 'U.player_id' in 'field list'
est la plus importante. Il y a un problème de colonne dans la table SQL
Je ne me souviens pas précisément de la version précédente de l'OGSPY, mais vu qu'il n'avait pas été mis à jour depuis son installation en Avril 2019... soit environ 1 an.
Les versions actuelles des modules et de l'OGSPY :
superapix (0.3.3)
OGspy 3.3.7
Les autres versions, ici :
(https://nsa40.casimages.com/img/2020/04/25/mini_200425094741805676.png) (https://www.casimages.com/i/200425094741805676.png.html)
En cliquant sur SuperApiX, je vois qu'il arrive à mettre à jour une partie des informations, mais l'erreur persiste, et la date finale est toujours en 1970...
(https://nsa40.casimages.com/img/2020/04/25/mini_200425094741309901.png) (https://www.casimages.com/i/200425094741309901.png.html)
J'ai vu que SuperAPIx a une mise à jour en attente... Je le mets à jour ?
Merci pour votre aide
Très cordialement,
Hello
@Artafak Tu pourras essayer la dernière version ?