Error messages

[nielsencl]

I'm still getting an error message if I try to use the new posts or today's posts links at the top.

I use these a lot to check on things... :-(


mySQL 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=1 AND t.lastpost >= '1197354442' 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

 

[Randall]

Humm....Yes. The MySQL server has been upgraded I will check out with Host.

Thanks a lot man

 

[labrocca]

Am I staff?  Why can I read and post in this area?


I also get that message:

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 >= '1197432908' 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

 

[maximum]

Testing to see if non staff can still post here......

Blah Blah Blah Blah........
Blah Blah Blah Blah........
Blah Blah Blah Blah........
Blah Blah Blah Blah........
Blah Blah Blah Blah........
Blah Blah Blah Blah........
Blah Blah Blah Blah........
Blah Blah Blah Blah........

Is this area supposed to be restricted?

 

[nielsencl]

Yes, who let you in...!!!!!!

Sorry!

Thanks for fixing the new posts and other links at the top.

Chris

 

[Randall]

Hello

Yes this area was restricted But not anymore something to do with the database.

 

[maximum]

Hello

Yes this area was restricted But not anymore something to do with the database.

Check the admin area, and db and make sure it is still marked that way? When updated db, then reverted to restore forum, different MySQL versions store db's differently so the "setting" to block this area from non-staff may be missing.

 

[Randall]

Humm.... database updated once again. I reassigned the permissions.

But still it is showing the section to guests.

 

[Randall]

WOW PM's are working again Now thinking to do something about the sections.

 

[maximum]

WOW PM's are working again Now thinking to do something about the sections.

Make sure the db still has the appropriate fields for the privacy settings and that they are not empty if they still exists. That goof-up when did patching may have deleted them accidently, but I don't know all the fields in MyBB since I don't use it and haven't looked at all its code.

 

[Randall]

I have the older backups of the forums table. I think I will compare them side by side and if necessary I can drop the forums table and replace it with the older forum tables.

How is that?

 

[Randall]

Humm.. Update. I did replaced the permissions table with the older table 2 months old one. But Nothing happening Maybe I will open this section up heehhe what else.