|
Error in query.
DEBUG MODE
SQL Error : 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'
SELECT
phpbb_releases.release_id, phpbb_releases.releaser_id, phpbb_releases.post_id, phpbb_releases.rel_isVA, phpbb_releases.rel_cover_width, phpbb_releases.rel_cover_height, phpbb_releases.rel_small_cover_width, phpbb_releases.rel_small_cover_height, phpbb_releases.rel_file_size, phpbb_releases.rel_time, phpbb_releases.rel_name, phpbb_releases.rel_artist, phpbb_releases.rel_tracklist, phpbb_releases.rel_cover_url, phpbb_releases.rel_small_cover_url, phpbb_releases.rel_orig_link, phpbb_releases.rel_ddl_list, phpbb_releases.rel_md4_hash, phpbb_releases.rel_year, phpbb_releases.rel_orig_releaser, phpbb_releases.rel_file_name, phpbb_releases.rel_label, phpbb_releases.rel_encoding, phpbb_releases.rel_genre, phpbb_releases.rel_ext_cover_url, phpbb_releases.rel_ext_cover_width, phpbb_releases.rel_ext_cover_height, phpbb_releases.rel_ext_cover_invalid,
phpbb_users.username AS rel_releaser_username,
phpbb_posts.forum_id AS rel_forum_id,
phpbb_posts.post_time AS rel_post_time,
phpbb_topics.topic_title AS rel_topic_title,
phpbb_forums.forum_name as rel_forum_name
FROM
phpbb_releases
INNER JOIN phpbb_posts ON (phpbb_releases.post_id = phpbb_posts.post_id)
INNER JOIN phpbb_topics ON (phpbb_posts.topic_id = phpbb_topics.topic_id)
INNER JOIN phpbb_forums ON (phpbb_posts.forum_id = phpbb_forums.forum_id)
INNER JOIN phpbb_users ON (phpbb_releases.releaser_id = phpbb_users.user_id)
WHERE 1=1
AND ( phpbb_releases.rel_name like '%Mind-Service%' OR phpbb_releases.rel_artist like '%Mind-Service%' ) ORDER BY phpbb_posts.post_time DESC
LIMIT 250
Line : 1674 File : functions_release.php
|
|
|