Jaxel
Well-known member
Its YouTube... so yes.Does the update for 1.1.5 address the issue I encountered? It wasn't obvious to me from reading the change log.
Its YouTube... so yes.Does the update for 1.1.5 address the issue I encountered? It wasn't obvious to me from reading the change log.
YouTube does not have an API that supports live stream information, such as viewer counts, or even a chat room.
http://stackoverflow.com/questions/32874529/embedding-youtube-gaming-chat-roomNot sure what "Its YouTube" was suppose to mean, but just confirming the issue I reported has now been resolved. Also, it might be helpful to list those services that have their native chat feature supported on the Overview page, perhaps as an extra column in the supported services table. I initially thought something was wrong with my installation when I eventually found that YouTube's chat isn't currently supported:
I uninstalled everything, deleted all of the files and reinstalled. I am no longer getting the error, but my nav bar number does display streams running. It did until I added a new stream and force scraped. Now, no streams are displayed as online
Confirm your settings under XenRio options under the ACP:
View attachment 119006
I noticed after an update that live streams stopped appearing in the nav bar as well, and found that my settings were "lost". I simply set them back and it was fine again.
What collation are your tables? They should be utf8_general_ciLots of errors today in ACP from Xenrio. The stream page doesn't work, no streams are loading. The errors are mostly the same:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xF0\x9F\x8C\x99 S...' for column 'stream_status' at row 4 -library/Zend/Db/Statement/Mysqli.php:214
#0 /library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /library/EWRrio/Model/Streams.php(144): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tINSERT INT...')
#3 /library/EWRrio/CronEntry/Scrape.php(7): EWRrio_Model_Streams->updateStreams()
#4 [internal function]: EWRrio_CronEntry_Scrape::runScrape(Array)
#5 /library/XenForo/Model/Cron.php(357): call_user_func(Array, Array)
#6 /library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#7 /library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9999969005585, '')
#8 /library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999969005585, '', false)
#9 /library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#10 /deferred.php(23): XenForo_Model_Deferred->run(false)
#11 {main}
array(3) {
["url"] => string(45) "http://citiesskylines-nation.com/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(3) {
["_xfRequestUri"] => string(1) "/"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
What collation are your tables? They should be utf8_general_ci
Stackoverflow provides another fix:
http://stackoverflow.com/questions/...en-trying-to-insert-utf-8-into-mysql-via-jdbc
http://stackoverflow.com/questions/...en-trying-to-insert-utf-8-into-mysql-via-jdbchttp://pastebin.com/KaUR6gPT
When scraping. Noticing that my stream list keeps being empty and I have to force scrape to populate the list. Though sometimes when I scrape I get this error and nothing appears in the list of streams. On the latest update.
This seemed to fix the issue for me. I will post if it did not totally fix it. I only changed the streams table and changed it row by row if that helps you guys.
Did you run a SQL query? How exactly did you fix it?
ALTER TABLE `EWRrio_streams` CHANGE `stream_status` `stream_status` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL ;
utf8mb4 is not the default character set in the installation because most people's servers do not support it. Use at your own risk.Code:ALTER TABLE `EWRrio_streams` CHANGE `stream_status` `stream_status` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL ;
Because Twitch started allowing non-UTF8 characters in their stream titles.Hmm okay. How come Xenrio requires it all of the sudden?
Because Twitch started allowing non-UTF8 characters in their stream titles.
We use essential cookies to make this site work, and optional cookies to enhance your experience.