MyBB Community Forums

Full Version: sql problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi
I`m new in php\sql. I have installed the myBB forum sucessfully, but when i try to search something in my forum the following message appears:

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

I use Xamp on my system.

Furthermore I would like to know in which location Attechments get saved.

I would be very pleased if you could help me

best regards

Manu
Attachments are saved in the upload folder of your MyBB folder.
Hi
Thanks for your help, but the problem with the error message is there, yet.
Doesn`t anyone have an idea?

Manu
I think you're using MySQL 5. There are some problems atm which will be solved with the final release MyBB 1.0.
Hi
Yes, do you know when the final version of MyBB 1.0. releases?

Manu
We don't have a set date for the release. We are still working on it.