[8WR] XenRio (Streams) PRO

[8WR] XenRio (Streams) PRO [Paid] 1.2.6b

No permission to buy ($40.00)
Overview FAQ Updates (28) Reviews (21) History Discussion
Hey folks, any idea what this is happening to me all of a sudden?

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xF0\x9F\x91\xBD' for column 'stream_status' at row 119 -library/Zend/Db/Statement/Mysqli.php:214

It was working fine for days before this started happening.

No streams are loading at all. To be exact the stream themselves are displaying, however, the list of live streams is not loading at all.

Here are the trace details:
Stack Trace

#0 /home/nabeaahm/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/nabeaahm/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/nabeaahm/public_html/library/EWRrio/Model/Streams.php(134): Zend_Db_Adapter_Abstract->query('??????INSERT IN...')
#3 /home/nabeaahm/public_html/library/EWRrio/CronEntry/Scrape.php(7): EWRrio_Model_Streams->updateStreams()
#4 [internal function]: EWRrio_CronEntry_Scrape::runScrape(Array)
#5 /home/nabeaahm/public_html/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#6 /home/nabeaahm/public_html/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#7 /home/nabeaahm/public_html/library/XenForo/Model/Deferred.php(252): XenForo_Deferred_Cron->execute(Array, Array, 9.9999959468842, '')
#8 /home/nabeaahm/public_html/library/XenForo/Model/Deferred.php(378): XenForo_Model_Deferred->runDeferred(Array, 9.9999959468842, '', false)
#9 /home/nabeaahm/public_html/library/XenForo/Model/Deferred.php(331): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#10 /home/nabeaahm/public_html/deferred.php(23): XenForo_Model_Deferred->run(false)
#11 {main}

Request State

array(3) {
["url"] => string(29) "http://localhost/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(19) "/index.php?streams/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}
 
Last edited:
KamelJabber said:
Hey folks, any idea what this is happening to me all of a sudden?

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xF0\x9F\x91\xBD' for column 'stream_status' at row 119 -library/Zend/Db/Statement/Mysqli.php:214

It was working fine for days before this started happening.

No streams are loading at all.
Click to expand...
did u upgrade to 1.25 cause thats when I started getting the almost identical error.
 
KamelJabber said:
Actually having the issue I described above on 1.2.4 also.
Click to expand...
I just did a fresh install of 1.24 on a test server and with only the ewrporta as an addon installed it worked fine. It seems to give that error when the recent news is in the portal. I will keep testing but I must warn you I really dont know much about this stuff!!
 
farmglitch said:
I just did a fresh install of 1.24 on a test server and with only the ewrporta as an addon installed it worked fine. It seems to give that error when the recent news is in the portal. I will keep testing but I must warn you I really dont know much about this stuff!!
Click to expand...

We made no changes and it auto magically started working. I think it was an invalid status code being sent by the service. I image the database type needs to be modified to account for that status code?

I tried on dev to change it to utf8mb4 and still didn't work.

here it is working with no changes on 1.2.5: http://bannedofgamers.com/index.php?streams/
 
KamelJabber said:
We made no changes and it auto magically started working. I think it was an invalid status code being sent by the service. I image the database type needs to be modified to account for that status code?

I tried on dev to change it to utf8mb4 and still didn't work.

here it is working with no changes on 1.2.5: http://bannedofgamers.com/index.php?streams/
Click to expand...

WHAAAT, it's down again! It re-worked for a bit there. Now it's back down: http://bannedofgamers.com/index.php?streams/

It's back up. So I don't know; looks to be a service issue? Or the status code at a certain time?
 
Last edited:
KamelJabber said:
It's back up. So I don't know; looks to be a service issue? Or the status code at a certain time?
Click to expand...
I dont know whats causing the error... I assume it has to do with some streams having a channel status with chinese characters in it. Some quick searching brought up the issue and a possible solution for you here:
http://xenforo.com/community/thread...lue-xdcrk-ba-for-column-message-at-row.43943/

Also, you probably shouldn't scrape both Justin.TV and Twitch.TV, since they share the same channel. You should disable scraping for Justin.TV.
 
Jaxel said:
I dont know whats causing the error... I assume it has to do with some streams having a channel status with chinese characters in it. Some quick searching brought up the issue and a possible solution for you here:
http://xenforo.com/community/thread...lue-xdcrk-ba-for-column-message-at-row.43943/

Also, you probably shouldn't scrape both Justin.TV and Twitch.TV, since they share the same channel. You should disable scraping for Justin.TV.
Click to expand...

Thanks for your reply, I will make that adjustment. I will also review the link above.
Based on the message "Incorrect string value: '\xF0\x9F\x91\xBD' for column 'stream_status' " by best guess was that for whatever reason some stream was putting together a status code is to large to to fit into the 'stream_status' column.

It looks like it's going up and down for me and at least @farmglitch

p.s. LOVE YOUR WORK, I've read through your guide and they were awesome. We also own xencarta, xenmedio & xenrio.

EDIT: I am not familiar with database collations; what they are or how they work. However, according to Jake in that thread they should all be utf8_general_ci. I have no idea how ours was set or changed but the collation_database is set to latin1_swedish_ci. I am going to change it and monitor for any further issues. Thanks again.

Jake Bunce said:
They should all be "utf8_general_ci". You should change them. Check the other tables and fields as well.

