[HA] News Ticker

[HA] News Ticker [Paid] 1.3.1

No permission to buy ($39.99)
@Dadparvar any chance of implementing this 'forgotten' feature? (for Breaking News Ticker) I have few other content types which don't have RSS and I want to include those content links with title in custom news, can we have both RSS and custom news working together please?

View attachment 151212
Not have enough time yet. But why not using other tickers for that goal?

Tonight I have plan to add user preferences. Not sure if I will have time to add another features.
 
Not have enough time yet. But why not using other tickers for that goal?
We are using just one ticker and like to show every news at one place, one ticker. Breaking news ticker fit really well in our site.
Tonight I have plan to add user preferences. Not sure if I will have time to add another features.
okay, no rush. Take your time to implement this when you get some time easily, and if you can make the input area (of custom news) easier then it would be helpful. If possible, maybe similar to the XenForo's Censoring (admin.php?options/list/censoringOptions) where we can easily add unlimited entries in super easy way: After every new entry the next input fields comes.

example.webp
If it's not possible then, maybe make input area a full html editor like Chris D's Notices add-on does.
 
if you can make the input area (of custom news) easier then it would be helpful. If possible, maybe similar to the XenForo's Censoring (admin.php?options/list/censoringOptions) where we can easily add unlimited entries in super easy way: After every new entry the next input fields comes.

example-jpg.151214
will come in 1.3.0
nt-bnt-custom-add.gif
 
@Dadparvar the upgrade to 1.3.0 did not go well for me, unfortunately :(
1. After upgrade I tested the custom news but that did not appear on news ticker.
2. Then I started seeing errors on user registrations:
Code:
Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'dad_nt_show_newsticker' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 10:32 AM

Stack Trace

#0 /home/nginx/domains/forum.com/public/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user_option', Array)
#5 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#6 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /home/nginx/domains/forum.com/public/library/XenForo/ControllerPublic/Register.php(740): XenForo_DataWriter->save()
#8 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionFacebookRegister()
#9 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/nginx/domains/forum.com/public/index.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(54) "https://www.forum.com/register/facebook/register"
  ["_GET"] => array(1) {
    ["/register/facebook/register"] => string(0) ""
  }
  ["_POST"] => array(12) {
    ["username"] => string(14) "mani moon"
    ["dob_month"] => string(1) "3"
    ["dob_day"] => string(2) "27"
    ["dob_year"] => string(4) "1995"
    ["location"] => string(9) "dreamland"
    ["custom_fields"] => array(2) {
      ["interestedin"] => array(1) {
        ["friendship"] => string(10) "friendship"
      }
      ["relationshipstatus"] => string(6) "single"
    }
    ["custom_fields_shown"] => array(2) {
      [0] => string(12) "interestedin"
      [1] => string(18) "relationshipstatus"
    }
    ["timezone"] => string(13) "Asia/Tashkent"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["redirect"] => string(28) "https://www.forum.com/"
    ["fb_token"] => string(0) ""
  }
}
Code:
Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'dad_nt_show_newsticker' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 12:56 PM

Stack Trace

#0 /home/nginx/domains/forum.com/public/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user_option', Array)
#5 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#6 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /home/nginx/domains/forum.com/public/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
#8 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionRegister()
#9 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/nginx/domains/forum.com/public/index.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(45) "https://www.forum.com/register/register"
  ["_GET"] => array(1) {
    ["/register/register"] => string(0) ""
  }
  ["_POST"] => array(16) {
    ["username"] => string(0) ""
    ["67802c9eabc3b26779ede7904e7fc310"] => string(8) "Roadtrip"
    ["c16b2f289a11bab97f029e99768ac826"] => string(21) "F2013254007@gmail.com"
    ["539c8ec64db31e593d618e4dcb9e3eac"] => string(6) "female"
    ["dob_month"] => string(1) "6"
    ["dob_day"] => string(2) "17"
    ["dob_year"] => string(4) "1993"
    ["location"] => string(6) "DC"
    ["ad2e1912a189f635c998f141e1c13c2c"] => array(3) {
      ["aw50zxjlc3rlzglu"] => string(0) ""
      ["interestedin"] => array(1) {
        ["networking"] => string(10) "networking"
      }
      ["relationshipstatus"] => string(6) "single"
    }
    ["custom_fields_shown"] => array(3) {
      [0] => string(16) "aw50zxjlc3rlzglu"
      [1] => string(12) "interestedin"
      [2] => string(18) "relationshipstatus"
    }
    ["5f7b237352877934a32d3b12c57de144"] => string(13) "Asia/Tashkent"
    ["captcha_question_answer"] => string(28) "Peace"
    ["captcha_question_hash"] => string(40) "b8db66dd69f7496ce0d512c58e00df2f9a93ff45"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "f9149b469188d45033f557fc985150fe"
  }
}

