De multiples erreurs depuis la migration vers la version 4.5 [Réglé]
Elles ont été signalées dans un rapport de bugs, que vous avez rejeté
Support Général
sch Membre non connecté
-
Booster Fusée
- Voir le profil du membre sch
- Inscrit le : 28/09/2010
- Site internet
- Groupes :
Depuis la version 4.5, le raport d'erreurs de mon site s'est bien rempli, au point que je ne peux plus le mettre à jour. Je me fais déconnecté en permanence. Et la, Janus, ce n'est pas Hosteur, car le déploiement est tout neuf, et les mêmes erreurs ont déjà été signalés dans ce rapport de bug, à moins que le site soit lui aussi hébergé chez hosteur.
Voilà le paquet d'erreur. Un festival ! Je viens de le découvrir, car j'étais à l'étranger.
ERREURS
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '2' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 11:49:05
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '5' AND g.aprob = 1
ORDER BY note.average_notes ASC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 08:16:55
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '6' AND g.aprob = 1
ORDER BY note.average_notes ASC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 06:03:22
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '2' AND g.aprob = 1
ORDER BY note.average_notes ASC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-05 11:11:01
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '6' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-05 09:16:22
De quoi cela vient-il ?
Cordialement.
j1.seth Membre non connecté
-
Administrateur
- Voir le profil du membre j1.seth
- Inscrit le : 01/09/2008
- Site internet
- Groupes :
-
Chef de Projet
-
Equipe Développement
Ce bug a été rejeté car il a été signalé en doublon. Il est corrigé pour la prochaine version.
La correction est quand à elle indiquée dans les commentaires du bug en question...
sch Membre non connecté
-
Booster Fusée
- Voir le profil du membre sch
- Inscrit le : 28/09/2010
- Site internet
- Groupes :
Autant pour moi, je n'avais pas vu qu'il était en double. D'où la raison, compréhensible du coup, pour laquelle il a été rejeté.
J'ai donc tenté de corriger à partir du rapport de bug, et j'ai deux souci :
le premier, quand je vais ici, j'ai cette erreur :
ERREUR
http://www.pornicradio.com/gallery/gallery-6+pas-de-printemps-sans-ailes.php
Error 503 Service Unavailable
Votre site renvoie une erreur, cela peut provenir d�77777742�77777600�77777631un temps de chargement trop long ou bien votre page retourne un encodage (type
MIME) incorrect
Service Unavailable
Error 503
Guru Meditation:
XID: 764887688
Puis le second, quand je vais dans mon rapport d'erreurs, j'ai ceci :
ERREURS
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '17' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 17:09:31
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '6' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 17:08:17
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '17' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 17:07:45
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '18' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 17:06:57
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '4' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 17:06:40
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '6' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 17:06:17
Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob,
g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'
LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1
WHERE g.idcat = '2' AND g.aprob = 1
ORDER BY note.average_notes DESC
LIMIT 16 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)
[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)
[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)
[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)
[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()
[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()
2013-08-06 17:03:33
Est-ce que quelqu'un aurrait le fichier corrigé, au cas où je ferais une erreur ?
Cordialement.
j1.seth Membre non connecté
-
Administrateur
- Voir le profil du membre j1.seth
- Inscrit le : 01/09/2008
- Site internet
- Groupes :
-
Chef de Projet
-
Equipe Développement
https://phpboost.googlecode.com/hg-history/4331b3388a1be4189aa541d7d2dcd02cd1a1e614/gallery/phpboost/GalleryHomePageExtensionPoint.class.php
sch Membre non connecté
-
Booster Fusée
- Voir le profil du membre sch
- Inscrit le : 28/09/2010
- Site internet
- Groupes :
Merci bien.
Cordialement.
Répondre
Vous n'êtes pas autorisé à écrire dans cette catégorie