• This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.

RecentStatus

Status
Not open for further replies.
After upgrading this plugin, I get 500 errors when I turn on the 'Limit to One' option.

Code:
array(3) {
  ["url"] => string(40) "http://forums.traditionsportsonline.com/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
 
I'm posting the widget framework version of this tomorrow...it should take care of it. I'll look into what could cause the 500 error tonight.
 
I'm posting the widget framework version of this tomorrow...it should take care of it. I'll look into what could cause the 500 error tonight.

The 500 error was caused because the query to grab the limited to one status array wasn't correct. So, later when it tried to loop and grab data from the status list, the user_id's didn't match up and it puked.

I changed the following block in the Recent Status model.

Code:
if($onePerUser == 1) {
      $statusArray = $db->fetchAll( $db->limit("SELECT * FROM (SELECT * FROM xf_profile_post WHERE message_state <> 'deleted' ORDER BY post_date DESC) t1 GROUP BY t1.user_id ORDER BY post_date DESC", $numStatusShown));
      $statusArray = array_sort($statusArray,"post_date");
}

I added a 'ORDER BY post_date DESC' to the inside query.
 
The full query should be like this, otherwise it's pulling any profile post, not just status updates.

Code:
SELECT * FROM (SELECT * FROM xf_profile_post WHERE message_state <> 'deleted' AND profile_user_id = user_id ORDER BY post_date DESC) t1 GROUP BY t1.user_id ORDER BY post_date DESC
 
The full query should be like this, otherwise it's pulling any profile post, not just status updates.

Code:
SELECT * FROM (SELECT * FROM xf_profile_post WHERE message_state <> 'deleted' AND profile_user_id = user_id ORDER BY post_date DESC) t1 GROUP BY t1.user_id ORDER BY post_date DESC

Good catch.

The original version doesn't do that check when Limit to 1 is on either.
 
Thanks for that I got waylayed a bit, I have the widget version ready to test. I'm putting it on my board tomorrow and will release it once i'm sure it works.
 
I just posted a 3.1.2 patch to fix the query real quick before I get the widget version with caching out. Sorry about that bug and thanks guys for catching it. All you need to do is upload the enclosed files in to the library directory to patch it.
 

Attachments

I just posted a 3.1.2 patch to fix the query real quick before I get the widget version with caching out. Sorry about that bug and thanks guys for catching it. All you need to do is upload the enclosed files in to the library directory to patch it.

I don't know why but it still doesn't work for me. :/
 
for some reason when i try to rebuild the ache it get the error An error occurred or the request was stopped.

unsure why or how to fix this??
 
Updated all my templates to 1.0.0 for XF and removed then reinstalled this mod. Works now!

Is caching enabled? What do I do to enable it? DEF going to need this when we hit major load.
 
I'm still new to XenForo so It's probably a very simple fix. But I need some help to fix the styling of this.

On my forum it looks like this
ogUbt.png

Notice the form at the bottom is not the right style/color.

On the portal page everything looks fine.
lgyuh.png


Thanks in advance
 
I'm getting this error whenever I try to make updates on the main page. Help?

The following error occurred:

404 Not Found

The resource requested could not be found on this server!

Powered By LiteSpeed Web Server
LiteSpeed Technologies is not responsible for administration and contents of this web site!
 
I'm still new to XenForo so It's probably a very simple fix. But I need some help to fix the styling of this.

On my forum it looks like this
ogUbt.png

Notice the form at the bottom is not the right style/color.

On the portal page everything looks fine.
lgyuh.png


Thanks in advance
Same here mate, did you got any fix?
 
Same here mate, did you got any fix?
It pulls that color from primaryLighterStill in your appearence pane. So you have 2 options change that color or modify it directly in xenforo_sections.css, just look for sectionFooter. Warning this may change things in other portions of your forum though.
 
I also noticed in the screenshot above, that "Basic XenForo Installation" is appearing on a NEW line, any idea what is causing that as well? I'm encountering that one on my test site.
 
That's just how it is in the template. It can be modified pretty easily, I post a change in a few minutes so you can see it.
 
Status
Not open for further replies.
Back
Top Bottom