Multi-Account Detector

Multi-Account Detector 1.7.2

Upgrade Open for $27.99 / $35.99
Overview License agreement Updates (14) Reviews (3) History Discussion

xoop

X
Jun 22, 2020
31
17
8
021 said:
Does multi-account detection work correctly?
Click to expand...
Yes, correctly, if you visit many many times from multi's. Then the IDs sometimes coincide and multi-account are defined correctly. For some reason, the IDs themselves are determined incorrectly. I tried maybe 10-15 times until 1 matched.

1.png
276841 and 276842 should be same, log in from similar environment in ~1 min.

Second bug. If FingerprintJS Pro token is enabled and it's filled to the limit (1000 free api checks), FingerprintJS should also stop to work.
 

021

021
Premium
Developer
Jun 11, 2020
556
443
63
maxo said:
Yes, correctly, if you visit many many times from multi's. Then the IDs sometimes coincide and multi-account are defined correctly. For some reason, the IDs themselves are determined incorrectly. I tried maybe 10-15 times until 1 matched.
Click to expand...
If everything works correctly, why did you decide that something is wrong?) These values should be different, as intended. And if it was broken, reports would not be created)

maxo said:
Second bug. If FingerprintJS Pro token is enabled and it's filled to the limit (1000 free api checks), FingerprintJS should also stop to work.
Click to expand...
I will look into this issue :)
 

xoop

X
Jun 22, 2020
31
17
8
021 said:
If everything works correctly, why did you decide that something is wrong?) These values should be different, as intended. And if it was broken, reports would not be created)
Click to expand...
Hmm. But FingerprintJS has same issue. It should be similar, as I undersnand?

Also such strange thing:
2.png
Is was 1 log in (from 2 users one by one)
 

021

021
Premium
Developer
Jun 11, 2020
556
443
63
maxo said:
Hmm. But FingerprintJS has same issue. It should be similar, as I undersnand?
Click to expand...
I do not quite understand you: do you have problems with the definition of multi-accounts or what is the essence of the problem? It is normal that there may be different values

maxo said:
Also such strange thing:
Click to expand...
No. No weirdness, everything works as it should.
 

xoop

X
Jun 22, 2020
31
17
8
021 said:
I do not quite understand you: do you have problems with the definition of multi-accounts or what is the essence of the problem? It is normal that there may be different values
Click to expand...
I mean, that all this IDs - 276843, 276844, 276845, 276846 were login in 1 browser one by one. They should be all multiple accounts. But only IDs 276843, 276844 detected correctly. Other IDs 276845, 276846 - no correct detection. In DB and here /multi-accounts/ With FingerprintJS - same situation.
It's like there's some kind of limits somewhere or something like that.

Ok. Thanks. I will also check more.
 
Last edited:

021

021
Premium
Developer
Jun 11, 2020
556
443
63
xoop said:
I mean, that all this IDs - 276843, 276844, 276845, 276846 were login in 1 browser one by one. They should be all multiple accounts. But only IDs 276843, 276844 detected correctly. Other IDs 276845, 276846 - no correct detection.
Click to expand...
Hmm... At the same time, they are not in the created reports? I just logged into four accounts from one browser and everything works for me. What browser are you using?
1665051862374.png
 

santa_claus

S
Sep 5, 2020
4
0
1
Hi,

