Code: Alles auswählen
Zurück zur Foren-Übersicht
Allgemeiner Fehler
SQL ERROR [ mysqli ]
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_313051_21.t.author_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]
SQL
SELECT t.*, p.*, u.*, MAX(s.session_time) as user_session_time, MIN(s.session_viewonline) as user_session_viewonline FROM (phpbb_privmsgs p CROSS JOIN phpbb_privmsgs_to t CROSS JOIN phpbb_users u) LEFT JOIN phpbb_sessions s ON (u.user_id = s.session_user_id AND s.session_time >= 1612883753 AND s.session_user_id <> 1) WHERE t.msg_id = p.msg_id AND p.author_id = u.user_id AND t.folder_id NOT IN (-3, -4) AND t.author_id IN (67, 49) AND t.user_id = 67 AND (p.root_level = 133 OR p.msg_id = 133) GROUP BY p.msg_id ORDER BY p.message_time DESC
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/includes/functions_privmsgs.php
LINE: 2017
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/includes/ucp/ucp_pm_viewmessage.php
LINE: 400
CALL: message_history()
FILE: [ROOT]/includes/ucp/ucp_pm.php
LINE: 421
CALL: view_message()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: ucp_pm->main()
FILE: [ROOT]/ucp.php
LINE: 440
CALL: p_master->load_active()
Vor dem update war alles ok. PN schreiben keine Probleme.
was könnte das sein.
@edit
Ich musste gerade noch feststellen das neue pn schreiben wohl geht aber alte aufrufen funktioniert nicht.