Forum

Bonsoir,

Au relevé des erreurs archivées, ce soir, je trouve ceci :

Je ne sais si ces erreurs viennent de mon serveur ou de PBT.

Cordialement.

Édité par sch Le 26/03/2014 à 22h08

Tu pourrais nous copier l'erreur en entier dans le bugtracker ?

Je ne vois pas le début de l'erreur mais à priori ça correspond au bug #971 qui est déjà corrigé pour la bêta 2

Ok je la recopierai dès qu'elle se reproduira car je l'ai effacée justement pour voir si elle se reproduit à nouveau.

Pour reproduire il suffit d'afficher la page des articles en attente.

Bonjour,

Voici donc, ci-dessous, l'erreur reproduite. Petite précision : quand on clic sur le lien Articles en attente, on a une erreur 404.

 Fatale : invalid query. (ERRNO 1054) Unknown column 'com.number_comments' in 'field list'query: SELECT articles.*, member.*, com.number_comments, notes.number_notes, notes.average_notes, note.note
FROM phpboost_articles articles
LEFT JOIN phpboost_member member ON member.user_id = articles.author_user_id
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = articles.id AND notes.module_name = "articles"
LEFT JOIN phpboost_note note ON note.id_in_module = articles.id AND note.module_name = "articles" AND note.user_id = 1
WHERE articles.published = 0 OR (articles.published = 2 AND (articles.publishing_start_date > 1396003276 OR articles.publishing_end_date < 1396003276)
AND articles.publishing_end_date 0) AND articles.id_category IN ('0', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13')
ORDER BY date_created DESC
LIMIT 10 OFFSET 0


[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:48 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:50 - MySQLQuerier->select(string, array, int)
[2] /articles/controllers/ArticlesDisplayPendingArticlesController.class.php:132 - DBQuerier->select(string, array)
[3] /articles/controllers/ArticlesDisplayPendingArticlesController.class.php:43 - ArticlesDisplayPendingArticlesController->build_view(HTTPRequestCustom)
[4] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:87 - ArticlesDisplayPendingArticlesController->execute(HTTPRequestCustom)
[5] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:59 - UrlControllerMapper->do_call()
[6] /kernel/framework/mvc/dispatcher/Dispatcher.class.php:67 - UrlControllerMapper->call()
[7] /kernel/framework/mvc/dispatcher/DispatchManager.class.php:43 - Dispatcher->dispatch()
[8] /articles/index.php:64 - DispatchManager::dispatch(array)
[URL] /articles/pending/
2014-03-28 11:41:16

 Fatale : invalid query. (ERRNO 1054) Unknown column 'com.number_comments' in 'field list'query: SELECT articles.*, member.*, com.number_comments, notes.number_notes, notes.average_notes, note.note
FROM phpboost_articles articles
LEFT JOIN phpboost_member member ON member.user_id = articles.author_user_id
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = articles.id AND notes.module_name = "articles"
LEFT JOIN phpboost_note note ON note.id_in_module = articles.id AND note.module_name = "articles" AND note.user_id = 1
WHERE articles.published = 0 OR (articles.published = 2 AND (articles.publishing_start_date > 1396003203 OR articles.publishing_end_date < 1396003203)
AND articles.publishing_end_date 0) AND articles.id_category IN ('0', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13')
ORDER BY date_created DESC
LIMIT 10 OFFSET 0


[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:48 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:50 - MySQLQuerier->select(string, array, int)
[2] /articles/controllers/ArticlesDisplayPendingArticlesController.class.php:132 - DBQuerier->select(string, array)
[3] /articles/controllers/ArticlesDisplayPendingArticlesController.class.php:43 - ArticlesDisplayPendingArticlesController->build_view(HTTPRequestCustom)
[4] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:87 - ArticlesDisplayPendingArticlesController->execute(HTTPRequestCustom)
[5] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:59 - UrlControllerMapper->do_call()
[6] /kernel/framework/mvc/dispatcher/Dispatcher.class.php:67 - UrlControllerMapper->call()
[7] /kernel/framework/mvc/dispatcher/DispatchManager.class.php:43 - Dispatcher->dispatch()
[8] /articles/index.php:64 - DispatchManager::dispatch(array)
[URL] /articles/pending/
2014-03-28 11:40:03

 Fatale : invalid query. (ERRNO 1054) Unknown column 'com.number_comments' in 'field list'query: SELECT articles.*, member.*, com.number_comments, notes.number_notes, notes.average_notes, note.note
FROM phpboost_articles articles
LEFT JOIN phpboost_member member ON member.user_id = articles.author_user_id
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = articles.id AND notes.module_name = "articles"
LEFT JOIN phpboost_note note ON note.id_in_module = articles.id AND note.module_name = "articles" AND note.user_id = 1
WHERE articles.published = 0 OR (articles.published = 2 AND (articles.publishing_start_date > 1396003187 OR articles.publishing_end_date < 1396003187)
AND articles.publishing_end_date 0) AND articles.id_category IN ('0', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13')
ORDER BY date_created DESC
LIMIT 10 OFFSET 0


[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:48 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:50 - MySQLQuerier->select(string, array, int)
[2] /articles/controllers/ArticlesDisplayPendingArticlesController.class.php:132 - DBQuerier->select(string, array)
[3] /articles/controllers/ArticlesDisplayPendingArticlesController.class.php:43 - ArticlesDisplayPendingArticlesController->build_view(HTTPRequestCustom)
[4] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:87 - ArticlesDisplayPendingArticlesController->execute(HTTPRequestCustom)
[5] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:59 - UrlControllerMapper->do_call()
[6] /kernel/framework/mvc/dispatcher/Dispatcher.class.php:67 - UrlControllerMapper->call()
[7] /kernel/framework/mvc/dispatcher/DispatchManager.class.php:43 - Dispatcher->dispatch()
[8] /articles/index.php:64 - DispatchManager::dispatch(array)
[URL] /articles/pending/
2014-03-28 11:39:47

Boosté par PHPBoost 4.

Comme dit plus haut, c'est corrigé pour la béta 2.

julienseth78

OK. Bien noté.