Erreur MAJ avec SuperApiX

[Artafak]

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



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 :


Merci pour l'aide que vous pourrez m'apporter à la résolution de ce problème.
Et bonne soirée

[DarkNoon]

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,

[machine]

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

[Artafak]

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 :

Code: [Sélectionner]

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

De ce que je vois, la ligne

Code: [Sélectionner]

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 :



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...


J'ai vu que SuperAPIx a une mise à jour en attente... Je le mets à jour ?

Merci pour votre aide

Très cordialement,

[DarkNoon]

Hello @Artafak

Tu pourras essayer la dernière version ?