Content Ratings

Content Ratings [Paid] 2.7.6

No permission to buy ($35.00)
Overview FAQ Updates (131) Reviews (33) History Discussion
habe error bei php 7.0 und xenforo 2.1.0

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'title' in 'field list' in src/XF/Db/AbstractStatement.php at line 217
  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
  5. XF\Db\AbstractAdapter->query() in src/addons/SV/ContentRatings/Setup.php at line 97
  6. SV\ContentRatings\Setup->createDefaultRatingTypes() in src/addons/SV/ContentRatings/Setup.php at line 66
  7. SV\ContentRatings\Setup->installStep3() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
  8. SV\ContentRatings\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
  9. SV\ContentRatings\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 398
  10. XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 321
  11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
  12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
  13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
  14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
  15. XF\App->run() in src/XF.php at line 390
  16. XF::runApp() in admin.php at line 13
 
Blade5001 said:
habe error bei php 7.0 und xenforo 2.1.0

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'title' in 'field list' in src/XF/Db/AbstractStatement.php at line 217
  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
  5. XF\Db\AbstractAdapter->query() in src/addons/SV/ContentRatings/Setup.php at line 97
  6. SV\ContentRatings\Setup->createDefaultRatingTypes() in src/addons/SV/ContentRatings/Setup.php at line 66
  7. SV\ContentRatings\Setup->installStep3() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
  8. SV\ContentRatings\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
  9. SV\ContentRatings\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 398
  10. XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 321
  11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
  12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
  13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
  14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
  15. XF\App->run() in src/XF.php at line 390
  16. XF::runApp() in admin.php at line 13
Click to expand...

I would restore a backup as soon as possible. @Xon has made it clear he's still working on the 2.1 update.
 
Hi @Xon,

A question. What will happen if I do the following:
Upgrade to Content Rating 1.3.14.2 -> Disable Content Rating -> Upgrade to XF 2.1 -> Upgrade to Content Rating 2.1 (or whatever you name it when it comes) -> Enable Content Rating

Will it retain all the old ratings as well as the interim ratings (during the period when Content Rating was disabled)?

N.B.: Not sure If I could explain it properly. The bottom line is, I want to update to XF 2.1 without waiting for Content Rating 2.1, but not loosing anything.
 
@Xon I'm assuming you will have an importer from xf1.5 of post ratings -> xf2.1 content ratings/xf standard reaction tables?

Second question, Can such an importer be run after xf2.1 upgrade from xf1.5. That's obviously of the thought that the postratings tables don't impact anything in xf2.1 and can be used later for the import?

Look forward to your update mate. Best wishes.
 
My forum users are enjoying using this addon. However, they would like to be able to give more than one rating. For example they might like to thank someone, as well as acknowledge that they like the post or to give someone a hug. Would this be possible in a future version?
 
@Xon
Using xf 2.1
Content ratings addon is disabled

