2005-12-03, 01:41 PM
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
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