MyBB Community Forums

I tried posting this in the [MyBB Community Forums / MyBB / Bug Reports and Troubleshooting / Archived - PR2] but it didn't let me. So I'll post it here instead.

When I click on "View Today's Posts" it gives me this error, i ahve no idea why.
You can see for yourself: http://forum.takshimada.info/

mySQL error: 1054
Unknown column 'p.icon' in 'on clause'
Query: SELECT p.pid, p.tid, p.fid, p.subject, p.message, p.uid, t.subject AS tsubject, t.lastposter AS tlastposter, t.replies AS treplies, t.views AS tviews, t.lastpost AS tlastpost, p.dateline, i.name as iconname, i.path as iconpath, p.username AS postusername, u.username, f.name AS forumname FROM mybb_posts p, mybb_threads t LEFT JOIN mybb_icons i ON (i.iid = p.icon) LEFT JOIN mybb_users u ON (u.uid = p.uid) LEFT JOIN mybb_forums f ON (f.fid=p.fid) WHERE 1=1 AND t.lastpost >= '1131818347' AND f.active!='no' AND t.closed NOT LIKE 'moved|%' AND t.tid=p.tid AND t.visible='1' AND p.visible='1' ORDER BY p.dateline DESC

MyBB version: 1.00 Preview Release 2
PHP version (e.g. 4.3.11): 5.0.5
PHPInfo Link (see FAQ): https://secure.takshimada.info/info.php
Webserver (e.g. Apache 1.3.33): 2.0.55
Database (e.g. MySql 4.0.11): 5.0.15
Activated toolkits (e.g. NetPbm, GD): https://secure.takshimada.info/tserver-info (is this it?)
Operating system (e.g. Linux): Mac OS X Tiger 10.4.3
Browser (e.g. Firefox 1.0): Safari 2.0.2


Oh, no modifications, besides the one that doesn't let multiple users register using the same email address.

does that help?

Also, i re-added the copyright info, sorry 'bout that

It's not just view today that doesn't work. i think it's the search.php file, because any page that has search.php?action=results&pid=<number here> has an error like this:


mySQL error: 1054
Unknown column 'p.icon' in 'on clause'
Query: SELECT p.pid, p.tid, p.fid, p.subject, p.message, p.uid, t.subject AS tsubject, t.lastposter AS tlastposter, t.replies AS treplies, t.views AS tviews, t.lastpost AS tlastpost, p.dateline, i.name as iconname, i.path as iconpath, p.username AS postusername, u.username, f.name AS forumname FROM mybb_posts p, mybb_threads t LEFT JOIN mybb_icons i ON (i.iid = p.icon) LEFT JOIN mybb_users u ON (u.uid = p.uid) LEFT JOIN mybb_forums f ON (f.fid=p.fid) WHERE 1=1 AND p.uid='1' AND f.active!='no' AND t.closed NOT LIKE 'moved|%' AND t.tid=p.tid AND t.visible='1' AND p.visible='1' ORDER BY p.dateline DESC

It has probably something todo with which mySQL you are using. MySQL 5 is kinda new. I think 1.0 will support it. but don't count on my words.

okay, but until 1.0 comes out, does anyone have a fix?

It has something to do with MySQL 5, or PHP 5.

Hope it gets fixed for the gold version