Content Ratings [Paid] 2.7.6

Ozzy47 · Mar 3, 2019

Maybe this one as well,
https://xenforo.com/community/threads/alert-improvements-by-xon.146605/post-1323140

Make sure you take backups before running SQL queries.

CarpCharacin · Mar 3, 2019

ozzy47 said:
Maybe this one as well,
https://xenforo.com/community/threads/alert-improvements-by-xon.146605/post-1323140

Make sure you take backups before running SQL queries.

Still getting the error.

Ozzy47 · Mar 3, 2019

Hmm, then Xon will have to see what the issue is.

D.O.A. · Mar 4, 2019

@Xon take your time and get it right, I'm a patient man. You've done everyone stuck on the abandoned 1.5 ratings mod a service here. without your work that other thread would just be people crying about their upgrade path.

Now you get all that instead

Yours truly,
- unpopular opinions

CarpCharacin · Mar 5, 2019

Version 1.1 of @AndyB's add-on here works for rebuilding the caches to make the ratings appear after upgrading to XF 2.1.

joroom · Mar 6, 2019

CarpCharacin said:
Version 1.1 of @AndyB's add-on here works for rebuilding the caches to make the ratings appear after upgrading to XF 2.1.

So what are the steps that we should do?

Upgrade XF to 2.1 then run Andy's add-on?

CarpCharacin · Mar 6, 2019

joroom said:
So what are the steps that we should do?

Upgrade XF to 2.1 then run Andy's add-on?

Disable Content Ratings, upgrade to 2.1, make sure the per reaction score settings are correct, and then run Andy's add-on with the 'All' option checked.

RobinHood · Mar 6, 2019

I've had a couple of errors since upgrading in January and haven't been able to use any reaction, stock or these.

I tried Andy's add on, didn't do anything.

Here are the errors for your reference Xon. I don't mind waiting until the update comes out to get it working again as I know you're busy.

Code:

