OGSteam

Discussions => Support et Questions => Discussion démarrée par: Artafak le 26 mars 2020, 19:23:28

Titre: Erreur MAJ avec SuperApiX
Posté par: Artafak le 26 mars 2020, 19:23:28
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
Titre: Re : Erreur MAJ avec SuperApiX
Posté par: DarkNoon le 27 mars 2020, 21:16:25
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,
Titre: Re : Erreur MAJ avec SuperApiX
Posté par: machine le 28 mars 2020, 07:59:14
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
Titre: Re : Erreur MAJ avec SuperApiX
Posté par: Artafak le 25 avril 2020, 21:45:45
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,