Doesn't create table

user warning: Table 'jimi_drupal.interests' doesn't exist query: SELECT * FROM interests WHERE uid = '1' AND tid = '3' in /home/jimi/public_html/core/includes/database.mysql.inc on line 172.
user warning: Table 'jimi_drupal.interests' doesn't exist query: INSERT INTO interests VALUES ('1', '3', 0) in /home/jimi/public_html/core/includes/database.mysql.inc on line 172

I have the same problem:
The message is:
user warning: 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 ') AND i.uid != '1' AND i.uid != '0' AND u.uid = i.uid AND i.tid = t.tid GROUP BY' at line 1 query: SELECT i.uid, i.tid, u.name, t.name AS tname FROM interests i, users u, term_data t WHERE () AND i.uid != '1' AND i.uid != '0' AND u.uid = i.uid AND i.tid = t.tid GROUP BY i.uid ORDER BY i.counter desc LIMIT 10 in /............................................/new/includes/database.mysql.inc on line 172.

Can both please check if an interests.install file exists in the module directory.

Tested on a blank system with latest release. Working.

Do you mind explaining how you solved this problem? It would benefit the community if you could take a few minutes to provide a detailed explanation, and it would also reinforce your understanding of the solution, not to mention perhaps there would be fewer posts on the subject. Thanks!