3. Then I tried uninstalling and got this:

Code:
Server Error

Mysqli statement execute error : Can't DROP 'dad_nt_show_newsticker'; check that column/key exists

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Dadparvar/newsticker/Install.php at line 50
Dadparvar_newsticker_Install::uninstall() in XenForo/DataWriter/AddOn.php at line 213
XenForo_DataWriter_AddOn->_postDelete() in XenForo/DataWriter.php at line 1793
XenForo_DataWriter->delete() in XenForo/ControllerAdmin/AddOn.php at line 123
XenForo_ControllerAdmin_AddOn->actionDelete() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/nginx/domains/forum.com/public/admin.php at line 13
Code:
Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Can't DROP 'dad_nt_show_newsticker'; check that column/key exists - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Veer, 13 minutes ago

Stack Trace

#0 /home/nginx/domains/forum.com/public/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/nginx/domains/forum.com/public/library/Dadparvar/newsticker/Install.php(50): Zend_Db_Adapter_Abstract->query('ALTER TABLE `xf...')
#3 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter/AddOn.php(213): Dadparvar_newsticker_Install::uninstall(Array)
#4 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1793): XenForo_DataWriter_AddOn->_postDelete()
#5 /home/nginx/domains/forum.com/public/library/XenForo/ControllerAdmin/AddOn.php(123): XenForo_DataWriter->delete()
#6 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_AddOn->actionDelete()
#7 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /home/nginx/domains/forum.com/public/admin.php(13): XenForo_FrontController->run()
#9 {main}

Request State