Code: 
Server error log
InvalidArgumentException: Accessed unknown getter 'sv_rating_type' on XF:NewsFeed[1138219] src/XF/Mvc/Entity/Entity.php:194
Generated by: Konj 07.02.2019. at 18:39
Stack trace
#0 src/XF/Mvc/Entity/Entity.php(106): XF\Mvc\Entity\Entity->get('sv_rating_type')
#1 internal_data/code_cache/templates/l1/s1/public/news_feed_item_post_rating.php(8): XF\Mvc\Entity\Entity->offsetGet('sv_rating_type')
#2 src/XF/Template/Templater.php(1294): XF\Template\Templater->{closure}(Object(SV\ConversationEssentials\XF\Template\Templater), Array)
#3 src/XF/NewsFeed/AbstractHandler.php(102): XF\Template\Templater->renderTemplate('news_feed_item_...', Array)
#4 src/XF/Entity/NewsFeed.php(79): XF\NewsFeed\AbstractHandler->render(Object(XF\Entity\NewsFeed))
#5 [internal function]: XF\Entity\NewsFeed->render()
#6 src/XF/Template/Templater.php(978): call_user_func_array(Array, Array)
#7 internal_data/code_cache/templates/l1/s1/public/news_feed_macros.php(34): XF\Template\Templater->method(Object(XF\Entity\NewsFeed), 'render', Array)
#8 src/XF/Template/Templater.php(694): XF\Template\Templater->{closure}(Object(SV\ConversationEssentials\XF\Template\Templater), Array, Array)
#9 internal_data/code_cache/templates/l1/s1/public/news_feed_macros.php(12): XF\Template\Templater->callMacro('news_feed_macro...', 'feed_item', Array, Array)
#10 src/XF/Template/Templater.php(694): XF\Template\Templater->{closure}(Object(SV\ConversationEssentials\XF\Template\Templater), Array, Array)
#11 internal_data/code_cache/templates/l1/s1/public/member_latest_activity.php(32): XF\Template\Templater->callMacro('news_feed_macro...', 'feed_row', Array, Array)
#12 src/XF/Template/Templater.php(1294): XF\Template\Templater->{closure}(Object(SV\ConversationEssentials\XF\Template\Templater), Array)
#13 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('member_latest_a...', Array)
#14 src/XF/Mvc/Renderer/Json.php(84): XF\Template\Template->render()
#15 src/XF/Mvc/Renderer/Json.php(68): XF\Mvc\Renderer\Json->renderHtmlFallback('XF:Member\\Lates...', 'public:member_l...', Array)
#16 src/XF/Mvc/Dispatcher.php(418): XF\Mvc\Renderer\Json->renderView('XF:Member\\Lates...', 'public:member_l...', Array)
#17 src/XF/Mvc/Dispatcher.php(400): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Json), Object(XF\Mvc\Reply\View))
#18 src/XF/Mvc/Dispatcher.php(360): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Json), Object(XF\Mvc\Reply\View))
#19 src/XF/Mvc/Dispatcher.php(53): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'json')
#20 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#21 src/XF.php(390): XF\App->run()
#22 index.php(20): XF::runApp('XF\\Pub\\App')
#23 {main}
Request state
array(4) {
  ["url"] => string(166) "/members/konj.32338/latest-activity?_xfRequestUri=%2Fmembers%2Fkonj.32338%2F&_xfWithData=1&_xfToken=1549561187%2C21ee6577f0f5ac0f6404ce765436e8e7&_xfResponseType=json"
  ["referrer"] => string(46) "https://www.pijanitvor.com/members/konj.32338/"
  ["_GET"] => array(5) {
    ["/members/konj_32338/latest-activity"] => string(0) ""
    ["_xfRequestUri"] => string(20) "/members/konj.32338/"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(43) "1549561187,21ee6577f0f5ac0f6404ce765436e8e7"
    ["_xfResponseType"] => string(4) "json"
  }
  ["_POST"] => array(0) {
  }
}
 
Hi Xon, will this add-on be updated to be able to import from post ratings add-on for users still stuck on xf1.5 looking to migrate to xf2.1?
 
Could you at least maybe provide an option or a query to rebuild the cache so the ratings are imported to XF 2,1 while you are working on porting the features of the add-on to 2.1?

If I followed the process by disabling it, upgrading, and then only re-enabling it when the 2.1 compatible version is released, would the rating types be preserved as the reaction types on 2.1?
 
Last edited:
CarpCharacin said:
Could you at least maybe provide an option or a query to rebuild the cache so the ratings are imported to XF 2,1 while you are working on porting the features of the add-on to 2.1?

If I followed the process by disabling it, upgrading, and then only re-enabling it when the 2.1 compatible version is released, would the rating types be preserved as the reaction types on 2.1?
Click to expand...
I believe he already did. These ratings came over and populated the default Reactions. I have the plug in disabled but still producing the above mentioned error occasionally.
 
Hey @Xon is it coming along good? Wouldn't want to rush you by asking since the job is best done correctly rather then to rush it but I was wondering. It's been about 2 weeks since @The Dark Wizard said that. Not sure if that's really what you had said but I'm just hoping you may be at work with this. I'm wanting to get the 2.1 upgrade out of the way when I can. This is the only add-on that's keeping me from upgrading. Any idea how much longer it might be? Once again not trying to rush you
 
You must log in or register to reply here.

Similar threads

X
Content Ratings for XF2.1+ Resource Manager
2
Replies
32
Views
4K
dondomainer
D
X
Content Ratings for XF2.1+ Media Gallery
2
Replies
21
Views
2K
Xon
X
Top Bottom