XF\Db\Exception: MySQL query error [1366]: Incorrect integer value: '' for column `_xen2`.`xf_reaction_sv_ratings`.`alerts` at row 1 src/XF/Db/AbstractStatement.php:212
Generated by: RobinHood Jan 30, 2019 at 6:36 PM
Stack trace
INSERT  INTO `xf_reaction_sv_ratings` (`reaction_id`, `rating_type_category_id`, `template`, `emoji`, `css_icon`, `visible`, `alerts`, `restrictions`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(160): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/SV/ContentRatings/Setup.php(293): XF\Db\AbstractAdapter->insert('xf_reaction_sv_...', Array)
#5 src/XF/AddOn/StepRunnerUpgradeTrait.php(122): SV\ContentRatings\Setup->upgrade1030705Step2(Array)
#6 src/XF/AddOn/StepRunnerUpgradeTrait.php(71): SV\ContentRatings\Setup->upgradeStepRunner(1030705, 2, Array, 1031200)
#7 src/XF/Admin/Controller/AddOn.php(452): SV\ContentRatings\Setup->upgrade(Array)
#8 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', 'html', Object(XF\Mvc\ParameterBag), 'listAddOns', Object(XF\Admin\Controller\AddOn), NULL)
#10 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#12 src/XF.php(329): XF\App->run()
#13 admin.php(13): XF::runApp('XF\\Admin\\App')
#14 {main}
Request state
array(4) {
  ["url"] => string(44) "/admin.php?add-ons/SV-ContentRatings/upgrade"
  ["referrer"] => string(68) "https://www..com/admin.php?add-ons/SV-ContentRatings/upgrade"
  ["_GET"] => array(1) {
    ["add-ons/SV-ContentRatings/upgrade"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(31) "{"step":2,"version_id":1030705}"
    ["count"] => string(1) "7"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }
}

Code:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xf_thread.first_post_likes' in 'field list' src/XF/Db/AbstractStatement.php:217
Generated by: RobinHood Jan 30, 2019 at 9:52 PM
Stack trace
            update xf_thread
            inner join xf_post on xf_post.post_id = xf_thread.first_post_id
            set xf_thread.first_post_likes = xf_post.likes
            where xf_thread.first_post_id <> 0 and xf_thread.thread_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 198, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 367, 368, 369, 370, 371, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 565, 566, 568, 569, 571, 572, 574, 575, 576, 577, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 668, 669, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 685, 686, 687, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 817, 818, 819, 820, 823, 828, 829, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 843, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 910, 912, 913, 914, 915, 916, 917, 918, 919, 920, 922, 988, 990, 991, 992, 993, 994, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1072, 1073, 1074, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1098, 1099, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1111, 1112, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1126)
        
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(89): XF\Db\Mysqli\Statement->execute()
#4 src/addons/SV/ContentRatings/Job/Upgrades/Upgrade1000900.php(58): XF\Db\AbstractAdapter->query('
            up...')
#5 src/XF/Job/Manager.php(253): SV\ContentRatings\Job\Upgrades\Upgrade1000900->run(G)
#6 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#7 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#8 src/XF/Admin/Controller/Tools.php(139): XF\Job\Manager->runQueue(true, 8)
#9 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#11 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#12 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#14 src/XF.php(390): XF\App->run()
#15 admin.php(13): XF::runApp('XF\\Admin\\App')
#16 {main}
Request state
array(4) {
  ["url"] => string(24) "/admin.php?tools/run-job"
  ["referrer"] => string(48) "https://www..com/admin.php?tools/run-job"
  ["_GET"] => array(1) {
    ["tools/run-job"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["_xfRedirect"] => string(10) "/admin.php"
    ["_xfToken"] => string(8) "********"
    ["only_ids"] => string(0) ""
  }
}

Code:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '1' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: RobinHood Mar 5, 2019 at 9:30 AM
Stack trace
INSERT  INTO `xf_reaction` (`reaction_id`, `text_color`, `image_url`, `image_url_2x`, `sprite_mode`, `sprite_params`, `reaction_score`, `display_order`, `active`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(89): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(172): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/SV/ContentRatings/Setup.php(271): XF\Db\AbstractAdapter->insert('xf_reaction', Array)
#5 src/XF/AddOn/StepRunnerUpgradeTrait.php(122): SV\ContentRatings\Setup->upgrade1030705Step2(Array)
#6 src/XF/AddOn/StepRunnerUpgradeTrait.php(71): SV\ContentRatings\Setup->upgradeStepRunner(1030705, 2, Array, 1031200)
#7 src/XF/Admin/Controller/AddOn.php(575): SV\ContentRatings\Setup->upgrade(Array)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', Object(XF\Mvc\RouteMatch), Object(ThemeHouse\InstallAndUpgrade\XF\Admin\Controller\AddOn), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(ThemeHouse\InstallAndUpgrade\XF\Admin\Controller\AddOn), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 admin.php(13): XF::runApp('XF\\Admin\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(44) "/admin.php?add-ons/SV-ContentRatings/upgrade"
  ["referrer"] => string(68) "https://www..com/admin.php?add-ons/SV-ContentRatings/upgrade"
  ["_GET"] => array(1) {
    ["add-ons/SV-ContentRatings/upgrade"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(2) "[]"
    ["count"] => string(1) "1"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }
}

CarpCharacin · Mar 6, 2019

RobinHood said:
I tried Andy's add on, didn't do anything.

You need to make sure it's version 1.1 with the option checked.

Xon · Mar 7, 2019

RobinHood said:

I've had a couple of errors since upgrading in January and haven't been able to use any reaction, stock or these.

I tried Andy's add on, didn't do anything.

Here are the errors for your reference Xon. I don't mind waiting until the update comes out to get it working again as I know you're busy.

Code:

XF\Db\Exception: MySQL query error [1366]: Incorrect integer value: '' for column `_xen2`.`xf_reaction_sv_ratings`.`alerts` at row 1 src/XF/Db/AbstractStatement.php:212
Generated by: RobinHood Jan 30, 2019 at 6:36 PM
Stack trace
INSERT  INTO `xf_reaction_sv_ratings` (`reaction_id`, `rating_type_category_id`, `template`, `emoji`, `css_icon`, `visible`, `alerts`, `restrictions`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(160): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/SV/ContentRatings/Setup.php(293): XF\Db\AbstractAdapter->insert('xf_reaction_sv_...', Array)
#5 src/XF/AddOn/StepRunnerUpgradeTrait.php(122): SV\ContentRatings\Setup->upgrade1030705Step2(Array)
#6 src/XF/AddOn/StepRunnerUpgradeTrait.php(71): SV\ContentRatings\Setup->upgradeStepRunner(1030705, 2, Array, 1031200)
#7 src/XF/Admin/Controller/AddOn.php(452): SV\ContentRatings\Setup->upgrade(Array)
#8 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', 'html', Object(XF\Mvc\ParameterBag), 'listAddOns', Object(XF\Admin\Controller\AddOn), NULL)
#10 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#12 src/XF.php(329): XF\App->run()
#13 admin.php(13): XF::runApp('XF\\Admin\\App')
#14 {main}
Request state
array(4) {
  ["url"] => string(44) "/admin.php?add-ons/SV-ContentRatings/upgrade"
  ["referrer"] => string(68) "https://www..com/admin.php?add-ons/SV-ContentRatings/upgrade"
  ["_GET"] => array(1) {
    ["add-ons/SV-ContentRatings/upgrade"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(31) "{"step":2,"version_id":1030705}"
    ["count"] => string(1) "7"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }
}

Code:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xf_thread.first_post_likes' in 'field list' src/XF/Db/AbstractStatement.php:217
Generated by: RobinHood Jan 30, 2019 at 9:52 PM
Stack trace
            update xf_thread
            inner join xf_post on xf_post.post_id = xf_thread.first_post_id
            set xf_thread.first_post_likes = xf_post.likes
            where xf_thread.first_post_id <> 0 and xf_thread.thread_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 198, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 367, 368, 369, 370, 371, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 565, 566, 568, 569, 571, 572, 574, 575, 576, 577, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 668, 669, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 685, 686, 687, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 817, 818, 819, 820, 823, 828, 829, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 843, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 910, 912, 913, 914, 915, 916, 917, 918, 919, 920, 922, 988, 990, 991, 992, 993, 994, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1072, 1073, 1074, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1098, 1099, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1111, 1112, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1126)
       
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(89): XF\Db\Mysqli\Statement->execute()
#4 src/addons/SV/ContentRatings/Job/Upgrades/Upgrade1000900.php(58): XF\Db\AbstractAdapter->query('
            up...')
#5 src/XF/Job/Manager.php(253): SV\ContentRatings\Job\Upgrades\Upgrade1000900->run(G)
#6 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#7 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#8 src/XF/Admin/Controller/Tools.php(139): XF\Job\Manager->runQueue(true, 8)
#9 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#11 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#12 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#14 src/XF.php(390): XF\App->run()
#15 admin.php(13): XF::runApp('XF\\Admin\\App')
#16 {main}
Request state
array(4) {
  ["url"] => string(24) "/admin.php?tools/run-job"
  ["referrer"] => string(48) "https://www..com/admin.php?tools/run-job"
  ["_GET"] => array(1) {
    ["tools/run-job"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["_xfRedirect"] => string(10) "/admin.php"
    ["_xfToken"] => string(8) "********"
    ["only_ids"] => string(0) ""
  }
}

Code:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '1' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: RobinHood Mar 5, 2019 at 9:30 AM
Stack trace
INSERT  INTO `xf_reaction` (`reaction_id`, `text_color`, `image_url`, `image_url_2x`, `sprite_mode`, `sprite_params`, `reaction_score`, `display_order`, `active`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(89): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(172): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/SV/ContentRatings/Setup.php(271): XF\Db\AbstractAdapter->insert('xf_reaction', Array)
#5 src/XF/AddOn/StepRunnerUpgradeTrait.php(122): SV\ContentRatings\Setup->upgrade1030705Step2(Array)
#6 src/XF/AddOn/StepRunnerUpgradeTrait.php(71): SV\ContentRatings\Setup->upgradeStepRunner(1030705, 2, Array, 1031200)
#7 src/XF/Admin/Controller/AddOn.php(575): SV\ContentRatings\Setup->upgrade(Array)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', Object(XF\Mvc\RouteMatch), Object(ThemeHouse\InstallAndUpgrade\XF\Admin\Controller\AddOn), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(ThemeHouse\InstallAndUpgrade\XF\Admin\Controller\AddOn), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 admin.php(13): XF::runApp('XF\\Admin\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(44) "/admin.php?add-ons/SV-ContentRatings/upgrade"
  ["referrer"] => string(68) "https://www..com/admin.php?add-ons/SV-ContentRatings/upgrade"
  ["_GET"] => array(1) {
    ["add-ons/SV-ContentRatings/upgrade"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(2) "[]"
    ["count"] => string(1) "1"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }
}

What version of XenForo? And what version of the add-on did you try to upgrade to?

Installing/upgrading after upgrading to XF2.1 isn't supported currently

RobinHood · Mar 7, 2019

XF2.1

Tried upgrading from from CR 1.0.7 -> 1.3.14.2

Sorry, got carried away when upgrading everything...☹

CarpCharacin · Mar 7, 2019

You should have upgraded to CR 1.3 BEFORE upgrading to 2.1. Andy's add-on will only work if that is done, the data needs to be in the XF 2.1 db structure.

Xon · Mar 7, 2019

RobinHood said:
XF2.1

Tried upgrading from from CR 1.0.7 -> 1.3.14.2

Sorry, got carried away when upgrading everything...☹

The upgrade should have worked, but please open a ticket on my site as I'll need database access to fix things so the CR1.3.x upgrade can run.

CarpCharacin · Mar 7, 2019

Then once it's upgraded, you should be able to run Andy's add-on to make the ratings appear as reactions.

Mr Lucky · Mar 7, 2019

CarpCharacin said:
make sure the per reaction score settings are correct,

Can you explain what this means, thanks

CarpCharacin · Mar 7, 2019

Mr Lucky said:
Can you explain what this means, thanks

Like if it's positive, neutral, or negative.

Mr Lucky · Mar 7, 2019

CarpCharacin said:
Like if it's positive, neutral, or negative.

Yes I know what those are, but what makes the score settings correct or not?

CarpCharacin · Mar 7, 2019

Mr Lucky said:
Yes I know what those are, but what makes the score settings correct or not?

If they are what you want them to be. When I upgraded to 2.1, they were all set to positive when they weren't on 2.0.

thumped · Mar 12, 2019

With this addon enabled, no conversations are visible:

Code:

Server error log
ErrorException: Template error: Macro public:conversation_message_macros:message is unknown src/XF/Template/Templater.php:582
Generated by: xxxxx Mar 12, 2019 at 2:13 PM
Stack trace
#0 [internal function]: XF\Template\Templater->handleTemplateError(512, 'Macro public:co...', '/home/thumped/p...', 582, Array)
#1 src/XF/Template/Templater.php(582): trigger_error('Macro public:co...', 512)
#2 src/XF/Template/Templater.php(693): XF\Template\Templater->getTemplateMacro('public', 'conversation_me...', 'message')
#3 internal_data/code_cache/templates/l1/s21/public/conversation_view.php(231): XF\Template\Templater->callMacro('conversation_me...', 'message', Array, Array)
#4 src/XF/Template/Templater.php(1294): XF\Template\Templater->{closure}(Object(SV\ContentRatings\XF\Template\Templater), Array)
#5 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('conversation_vi...', Array)
#6 src/XF/Mvc/Renderer/Html.php(48): XF\Template\Template->render()
#7 src/XF/Mvc/Dispatcher.php(418): XF\Mvc\Renderer\Html->renderView('XF:Conversation...', 'public:conversa...', Array)
#8 src/XF/Mvc/Dispatcher.php(400): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#9 src/XF/Mvc/Dispatcher.php(360): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#10 src/XF/Mvc/Dispatcher.php(53): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#11 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#12 src/XF.php(390): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}

as soon as it's disabled, conversations reappear.

Xon · Mar 13, 2019

@thumped is this with XenForo 2.1+ ? If so, that isn't unexpected as the addon hasn't been updated yet.

Content Ratings [Paid] 2.7.6

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Active member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Similar threads

We value your privacy