Forum

Citation :

2017-07-25 09:43:58
256
multiple rows have been found but the query expect only one result
-> SELECT last_view_id FROM phpboost_forum_view WHERE user_id = :user_id AND idtopic = :idtopic
array (
'user_id' => '1',
'idtopic' => 1381,<br />
[0] /kernel/framework/io/db/DBQuerier.class.php:224 - DBQuerier->select_single_row(string, array, string, array)
[1] /forum/forum_functions.php:116 - DBQuerier->get_column_value(string, string, string, array)
[2] /forum/topic.php:131 - mark_topic_as_read(int, string, string)
[URL] /forum/topic-1381+site-trainz-jimmyarmstrongtrainz.php

Citation :

---------------------------------System report---------------------------------
-----------------------------generated by PHPBoost-----------------------------
SERVER CONFIGURATION-----------------------------------------------------------
php version : 5.6.31
dbms version : MySQL 5.5.55-0+deb7u1-log
gd library : 1
curl extension : 1
mbstring extension : 1
url rewriting : N/A
apcu cache : 0
PHPBOOST CONFIGURATION---------------------------------------------------------
phpboost version : 5.1.0
server url : http://www.trains-et-trainz.fr
site path :
default theme : Plus (Version 5.1.0)
default language : Français
default editor : BBCode
home page : http://www.trains-et-trainz.fr/index.php
url rewriting : 1
apcu cache : 0
output gzip : 1
session cookie name : trainsettrainz
session duration : 3600
active session duration : 300
DIRECTORIES AUTHORIZATIONS-----------------------------------------------------
/ : 1
/cache : 1
/cache/backup : 1
/cache/syndication : 1
/cache/tpl : 1
/cache/css : 1
/images/avatars : 1
/images/customization : 1
/images/group : 1
/images/maths : 1
/images/smileys : 1
/kernel/db : 1
/lang : 1
/templates : 1
/upload : 1

Citation :

2017-07-25 10:04:44
256
invalid query. (ERRNO 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.id, m1.display_name AS login, m1.level AS user_level, m1.groups AS groups, m2.d' at line 1

---

query: SELECT DISINCT t.id, m1.display_name AS login, m1.level AS user_level, m1.groups AS groups, m2.display_name AS last_login, m2.level AS last_user_level, m2.groups AS last_user_groups, t.title, t.subtitle, t.user_id, t.nbr_msg, t.nbr_views, t.last_user_id, t.last_msg_id, t.last_timestamp, t.type, t.status, t.display_msg, v.last_view_id, p.question
FROM phpboost_forum_topics t
LEFT JOIN phpboost_forum_view v ON v.idtopic = t.id
LEFT JOIN phpboost_forum_cats c ON c.id = t.idcat
LEFT JOIN phpboost_forum_poll p ON p.idtopic = t.id
LEFT JOIN phpboost_member m1 ON m1.user_id = t.user_id
LEFT JOIN phpboost_member m2 ON m2.user_id = t.last_user_id
WHERE t.nbr_msg = 1
ORDER BY t.last_timestamp DESC
LIMIT 20 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] /forum/noanswer.php:86 - DBQuerier->select(string, array)
[URL] /forum/noanswer.php

Édité par benflovideo Le 25/07/2017 à 10h40