array(3) {
  ["url"] => string(73) "https://www.forum.com/admin.php?add-ons/Dadparvar_NewsTicker/delete"
  ["_GET"] => array(1) {
    ["add-ons/Dadparvar_NewsTicker/delete"] => string(0) ""
  }
  ["_POST"] => array(2) {
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
 
@Dadparvar the upgrade to 1.3.0 did not go well for me, unfortunately :(
1. After upgrade I tested the custom news but that did not appear on news ticker.
2. Then I started seeing errors on user registrations:
Code:
Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'dad_nt_show_newsticker' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 10:32 AM

Stack Trace

#0 /home/nginx/domains/forum.com/public/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user_option', Array)
#5 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#6 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /home/nginx/domains/forum.com/public/library/XenForo/ControllerPublic/Register.php(740): XenForo_DataWriter->save()
#8 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionFacebookRegister()
#9 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/nginx/domains/forum.com/public/index.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(54) "https://www.forum.com/register/facebook/register"
  ["_GET"] => array(1) {
    ["/register/facebook/register"] => string(0) ""
  }
  ["_POST"] => array(12) {
    ["username"] => string(14) "mani moon"
    ["dob_month"] => string(1) "3"
    ["dob_day"] => string(2) "27"
    ["dob_year"] => string(4) "1995"
    ["location"] => string(9) "dreamland"
    ["custom_fields"] => array(2) {
      ["interestedin"] => array(1) {
        ["friendship"] => string(10) "friendship"
      }
      ["relationshipstatus"] => string(6) "single"
    }
    ["custom_fields_shown"] => array(2) {
      [0] => string(12) "interestedin"
      [1] => string(18) "relationshipstatus"
    }
    ["timezone"] => string(13) "Asia/Tashkent"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["redirect"] => string(28) "https://www.forum.com/"
    ["fb_token"] => string(0) ""
  }
}
Code:
Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'dad_nt_show_newsticker' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 12:56 PM

Stack Trace

#0 /home/nginx/domains/forum.com/public/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user_option', Array)
#5 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#6 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /home/nginx/domains/forum.com/public/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
#8 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionRegister()
#9 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/nginx/domains/forum.com/public/index.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(45) "https://www.forum.com/register/register"
  ["_GET"] => array(1) {
    ["/register/register"] => string(0) ""
  }
  ["_POST"] => array(16) {
    ["username"] => string(0) ""
    ["67802c9eabc3b26779ede7904e7fc310"] => string(8) "Roadtrip"
    ["c16b2f289a11bab97f029e99768ac826"] => string(21) "F2013254007@gmail.com"
    ["539c8ec64db31e593d618e4dcb9e3eac"] => string(6) "female"
    ["dob_month"] => string(1) "6"
    ["dob_day"] => string(2) "17"
    ["dob_year"] => string(4) "1993"
    ["location"] => string(6) "DC"
    ["ad2e1912a189f635c998f141e1c13c2c"] => array(3) {
      ["aw50zxjlc3rlzglu"] => string(0) ""
      ["interestedin"] => array(1) {
        ["networking"] => string(10) "networking"
      }
      ["relationshipstatus"] => string(6) "single"
    }
    ["custom_fields_shown"] => array(3) {
      [0] => string(16) "aw50zxjlc3rlzglu"
      [1] => string(12) "interestedin"
      [2] => string(18) "relationshipstatus"
    }
    ["5f7b237352877934a32d3b12c57de144"] => string(13) "Asia/Tashkent"
    ["captcha_question_answer"] => string(28) "Peace"
    ["captcha_question_hash"] => string(40) "b8db66dd69f7496ce0d512c58e00df2f9a93ff45"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "f9149b469188d45033f557fc985150fe"
  }
}

3. Then I tried uninstalling and got this:

Code:
Server Error

Mysqli statement execute error : Can't DROP 'dad_nt_show_newsticker'; check that column/key exists

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Dadparvar/newsticker/Install.php at line 50
Dadparvar_newsticker_Install::uninstall() in XenForo/DataWriter/AddOn.php at line 213
XenForo_DataWriter_AddOn->_postDelete() in XenForo/DataWriter.php at line 1793
XenForo_DataWriter->delete() in XenForo/ControllerAdmin/AddOn.php at line 123
XenForo_ControllerAdmin_AddOn->actionDelete() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/nginx/domains/forum.com/public/admin.php at line 13
Code:
Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Can't DROP 'dad_nt_show_newsticker'; check that column/key exists - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Veer, 13 minutes ago

Stack Trace

#0 /home/nginx/domains/forum.com/public/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/nginx/domains/forum.com/public/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/nginx/domains/forum.com/public/library/Dadparvar/newsticker/Install.php(50): Zend_Db_Adapter_Abstract->query('ALTER TABLE `xf...')
#3 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter/AddOn.php(213): Dadparvar_newsticker_Install::uninstall(Array)
#4 /home/nginx/domains/forum.com/public/library/XenForo/DataWriter.php(1793): XenForo_DataWriter_AddOn->_postDelete()
#5 /home/nginx/domains/forum.com/public/library/XenForo/ControllerAdmin/AddOn.php(123): XenForo_DataWriter->delete()
#6 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_AddOn->actionDelete()
#7 /home/nginx/domains/forum.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /home/nginx/domains/forum.com/public/admin.php(13): XenForo_FrontController->run()
#9 {main}

Request State

array(3) {
  ["url"] => string(73) "https://www.forum.com/admin.php?add-ons/Dadparvar_NewsTicker/delete"
  ["_GET"] => array(1) {
    ["add-ons/Dadparvar_NewsTicker/delete"] => string(0) ""
  }
  ["_POST"] => array(2) {
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
can you please run this query in your database please?
Code:
ALTER TABLE `xf_user_option` ADD `dad_nt_show_newsticker` BOOLEAN NOT NULL DEFAULT '1'
this should fix things.
 
Done. what should I do next? because I tried uninstalling at last. Should I install 1.3.0 again?
I don't know what is happened in that time. But, to make sure everything is back, upload the files again and upgrade once again. Things should work fine then.
Let me know the result.
 
I don't know what is happened in that time. But, to make sure everything is back, upload the files again and upgrade once again. Things should work fine then.
Let me know the result.
The uninstall has been completed now. Now it will be a new install. Would you change something in the package or I should go with the current package again?
 
The uninstall has been completed now. Now it will be a new install. Would you change something in the package or I should go with the current package again?
Nothing changed. If you are doing a fresh install, it must work fine.
 
They were reverted already, and I was still not able to see custom news on front end along with the RSS feeds.
In BNT, RSS can't be combined with Custom News. I said last night. I just found time to implement the new way of creating custom news that you asked at the end.
 
On install attempt, I got this in start:
Mysqli statement execute error : Duplicate column name 'dad_nt_show_newsticker'
it seems the creating table was done after the uninstall passed the dropping part.

After you finished the uninstall, run this:
Code:
ALTER TABLE `xf_user_option` DROP COLUMN `dad_nt_show_newsticker`
so that it drops the column.
Then everything is cleared.
After that, if you install it, it will completely install and add things.
 
Back
Top Bottom