Yes, exactly
![[DigitalPoint] App for Cloudflare®](/community/data/resource_icons/8/8750.jpg?1692633961){kind=icon}
[DigitalPoint] App for Cloudflare® 1.9.6
- Thread starter digitalpoint
- Start date
Yes, exactly
digitalpoint
Well-known member
Can you post a screenshot of your API token from the Cloudflare dashboard? Would like to prevent whatever is happening for you, but I'm not able to replicate it, no matter how jacked up I give permissions to a test token.
I solved it thanks.
@digitalpoint can you check this? Xon said maybe you can resolve this slow query:
@digitalpoint can you check this? Xon said maybe you can resolve this slow query:
Code:
Exception: Slow query: 20.2705 seconds, /***/job.php src/addons/SV/SlowQueryLogger/Db/Mysqli/SlowQueryLogAdapter.php:372
Generated by: Unknown account Sep 29, 2025 at 7:17 PM
Stack trace
#0 src/addons/SV/SlowQueryLogger/Db/Mysqli/SlowQueryLogAdapter.php(159): SV\SlowQueryLogger\Db\Mysqli\SlowQueryLogAdapter->SV\SlowQueryLogger\Db\Mysqli\{closure}()
#1 src/addons/SV/SlowQueryLogger/Db/Mysqli/SlowQueryLogAdapter.php(371): SV\SlowQueryLogger\Db\Mysqli\SlowQueryLogAdapter->withOriginalDbAdapter(Object(Closure))
#2 src/XF/Db/Mysqli/Statement.php(110): SV\SlowQueryLogger\Db\Mysqli\SlowQueryLogAdapter->logQueryCompletion()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1428): XF\Db\AbstractAdapter->query('
SELECT `xf_...')
#5 src/addons/DigitalPoint/Cloudflare/Repository/Geo.php(14): XF\Mvc\Entity\Finder->fetch(1000)
#6 src/addons/DigitalPoint/Cloudflare/Cron/CleanUp.php(15): DigitalPoint\Cloudflare\Repository\Geo->deleteUnusedGeoData()
#7 src/XF/Job/Cron.php(37): DigitalPoint\Cloudflare\Cron\CleanUp::runHourlyCleanUp(Object(XF\Entity\CronEntry))
#8 src/XF/Job/Manager.php(260): XF\Job\Cron->run(9.9802)
#9 src/addons/SV/SlowQueryLogger/XF/Job/Manager.php(34): XF\Job\Manager->runJobInternal(Array, 9.9802)
#10 src/XF/Job/Manager.php(202): SV\SlowQueryLogger\XF\Job\Manager->runJobInternal(Array, 9.9802)
#11 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 9.9802)
#12 job.php(43): XF\Job\Manager->runQueue(false, 10)
#13 {main}
Request state
array(4) {
["url"] => string(15) "/***/job.php"
["referrer"] => string(81) "https://www.***.net/***/konu/toplam-5-bin-tlye-ekipman-oenerisi.3930172/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}digitalpoint
Well-known member
Unfortunately, there isn't a realistic way to make that query faster. It's one of the reasons it's decoupled from the user interface (doesn't slow down users, runs in a cron task only).
It's searching for records without a matching record in a different table via a join, so it's not able to use a table index. The only options you have to not end up with a slow query in that cron task is:
- Don't use the Cloudflare geotargetting feature (can be disabled under
Options -> External service providers -> Log IP address locations - Alternately, you could choose to not clean up orphaned records and just leave them (they don't hurt anything, they just take space in your database) by disabling the
Hourly clean upcron task for this addon. You could also run it less often than hourly... like monthly or something if you'd rather use it, but not end up with a slow query every hour.
Can you send a link to this? I can't find it...
digitalpoint
Well-known member
Did you go to XenForo options?
Oh I found it thanks!
