[AA] Notable Members [Paid] 1.3.1

Chris D · Oct 30, 2013

I saw the fix.

You said the official fix would be yesterday so I held off and I don't have FTP access at the moment.

@Stuart Wright could you implement this fix please:

Daniel Hood said:
Completely understandable. I'm in middle of working on something else and don't want to repackage for this one line of code especially since I have to release a bigger update soon (was trying for today but it's looking like tomorrow). I'm just going to give you the line of code to edit if you don't mind. Kind of an embarrassing error.

File: /library/XMNotableMembers/ControllerPublic/Member.php line 8

PHP:

if ($parent instanceof XenForo_ControllerResponse_Redirect || $parent instanceof XenForo_ControllerResponse_Reroute)

change to

PHP:

if (!($parent instanceof XenForo_ControllerResponse_View))

[EDIT] you're on your phone so you would probably rather not do that. @Stuart Wright might though.

Daniel Hood · Oct 30, 2013

I edited my post, I meant to quote Stuart too. Phones.... :/

Stuart Wright · Oct 30, 2013

In such a rush with stuff that I just replied with the errors without reading that Chris had so helpfully reported it already. Thanks, Chris and Daniel.

Stuart Wright · Oct 30, 2013

Daniel Hood said:
Completely understandable. I'm in middle of working on something else and don't want to repackage for this one line of code especially since I have to release a bigger update soon (was trying for today but it's looking like tomorrow). I'm just going to give you the line of code to edit if you don't mind. Kind of an embarrassing error.

File: /library/XMNotableMembers/ControllerPublic/Member.php line 8

PHP:

if ($parent instanceof XenForo_ControllerResponse_Redirect || $parent instanceof XenForo_ControllerResponse_Reroute)

I have the latest version 1.2.2 and the above code is not in Member.php.

Daniel Hood · Oct 30, 2013

What's line 8?

Stuart Wright · Nov 7, 2013

Wow - can't believe I've been so busy that I completely missed this.
Line 8 changed, thanks.

Code Monkey · Nov 10, 2013

I have two most resource tabs now. I guess the RM update added one? How do we turn it off in this mod?

Daniel Hood · Nov 10, 2013

/admin.php?template-modifications/ -> find the Xenmods notable members section, uncheck the box for "add resource tab"

Code Monkey · Nov 10, 2013

Yeah i found your earlier post. Thanks

Code Monkey · Nov 15, 2013

Been seeing this error. From the cron that caches the data?

Code:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'last_post_date' in 'having clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 2:02 PM
Stack Trace

#0 /home/mysite/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('??????SELECT us...')
#1 /home/mysite/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '??????SELECT us...')
#2 /home/mysite/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('??????SELECT us...')
#3 /home/mysite/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('??????SELECT us...', Array, 2)
#4 /home/mysite/public_html/library/XMNotableMembers/Model/User.php(64): XenForo_Model->fetchAllKeyed('??????SELECT us...', 'user_id')
#5 /home/mysite/public_html/library/XMNotableMembers/Deferred/Members.php(35): XMNotableMembers_Model_User->getUsers(Array, Array)
#6 /home/mysite/public_html/library/XenForo/Model/Deferred.php(243): XMNotableMembers_Deferred_Members->execute(Array, Array, 9.4944980144501, '')
#7 /home/mysite/public_html/library/XenForo/Model/Deferred.php(369): XenForo_Model_Deferred->runDeferred(Array, 9.4944980144501, '', false)
#8 /home/mysite/public_html/library/XenForo/Model/Deferred.php(322): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#9 /home/mysite/public_html/deferred.php(18): XenForo_Model_Deferred->run(false)
#10 {main}

Request State

array(3) {
  ["url"] => string(40) "http://mysite.com/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(21) "/find-new/42042/posts"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}

Daniel Hood · Nov 16, 2013

Try using the last_activity option instead of last post. Might be a bug with that.

Code Monkey · Nov 16, 2013

Never saw it before though.

Daniel Hood · Nov 16, 2013

Before what? What's changed since then? Did you change the options, install a new add on, anything?

Code Monkey · Nov 16, 2013

I think the only thing I did was click off the duplicate most resources in the TM.

Daniel Hood · Nov 16, 2013

There is no possible way for that to cause it. Are you sure it wasn't erroring before and you didn't notice?

Code Monkey · Nov 16, 2013

No I would have seen it. It could also be a random event. Will have to see if it happens again.

Daniel Hood · Nov 16, 2013

You can adjust the timer in /library/XMWidgets/ControllerPublic/Member.php (the 24*60*60 part). Currently it's set for a day, if you set it for like a minute, you could pretty much manually trigger the rebuild and see if it causes an error.

insocial · Dec 19, 2013

There is a bug with the type=followers tab when the Notable Members Last Activity Type is set to Last Post.

Code Monkey said:

Been seeing this error. From the cron that caches the data?

Code:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'last_post_date' in 'having clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 2:02 PM
Stack Trace

#0 /home/mysite/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('??????SELECT us...')
#1 /home/mysite/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '??????SELECT us...')
#2 /home/mysite/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('??????SELECT us...')
#3 /home/mysite/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('??????SELECT us...', Array, 2)
#4 /home/mysite/public_html/library/XMNotableMembers/Model/User.php(64): XenForo_Model->fetchAllKeyed('??????SELECT us...', 'user_id')
#5 /home/mysite/public_html/library/XMNotableMembers/Deferred/Members.php(35): XMNotableMembers_Model_User->getUsers(Array, Array)
#6 /home/mysite/public_html/library/XenForo/Model/Deferred.php(243): XMNotableMembers_Deferred_Members->execute(Array, Array, 9.4944980144501, '')
#7 /home/mysite/public_html/library/XenForo/Model/Deferred.php(369): XenForo_Model_Deferred->runDeferred(Array, 9.4944980144501, '', false)
#8 /home/mysite/public_html/library/XenForo/Model/Deferred.php(322): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#9 /home/mysite/public_html/deferred.php(18): XenForo_Model_Deferred->run(false)
#10 {main}

Request State

array(3) {
  ["url"] => string(40) "http://mysite.com/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(21) "/find-new/42042/posts"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}

Daniel Hood · Dec 19, 2013

Is it only the followers tab?

Code Monkey · Dec 19, 2013

As well as the other bug I told you about where if you click the followers tab and then click post ratings tab it throws the same error.

[AA] Notable Members [Paid] 1.3.1

XenForo developer

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Member

Well-known member

Well-known member

Similar threads

We value your privacy