There is a bug at the admin panel, can you please check it?
Code: 
InvalidArgumentException: MAD thread report creation error: Attempted to convert NULL to string/binary [username] src/XF/Mvc/Entity/Entity.php:765
Generated by: iHate Oct 25, 2022 at 3:35 AM
Stack trace
#0 src/XF/Mvc/Entity/Entity.php(643): XF\Mvc\Entity\Entity->_castValueToType(NULL, 'username', 5, Array)
#1 src/XF/Mvc/Entity/Entity.php(572): XF\Mvc\Entity\Entity->set('username', NULL)
#2 src/XF/Service/Thread/Creator.php(109): XF\Mvc\Entity\Entity->__set('username', NULL)
#3 src/XF/Service/Thread/Creator.php(73): XF\Service\Thread\Creator->setUser(Object(MMO\ReputationSystem\XF\Entity\User))
#4 src/XF/Service/Thread/Creator.php(57): XF\Service\Thread\Creator->setupDefaults()
#5 src/XF/Container.php(276): XF\Service\Thread\Creator->__construct(Object(XF\Pub\App), Object(XFMG\XF\Entity\Forum))
#6 src/XF/App.php(1710): XF\Container->createObject('XF\\Service\\Thre...', Array)
#7 src/XF/Container.php(234): XF\App->XF\{closure}('XF\\Service\\Thre...', Array, Object(XF\Container))
#8 src/XF/App.php(3023): XF\Container->create('service', 'XF:Thread\\Creat...', Array)
#9 src/XF/Service/AbstractService.php(79): XF\App->service('XF:Thread\\Creat...', Object(XFMG\XF\Entity\Forum))
#10 src/addons/BS/MultiAccountDetector/Service/Thread/ReportDuplicate.php(49): XF\Service\AbstractService->service('XF:Thread\\Creat...', Object(XFMG\XF\Entity\Forum))
#11 src/XF.php(625): BS\MultiAccountDetector\Service\Thread\ReportDuplicate->BS\MultiAccountDetector\Service\Thread\{closure}()
#12 src/addons/BS/MultiAccountDetector/Service/Thread/ReportDuplicate.php(70): XF::asVisitor(Object(MMO\ReputationSystem\XF\Entity\User), Object(Closure))
#13 src/addons/BS/MultiAccountDetector/Repository/MultiAccount.php(109): BS\MultiAccountDetector\Service\Thread\ReportDuplicate->create()
#14 src/addons/BS/MultiAccountDetector/Entity/MultiAccount.php(93): BS\MultiAccountDetector\Repository\MultiAccount->createThreadReport(Object(BS\MultiAccountDetector\Entity\MultiAccount))
#15 src/addons/BS/MultiAccountDetector/Entity/MultiAccount.php(85): BS\MultiAccountDetector\Entity\MultiAccount->_createThreadReport()
#16 src/XF/Mvc/Entity/Entity.php(1272): BS\MultiAccountDetector\Entity\MultiAccount->_postSave()
#17 src/addons/BS/MultiAccountDetector/Repository/MultiAccount.php(91): XF\Mvc\Entity\Entity->save()
#18 src/addons/BS/MultiAccountDetector/XF/Pub/Controller/Member.php(104): BS\MultiAccountDetector\Repository\MultiAccount->createMultiAccountReport(Object(MMO\ReputationSystem\XF\Entity\User))
#19 src/XF/Mvc/Dispatcher.php(352): BS\MultiAccountDetector\XF\Pub\Controller\Member->actionMadCheck(Object(XF\Mvc\ParameterBag))
#20 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Member', 'MadCheck', Object(XF\Mvc\RouteMatch), Object(ThemeHouse\AttachmentsPlus\XF\Pub\Controller\Member), NULL)
#21 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(ThemeHouse\AttachmentsPlus\XF\Pub\Controller\Member), NULL)
#22 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#23 src/XF/App.php(2353): XF\Mvc\Dispatcher->run()
#24 src/XF.php(524): XF\App->run()
#25 index.php(20): XF::runApp('XF\\Pub\\App')
#26 {main}

-------------

