Schedule Content XenForo 1.x only

Schedule Content XenForo 1.x only [Paid] 2.0.9

No permission to buy ($20.00)
Are you able to reproduce the error on demand?
That may help to narrow down what is causing it.

Is it a specific set of actions which is causing the error to occur?
 
Are you able to reproduce the error on demand?
That may help to narrow down what is causing it.

Is it a specific set of actions which is causing the error to occur?

Yes, it appears to be happening on a cron job with this add-on - happens about every hour or so - had about 6 of them in the DB before I turned it off. If I enable the add-on I am sure it will start to happen again. This add-on allows you to make a post and hide and delay it until a certain time. This works well with some of the things we are doing on our site right now.
 
What does the cron job do?
My add-on does not allow moderated or non-visible threads to be featured.
It also won't send an alert if the thread which is being featured isn't visible to the thread author (e.g. in a private forum).
 
What does the cron job do?
My add-on does not allow moderated or non-visible threads to be featured.
It also won't send an alert if the thread which is being featured isn't visible to the thread author (e.g. in a private forum).
Hi Brogan! I cron job are you fetch join to `xf_thread ` and select all columns of thread?
 
Yes, I only grab the columns I need.
I'll update the query to select all columns.

I don't understand why your cron is affecting my alert though.
 
@Nobita.Kun,

Do you extend the canViewThread function?

If so, I would aruge that perhaps your code ought to be checking for the existence of the 'scheduled_state' before attempting to use it. I'd have thought if the index isn't set, you'd be safe to return to the parent function.

I think Brogan is changing his code anyway to ensure users of both add-ons get an optimal experience, but in times like these where the information you need isn't there, it should fail gracefully instead of causing errors such as these (IMO).
 
Last edited:
@Nobita.Kun,

Do you extend the canViewThread function?

If so, I would aruge that perhaps your code ought to be checking for the existence of the 'scheduled_state' before attempting to use it. I'd have thought if the index isn't set, you'd be safe to return to the parent function.

I think Brogan is changing his code anyway to ensure users of both add-ons get an optimal experience, but in times like these were the information you need isn't there, it should fail gracefully instead of causing errors such as these (IMO).
Yep! I extended that. ;)
I'll update to fixed that to prevent break other addon ;)
 
I've sent you an updated file @DaiAku.
Can you test it when you get a chance and let me know if the errors are no longer being produced?

If not, I'll incorporate that fix in to the next release.
 
Hi @Nobita.Kun another DB error seems to have occurred with the scheduled post add-on. This time is was after the cleanup of a scheduled post:

Code:
Error Info
Zend_Gdata_App_HttpException: Unable to Connect to ssl://www.google.com:443. Error #0: - library/Zend/Gdata/ClientLogin.php:141
Generated By: Unknown Account, Today at 4:07 AM
Stack Trace

#0 /home/pgweb/public_html/forums/library/UpdateMailingList/CronEntry.php(36): Zend_Gdata_ClientLogin::getHttpClient('donotreply@prec...', '1e10OfB1mQG4cOh', 'wise')
#1 [internal function]: UpdateMailingList_CronEntry::UpdateMailingList(Array)
#2 /home/pgweb/public_html/forums/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#3 /home/pgweb/public_html/forums/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#4 /home/pgweb/public_html/forums/library/XenForo/Model/Deferred.php(252): XenForo_Deferred_Cron->execute(Array, Array, 9.99998998642, '')
#5 /home/pgweb/public_html/forums/library/XenForo/Model/Deferred.php(378): XenForo_Model_Deferred->runDeferred(Array, 9.99998998642, '', false)
#6 /home/pgweb/public_html/forums/library/XenForo/Model/Deferred.php(331): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#7 /home/pgweb/public_html/forums/deferred.php(23): XenForo_Model_Deferred->run(false)
#8 {main}

Request State

array(3) {
  ["url"] => string(45) "http://precursorgames.com/forums/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(3) {
    ["_xfRequestUri"] => string(55) "/forums/index.php?threads/chronicles-of-the-order.3142/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

I also got the following notification to my account:

Code:
 whatever
Your thread Chronicles of the Order was stop scheduled by whatever
Today at 1:02 AM

Chronicles of the Order was the scheduled post. When you try to click on whatever as a user name it give you an error.

Thanks!
Denis
 
Error Info
Zend_Gdata_App_HttpException: Unable to Connect to ssl://www.google.com:443. Error #0: - library/Zend/Gdata/ClientLogin.php:141
Generated By: Unknown Account, Today at 4:07 AM
Stack Trace

#0 /home/pgweb/public_html/forums/library/UpdateMailingList/CronEntry.php(36): Zend_Gdata_ClientLogin::getHttpClient('donotreply@prec...', '1e10OfB1mQG4cOh', 'wise')
#1 [internal function]: UpdateMailingList_CronEntry::UpdateMailingList(Array)
#2 /home/pgweb/public_html/forums/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#3 /home/pgweb/public_html/forums/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#4 /home/pgweb/public_html/forums/library/XenForo/Model/Deferred.php(252): XenForo_Deferred_Cron->execute(Array, Array, 9.99998998642, '')
#5 /home/pgweb/public_html/forums/library/XenForo/Model/Deferred.php(378): XenForo_Model_Deferred->runDeferred(Array, 9.99998998642, '', false)
#6 /home/pgweb/public_html/forums/library/XenForo/Model/Deferred.php(331): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#7 /home/pgweb/public_html/forums/deferred.php(23): XenForo_Model_Deferred->run(false)
#8 {main}

Request State

array(3) {
["url"] => string(45) "http://precursorgames.com/forums/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(3) {
["_xfRequestUri"] => string(55) "/forums/index.php?threads/chronicles-of-the-order.3142/"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
@DaiAku I don't see any information of my addon there :oops:
whatever
Your thread Chronicles of the Order was stop scheduled by whatever
Today at 1:02 AM
"whatever" is name i selected when using for Running cron entry :D SO that's as designed :P
 
Back
Top Bottom