Did you deliberately change those collations to "latin1_swedish_ci"?

FYI, you should be able to reproduce the error if you try to create a thread with the title indicated in the error:
Click to expand...
 
Last edited:
Installed on 1.3, but I'm not seeing it in navigation bar. Also, I'm kind of baffled about how to submit channels (added permissions in usergroup). Halp? :)
 
Jaxel updated [8wayRun.Com] XenRio (Streams) PRO with a new update entry:

Version 1.0.7 CHANGELOG

  • Share this page objects have been added across the addon.
  • Fixed some minor compatibility issues with Taigachat support.
  • Hitbox.TV support has been added! JSONp is not yet supported.
  • Livestream now supports channel scraping for the live stream list.
  • Ustream now supports channel scraping... no thumbnails. Unfortunately, xisting Ustream channels must be deleted and then re-added.
Click to expand...

Read the rest of this update entry...
 
Just tried to install XenRio-Streams-v1.0.7. when I uploaded the files through FTP I got this..

An exception occurred: Mysqli prepare error: Unknown column 'EWRrio_games.game_featured' in 'field list' in /home/teamretr/public_html/library/Zend/Db/Statement/Mysqli.php on line 77

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
  5. Zend_Db_Adapter_Abstract->fetchAll() in EWRrio/Model/Streams.php at line 57
  6. EWRrio_Model_Streams->getStreams() in EWRporta/Block/StreamsLive.php at line 20
  7. EWRporta_Block_StreamsLive->getModule() in EWRporta/Model/Blocks.php at line 116
  8. EWRporta_Model_Blocks->getBlockParams() in EWRporta/ViewPublic/Custom.php at line 71
  9. EWRporta_ViewPublic_Custom->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 227
  10. XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 67
  11. XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 572
  12. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
  13. XenForo_FrontController->run() in /home/teamretr/public_html/index.php at line 13
 
suppy said:
Just tried to install XenRio-Streams-v1.0.7. when I uploaded the files through FTP I got this..

An exception occurred: Mysqli prepare error: Unknown column 'EWRrio_games.game_featured' in 'field list' in /home/teamretr/public_html/library/Zend/Db/Statement/Mysqli.php on line 77

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
  5. Zend_Db_Adapter_Abstract->fetchAll() in EWRrio/Model/Streams.php at line 57
  6. EWRrio_Model_Streams->getStreams() in EWRporta/Block/StreamsLive.php at line 20
  7. EWRporta_Block_StreamsLive->getModule() in EWRporta/Model/Blocks.php at line 116
  8. EWRporta_Model_Blocks->getBlockParams() in EWRporta/ViewPublic/Custom.php at line 71
  9. EWRporta_ViewPublic_Custom->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 227
  10. XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 67
  11. XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 572
  12. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
  13. XenForo_FrontController->run() in /home/teamretr/public_html/index.php at line 13
Click to expand...
If you are using the portal remove all your blocks and then try it. You may need to delete your cookies. Then put the blocks back in one by one till you figure out which block it is causing the error. This fixed an issue I had.
 
suppy said:
Just tried to install XenRio-Streams-v1.0.7. when I uploaded the files through FTP I got this..

An exception occurred: Mysqli prepare error: Unknown column 'EWRrio_games.game_featured' in 'field list' in /home/teamretr/public_html/library/Zend/Db/Statement/Mysqli.php on line 77
Click to expand...
You can't just upload the files... you have to run the upgrade script too.
 
I found something weird with this new version.

The Side by side is no longer available as a choice with Dailymotion which is a good thing due to the fact that it wasn't working well but it's still possible to force the access of this feature. You just need to set the default one to side-by-side in the ACP. Is it possible to solve that?

Also, TaigaChat exists as a block for xenporta, why adding a way to use this block in the XenRio sidebar? It would similar to Twitch and it will be much better than now in my opinion :) having both ways would be a good thing
 
I feel I need to inform people that both the Ustream and Hitbox APIs are extremely immature.

They may break randomly; or in the future, require you to delete all channels using that service and resubmit them.
 
Jaxel said:
You can't just upload the files... you have to run the upgrade script too.
Click to expand...

Yeah.. There was a problem in doing this though. I uploaded the files but was immediately hit with the error message. Once I received the error message I couldn't login to admin.
How i rectified the problem was renaming the Block folder to allow me to gain access then I did as you said ran the upgrade script. Sorry I didn't reply sooner got this working yesterday and all good now.


Got one more question? On the tiled view how can I add 4 videos across. At present I've got 3 videos going from left to right.
 
Last edited:
Is there any way in which we can add any of the streams to the sidebar as a widget? Using Widget Framework or otherwise?

Thanks
 
vexx said:
Is there any way in which we can add any of the streams to the sidebar as a widget? Using Widget Framework or otherwise?

Thanks
Click to expand...

I assume you mean outside of XenPorta? It's as easy as a drag and drop if you are using XenPorta.

As far as Widget Framework specifically, I have not done that, however, my limited knowledge leads me to understand it's defiantly possible.

(wow, that was a pretty useless answer, sorry)
 
You must log in or register to reply here.

Similar threads

Jaxel
XF2 [8WR] XenRio 2 (Streams) PRO [Paid]
35 36 37
Replies
728
Views
52K
Chernabog
Chernabog
Top Bottom