| Error messages |
| Author |
Message |
nielsencl
Elder Moderator
     
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 |
|
 |
Advertisements
|
This is an ad revenue sharing forum
|
| |
|
 |
Nameslot
Administrator
      
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 |
|
 |
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:
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 |
|
 |
maximum
Super Moderator
     
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 |
|
 |
nielsencl
Elder Moderator
     
Posts: 676
Group: Super Moderators
  Cash: 52.50 Donate
|
|
| 12-16-2007 07:23 AM |
|
 |
Nameslot
Administrator
      
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 |
|
 |
maximum
Super Moderator
     
Posts: 35
Group: Super Moderators
 Cash: 0.00 Donate
|
|
RE: Error messages
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 |
|
 |
Nameslot
Administrator
      
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 |
|
 |
Nameslot
Administrator
      
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 |
|
 |
maximum
Super Moderator
     
Posts: 35
Group: Super Moderators
 Cash: 0.00 Donate
|
|
RE: Error messages
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 |
|
 |
|
Pages (2):
« First
[1]
2
»
Last »
|