Previous InvalidArgumentException: Attempted to convert NULL to string/binary - src/XF/Mvc/Entity/ValueFormatter.php:138
#0 src/XF/Mvc/Entity/Entity.php(761): XF\Mvc\Entity\ValueFormatter->castValueToType(NULL, 5, Array)
#1 src/XF/Mvc/Entity/Entity.php(643): XF\Mvc\Entity\Entity->_castValueToType(NULL, 'username', 5, Array)
#2 src/XF/Mvc/Entity/Entity.php(572): XF\Mvc\Entity\Entity->set('username', NULL)
#3 src/XF/Service/Thread/Creator.php(109): XF\Mvc\Entity\Entity->__set('username', NULL)
#4 src/XF/Service/Thread/Creator.php(73): XF\Service\Thread\Creator->setUser(Object(MMO\ReputationSystem\XF\Entity\User))
#5 src/XF/Service/Thread/Creator.php(57): XF\Service\Thread\Creator->setupDefaults()
#6 src/XF/Container.php(276): XF\Service\Thread\Creator->__construct(Object(XF\Pub\App), Object(XFMG\XF\Entity\Forum))
#7 src/XF/App.php(1710): XF\Container->createObject('XF\\Service\\Thre...', Array)
#8 src/XF/Container.php(234): XF\App->XF\{closure}('XF\\Service\\Thre...', Array, Object(XF\Container))
#9 src/XF/App.php(3023): XF\Container->create('service', 'XF:Thread\\Creat...', Array)
#10 src/XF/Service/AbstractService.php(79): XF\App->service('XF:Thread\\Creat...', Object(XFMG\XF\Entity\Forum))
#11 src/addons/BS/MultiAccountDetector/Service/Thread/ReportDuplicate.php(49): XF\Service\AbstractService->service('XF:Thread\\Creat...', Object(XFMG\XF\Entity\Forum))
#12 src/XF.php(625): BS\MultiAccountDetector\Service\Thread\ReportDuplicate->BS\MultiAccountDetector\Service\Thread\{closure}()
#13 src/addons/BS/MultiAccountDetector/Service/Thread/ReportDuplicate.php(70): XF::asVisitor(Object(MMO\ReputationSystem\XF\Entity\User), Object(Closure))
#14 src/addons/BS/MultiAccountDetector/Repository/MultiAccount.php(109): BS\MultiAccountDetector\Service\Thread\ReportDuplicate->create()
#15 src/addons/BS/MultiAccountDetector/Entity/MultiAccount.php(93): BS\MultiAccountDetector\Repository\MultiAccount->createThreadReport(Object(BS\MultiAccountDetector\Entity\MultiAccount))
#16 src/addons/BS/MultiAccountDetector/Entity/MultiAccount.php(85): BS\MultiAccountDetector\Entity\MultiAccount->_createThreadReport()
#17 src/XF/Mvc/Entity/Entity.php(1272): BS\MultiAccountDetector\Entity\MultiAccount->_postSave()
#18 src/addons/BS/MultiAccountDetector/Repository/MultiAccount.php(91): XF\Mvc\Entity\Entity->save()
#19 src/addons/BS/MultiAccountDetector/XF/Pub/Controller/Member.php(104): BS\MultiAccountDetector\Repository\MultiAccount->createMultiAccountReport(Object(MMO\ReputationSystem\XF\Entity\User))
#20 src/XF/Mvc/Dispatcher.php(352): BS\MultiAccountDetector\XF\Pub\Controller\Member->actionMadCheck(Object(XF\Mvc\ParameterBag))
#21 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Member', 'MadCheck', Object(XF\Mvc\RouteMatch), Object(ThemeHouse\AttachmentsPlus\XF\Pub\Controller\Member), NULL)
#22 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(ThemeHouse\AttachmentsPlus\XF\Pub\Controller\Member), NULL)
#23 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#24 src/XF/App.php(2353): XF\Mvc\Dispatcher->run()
#25 src/XF.php(524): XF\App->run()
#26 index.php(20): XF::runApp('XF\\Pub\\App')
#27 {main}



