Pages (2): « First [1] 2 » Last » Post Reply  Post Thread 

Error messages
Author Message
nielsencl
Elder Moderator

Super Moderators

Posts: 676
Group: Super Moderators
   
Cash: 52.50 Donate
Error messages

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


Cheap Calls - Lists - Domainer - Park - Register
12-12-2007 03:51 AM
Send the author an email Send the author a private message Visit authors website Find all posts by this author Quote this message in a reply

Advertisements

This is an ad revenue sharing forum
Nameslot
Administrator

Administrators

Posts: 1,503
Group: Administrators
   
Cash: 700.50 Donate
RE: Error messages

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

Thanks a lot man :)


Nameslot.com | Do you have a question? shoot me a PM.
12-12-2007 03:36 PM
Send the author an email Send the author a private message Visit authors website Find all posts by this author Quote this message in a reply
labrocca
Junior Member



Posts: 7
Group: Registered
   
Cash: 0.00 Donate
RE: Error messages

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


I also get that message:

Quote:
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


12-13-2007 09:16 AM
Send the author a private message Find all posts by this author Quote this message in a reply
maximum
Super Moderator

Super Moderators

Posts: 35
Group: Super Moderators
   
Cash: 0.00 Donate
RE: Error messages

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?

This post was last modified: 12-16-2007 04:52 AM by maximum.

12-16-2007 04:50 AM
Send the author a private message Find all posts by this author Quote this message in a reply
nielsencl
Elder Moderator

Super Moderators

Posts: 676
Group: Super Moderators
   
Cash: 52.50 Donate
RE: Error messages

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

Sorry! :-)

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

Chris


Cheap Calls - Lists - Domainer - Park - Register
12-16-2007 07:23 AM
Send the author an email Send the author a private message Visit authors website Find all posts by this author Quote this message in a reply
Nameslot
Administrator

Administrators

Posts: 1,503
Group: Administrators
   
Cash: 700.50 Donate
RE: Error messages

Hello :)

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


Nameslot.com | Do you have a question? shoot me a PM.
12-16-2007 02:20 PM
Send the author an email Send the author a private message Visit authors website Find all posts by this author Quote this message in a reply
maximum
Super Moderator

Super Moderators

Posts: 35
Group: Super Moderators
   
Cash: 0.00 Donate
RE:  Error messages

Nameslot Wrote:

Hello :)

Yes this area was restricted :P 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.

12-17-2007 02:32 AM
Send the author a private message Find all posts by this author Quote this message in a reply
Nameslot
Administrator

Administrators

Posts: 1,503
Group: Administrators
   
Cash: 700.50 Donate
RE: Error messages

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

But still it is showing the section to guests.


Nameslot.com | Do you have a question? shoot me a PM.
12-17-2007 04:22 PM
Send the author an email Send the author a private message Visit authors website Find all posts by this author Quote this message in a reply
Nameslot
Administrator

Administrators

Posts: 1,503
Group: Administrators
   
Cash: 700.50 Donate
RE: Error messages

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


Nameslot.com | Do you have a question? shoot me a PM.
12-21-2007 02:37 PM
Send the author an email Send the author a private message Visit authors website Find all posts by this author Quote this message in a reply
maximum
Super Moderator

Super Moderators

Posts: 35
Group: Super Moderators
   
Cash: 0.00 Donate
RE:  Error messages

Nameslot Wrote:

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



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.

12-21-2007 03:34 PM
Send the author a private message Find all posts by this author Quote this message in a reply
Pages (2): « First [1] 2 » Last »

Post Reply  Post Thread 


View a Printable Version | Send this Thread to a Friend | Subscribe to this Thread | Add Thread to Favorites
Rate This Thread:
Forum Jump: