[bananalive]

Originally Posted by montesm

Running 3.6.4 - and getting this error when creating a tournament. Can you please help??


Invalid SQL:
SELECT comments.id AS id, comments.comment AS comment, comments.userid AS userid, comments.username AS username, comments.time AS time, comments.ed_userid AS ed_userid, comments.ed_username AS ed_username, comments.ed_time AS ed_time, comments.ed_ip AS ed_ip, user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.width_thumb AS width_thumb, customavatar.height_thumb AS height_thumb
FROM vb_tmnt_comments AS comments
LEFT JOIN vb_user AS user ON (comments.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE comments.tid=4 ORDER BY comments.id ASC LIMIT 0, 5;

MySQL Error : Unknown column 'customavatar.width_thumb' in 'field list'
Error Number : 1054

Find and delete in competitions.php

PHP Code:

, customavatar.width_thumb AS width_thumb, customavatar.height_thumb AS height_thumb