Request state
array(4) {
  ["url"] => string(18) "/members/mad-check"
  ["referrer"] => string(35) "https://XXX.org/register/complete"
  ["_GET"] => array(1) {
    ["/members/mad-check"] => string(0) ""
  }
  ["_POST"] => array(6) {
    ["fpJs"] => string(32) "13e8c950ee46a51fa64fcdcef9ac1287"
    ["ec"] => array(1) {
      [0] => string(32) "52d2f307f3e0f2b100d4ef826816cccb"
    }
    ["_xfRequestUri"] => string(18) "/register/complete"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}
 

021

021
Premium
Developer
Jun 11, 2020
556
443
63
santa_claus said:
Hi,

There is a bug at the admin panel, can you please check it?
Code: 
InvalidArgumentException: MAD thread report creation error: Attempted to convert NULL to string/binary [username] src/XF/Mvc/Entity/Entity.php:765
Generated by: iHate Oct 25, 2022 at 3:35 AM
Stack trace
#0 src/XF/Mvc/Entity/Entity.php(643): XF\Mvc\Entity\Entity->_castValueToType(NULL, 'username', 5, Array)
#1 src/XF/Mvc/Entity/Entity.php(572): XF\Mvc\Entity\Entity->set('username', NULL)
#2 src/XF/Service/Thread/Creator.php(109): XF\Mvc\Entity\Entity->__set('username', NULL)
#3 src/XF/Service/Thread/Creator.php(73): XF\Service\Thread\Creator->setUser(Object(MMO\ReputationSystem\XF\Entity\User))
#4 src/XF/Service/Thread/Creator.php(57): XF\Service\Thread\Creator->setupDefaults()
#5 src/XF/Container.php(276): XF\Service\Thread\Creator->__construct(Object(XF\Pub\App), Object(XFMG\XF\Entity\Forum))
#6 src/XF/App.php(1710): XF\Container->createObject('XF\\Service\\Thre...', Array)
#7 src/XF/Container.php(234): XF\App->XF\{closure}('XF\\Service\\Thre...', Array, Object(XF\Container))
#8 src/XF/App.php(3023): XF\Container->create('service', 'XF:Thread\\Creat...', Array)
#9 src/XF/Service/AbstractService.php(79): XF\App->service('XF:Thread\\Creat...', Object(XFMG\XF\Entity\Forum))
#10 src/addons/BS/MultiAccountDetector/Service/Thread/ReportDuplicate.php(49): XF\Service\AbstractService->service('XF:Thread\\Creat...', Object(XFMG\XF\Entity\Forum))
#11 src/XF.php(625): BS\MultiAccountDetector\Service\Thread\ReportDuplicate->BS\MultiAccountDetector\Service\Thread\{closure}()
#12 src/addons/BS/MultiAccountDetector/Service/Thread/ReportDuplicate.php(70): XF::asVisitor(Object(MMO\ReputationSystem\XF\Entity\User), Object(Closure))
#13 src/addons/BS/MultiAccountDetector/Repository/MultiAccount.php(109): BS\MultiAccountDetector\Service\Thread\ReportDuplicate->create()
#14 src/addons/BS/MultiAccountDetector/Entity/MultiAccount.php(93): BS\MultiAccountDetector\Repository\MultiAccount->createThreadReport(Object(BS\MultiAccountDetector\Entity\MultiAccount))
#15 src/addons/BS/MultiAccountDetector/Entity/MultiAccount.php(85): BS\MultiAccountDetector\Entity\MultiAccount->_createThreadReport()
#16 src/XF/Mvc/Entity/Entity.php(1272): BS\MultiAccountDetector\Entity\MultiAccount->_postSave()
#17 src/addons/BS/MultiAccountDetector/Repository/MultiAccount.php(91): XF\Mvc\Entity\Entity->save()
#18 src/addons/BS/MultiAccountDetector/XF/Pub/Controller/Member.php(104): BS\MultiAccountDetector\Repository\MultiAccount->createMultiAccountReport(Object(MMO\ReputationSystem\XF\Entity\User))
#19 src/XF/Mvc/Dispatcher.php(352): BS\MultiAccountDetector\XF\Pub\Controller\Member->actionMadCheck(Object(XF\Mvc\ParameterBag))
#20 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Member', 'MadCheck', Object(XF\Mvc\RouteMatch), Object(ThemeHouse\AttachmentsPlus\XF\Pub\Controller\Member), NULL)
#21 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(ThemeHouse\AttachmentsPlus\XF\Pub\Controller\Member), NULL)
#22 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#23 src/XF/App.php(2353): XF\Mvc\Dispatcher->run()
#24 src/XF.php(524): XF\App->run()
#25 index.php(20): XF::runApp('XF\\Pub\\App')
#26 {main}

-------------

Previous InvalidArgumentException: Attempted to convert NULL to string/binary - src/XF/Mvc/Entity/ValueFormatter.php:138
#0 src/XF/Mvc/Entity/Entity.php(761): XF\Mvc\Entity\ValueFormatter->castValueToType(NULL, 5, Array)
#1 src/XF/Mvc/Entity/Entity.php(643): XF\Mvc\Entity\Entity->_castValueToType(NULL, 'username', 5, Array)
#2 src/XF/Mvc/Entity/Entity.php(572): XF\Mvc\Entity\Entity->set('username', NULL)
#3 src/XF/Service/Thread/Creator.php(109): XF\Mvc\Entity\Entity->__set('username', NULL)
#4 src/XF/Service/Thread/Creator.php(73): XF\Service\Thread\Creator->setUser(Object(MMO\ReputationSystem\XF\Entity\User))
#5 src/XF/Service/Thread/Creator.php(57): XF\Service\Thread\Creator->setupDefaults()
#6 src/XF/Container.php(276): XF\Service\Thread\Creator->__construct(Object(XF\Pub\App), Object(XFMG\XF\Entity\Forum))
#7 src/XF/App.php(1710): XF\Container->createObject('XF\\Service\\Thre...', Array)
#8 src/XF/Container.php(234): XF\App->XF\{closure}('XF\\Service\\Thre...', Array, Object(XF\Container))
#9 src/XF/App.php(3023): XF\Container->create('service', 'XF:Thread\\Creat...', Array)
#10 src/XF/Service/AbstractService.php(79): XF\App->service('XF:Thread\\Creat...', Object(XFMG\XF\Entity\Forum))
#11 src/addons/BS/MultiAccountDetector/Service/Thread/ReportDuplicate.php(49): XF\Service\AbstractService->service('XF:Thread\\Creat...', Object(XFMG\XF\Entity\Forum))
#12 src/XF.php(625): BS\MultiAccountDetector\Service\Thread\ReportDuplicate->BS\MultiAccountDetector\Service\Thread\{closure}()
#13 src/addons/BS/MultiAccountDetector/Service/Thread/ReportDuplicate.php(70): XF::asVisitor(Object(MMO\ReputationSystem\XF\Entity\User), Object(Closure))
#14 src/addons/BS/MultiAccountDetector/Repository/MultiAccount.php(109): BS\MultiAccountDetector\Service\Thread\ReportDuplicate->create()
#15 src/addons/BS/MultiAccountDetector/Entity/MultiAccount.php(93): BS\MultiAccountDetector\Repository\MultiAccount->createThreadReport(Object(BS\MultiAccountDetector\Entity\MultiAccount))
#16 src/addons/BS/MultiAccountDetector/Entity/MultiAccount.php(85): BS\MultiAccountDetector\Entity\MultiAccount->_createThreadReport()
#17 src/XF/Mvc/Entity/Entity.php(1272): BS\MultiAccountDetector\Entity\MultiAccount->_postSave()
#18 src/addons/BS/MultiAccountDetector/Repository/MultiAccount.php(91): XF\Mvc\Entity\Entity->save()
#19 src/addons/BS/MultiAccountDetector/XF/Pub/Controller/Member.php(104): BS\MultiAccountDetector\Repository\MultiAccount->createMultiAccountReport(Object(MMO\ReputationSystem\XF\Entity\User))
#20 src/XF/Mvc/Dispatcher.php(352): BS\MultiAccountDetector\XF\Pub\Controller\Member->actionMadCheck(Object(XF\Mvc\ParameterBag))
#21 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Member', 'MadCheck', Object(XF\Mvc\RouteMatch), Object(ThemeHouse\AttachmentsPlus\XF\Pub\Controller\Member), NULL)
#22 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(ThemeHouse\AttachmentsPlus\XF\Pub\Controller\Member), NULL)
#23 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#24 src/XF/App.php(2353): XF\Mvc\Dispatcher->run()
#25 src/XF.php(524): XF\App->run()
#26 index.php(20): XF::runApp('XF\\Pub\\App')
#27 {main}



Request state
array(4) {
  ["url"] => string(18) "/members/mad-check"
  ["referrer"] => string(35) "https://XXX.org/register/complete"
  ["_GET"] => array(1) {
    ["/members/mad-check"] => string(0) ""
  }
  ["_POST"] => array(6) {
    ["fpJs"] => string(32) "13e8c950ee46a51fa64fcdcef9ac1287"
    ["ec"] => array(1) {
      [0] => string(32) "52d2f307f3e0f2b100d4ef826816cccb"
    }
    ["_xfRequestUri"] => string(18) "/register/complete"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}
Click to expand...
Hello. Fill "Thread report duplicate creator" option to fix it
 

xoop

X
Jun 22, 2020
31
17
8
Hi!
Possible Sql-inj into tables:
xf_mad_user_evercookie
xf_mad_user_fingerprint
+ Bug (ability to make anyone of multi-account of anyone).

Example. Sending request:
792200208262673737.owasp.org or longer.
Receiving
If long, than:
Code: 
XF\Db\Exception: MySQL query error [1406]: Data too long for column 'fingerprint' at row 1 src/XF/Db/AbstractStatement.php:230
Code: 
XF\Db\Exception: MySQL query error [1406]: Data too long for column 'evercookie' at row 1 src/XF/Db/AbstractStatement.php:230

If <40 symbols (limit), than writing directly into DB without errors:
xf_mad_user_evercookie
1.png
xf_mad_user_fingerprint
2.png

Also in this way you can make any ID multi-account of any other ID.

Thx for fixing.
 
Last edited:
  • Like
Reactions: 021

021

021
Premium
Developer
Jun 11, 2020
556
443
63
xoop said:
+ Bug (ability to make anyone of multi-account of anyone).
Click to expand...
Hello. You cannot make a multi-account from anyone, because the added records are tied to the account from which you are authorized, and it is impossible to guess the fingerprint and evercookie values for another account that you do not own.
 

alexfl

A
Dec 17, 2022
5
0
1
Is php 8.x not supported yet? It seems the addon has stopped detecting multi-accounts on my board and I am trying to find out why. Recently updated php version so that's why I am considering that ..
 

021

021
Premium
Developer
Jun 11, 2020
556
443
63
alexfl said:
Is php 8.x not supported yet? It seems the addon has stopped detecting multi-accounts on my board and I am trying to find out why. Recently updated php version so that's why I am considering that ..
Click to expand...
Hello. In the near future I will check for compatibility with PHP 8.1 and release an update if necessary.
 

alexfl

A
Dec 17, 2022
5
0
1
Thanks, I went back to 7.4 on my forum but still multi-account detector seems to have stopped working, it seems stuck at 490 multi-accounts since 7-1-2023. I'm however sure there have been matching evercookies after that.
 

021

021
Premium
Developer
Jun 11, 2020
556
443
63
021 updated [BS] Multi-account detector with a new update entry:

1.7.0

New options
  • Fingerprint detected user group – this group will be automatically assigned to the user if he falls under the definition of a multi-account using the fingerprint method.
  • Evercookie detected user group – this group will be automatically assigned to the user if he falls under the definition of a multi-account using the evercookie method.

View attachment 529
Click to expand...

Read the rest of this update entry...
 

gc99

G
Sep 6, 2021
2
0
1
something not working right for me upgrading from original version
XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x91\x8B\x0A[...' for column 'phrase_text' at row 1 in src/XF/Db/AbstractStatement.php at line 230
  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
  3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
  4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
  5. XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1521
  6. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
  7. XF\Mvc\Entity\Entity->save() in src/XF/AddOn/DataType/Phrase.php at line 100
  8. XF\AddOn\DataType\Phrase->importAddOnData() in src/XF/Job/AddOnData.php at line 110
  9. XF\Job\AddOnData->run() in src/XF/Job/Manager.php at line 260
  10. XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
  11. XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 118
  12. XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 122
  13. XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
  14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
  15. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  16. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
  18. XF\App->run() in src/XF.php at line 524
  19. XF::runApp() in admin.php at line 13
 

Attachments

  • Cxapture.PNG
    Cxapture.PNG
    29.7 KB · Views: 0

gc99

G
Sep 6, 2021
2
0
1
gc99 said:
something not working right for me upgrading from original version
XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x91\x8B\x0A[...' for column 'phrase_text' at row 1 in src/XF/Db/AbstractStatement.php at line 230
  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
  3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
  4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
  5. XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1521
  6. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
  7. XF\Mvc\Entity\Entity->save() in src/XF/AddOn/DataType/Phrase.php at line 100
  8. XF\AddOn\DataType\Phrase->importAddOnData() in src/XF/Job/AddOnData.php at line 110
  9. XF\Job\AddOnData->run() in src/XF/Job/Manager.php at line 260
  10. XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
  11. XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 118
  12. XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 122
  13. XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
  14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
  15. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  16. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
  18. XF\App->run() in src/XF.php at line 524
  19. XF::runApp() in admin.php at line 13
Click to expand...
totally 100% my fault , I ran database conversion but did not add line to config
line is on config ran it again said it had to convert 240 tables

no server errors and has been upgraded sorry for the mess
 

xoop

X
Jun 22, 2020
31
17
8
Suggestions for future.
1. It's impossible to use FingerpringJS Pro paid version, because it's really consume for 12 hours 1 month's paid limit even for small forum. So it's abnormally expensive to use FingerpringJS Pro now. Maybe in the future it will be possible to split the number of requests as editable option. Like "Check cooldown" option now, but from FingerpringJS+Evercookie and FingerpringJS Pro separately.
I.e.
FingerpringJS + Evercookie - 10 mins
FingerpringJS Pro - 1 day
Or something like that.

2. To upgrade fingerprintjs library from 3.3.6 to v3.4.0
And fingerprintjs pro from 3.7.1 to v3.8.2
 
Last edited:
  • Like
Reactions: 021
You must log in or register to reply here.
Categories

Members online

Total: 28 (members: 1, guests: 27)
Top Bottom