Hi
I currently working on a script for 1.3 I originally started for 1.2 and need to update some query's for the 1.3 structure, at the moment I am running into this error
Database reported: Unknown column 'u.use_avatar' in 'field list' (Errno: 1054).
when running debug mode, could anyone give the correct column for 1.3 to replace this one?
the full function it is withing looks like -
$result = $forum_db->query('SELECT t.id, t.subject, t.num_replies, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.forum_id, u.use_avatar, u.num_posts, u.registered, u.title, p.poster, p.poster_id, p.message, p.hide_smilies, p.posted, g.g_title, f.forum_name FROM '.$forum_db->prefix.'topics AS t INNER JOIN '.$forum_db->prefix.'posts AS p ON p.topic_id=t.id AND p.posted=t.posted INNER JOIN '.$forum_db->prefix.'users AS u ON u.id=p.poster_id LEFT JOIN '.$forum_db->prefix.'groups AS g ON g.g_id=u.group_id INNER JOIN '.$forum_db->prefix.'forums AS f ON f.id=t.forum_id WHERE t.forum_id IN ('.implode(',', $forumids).') AND t.moved_to IS NULL AND f.redirect_url IS NULL ORDER BY t.posted DESC LIMIT '.$master_limit) or error('Unable to fetch announcements', __FILE__, __LINE__, $forum_db->error());
Many thanks in advcance.