20, every 5 minuteswhat's a safe number to run at? I'm on my own server
20, every 5 minutes
Then keep an eye on your CPU Utilization.Im doing 400 every 5...
XF\Db\DuplicateKeyException: Job Truonglv\ImageOptimizer\Job\Optimizer: MySQL query error [1062]: Duplicate entry '193883-attachment_data' for key 'tl_image_optimizer_log.content' src/XF/Db/AbstractStatement.php:230
INSERT INTO `tl_image_optimizer_log` (`new_size`, `old_size`, `processed_time`, `content_id`, `content_type`, `log_date`) VALUES (?, ?, ?, ?, ?, ?)
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `t...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1514): XF\Db\AbstractAdapter->insert('tl_image_optimi...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1246): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/Truonglv/ImageOptimizer/ContentData/AbstractData.php(52): XF\Mvc\Entity\Entity->save(false)
#7 src/addons/Truonglv/ImageOptimizer/Job/Optimizer.php(119): Truonglv\ImageOptimizer\ContentData\AbstractData->log('attachment_data', 193883, Array)
#8 src/addons/Truonglv/ImageOptimizer/Job/Optimizer.php(66): Truonglv\ImageOptimizer\Job\Optimizer->processImages(Array, 'attachment_data', Object(XF\Timer), 193883)
#9 src/XF/Job/Manager.php(260): Truonglv\ImageOptimizer\Job\Optimizer->run(8)
#10 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)
#11 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 8)
#12 job.php(43): XF\Job\Manager->runQueue(false, 8)
#13 {main}
Is it possible to set it so that only new attachments after installation are optimized instead of going back and queuing all existing attachments?
[tl] Image Optimizer
cron job in the Admin CP, I don't think it will optimize the older images.How is it working for you so far?
I'm a week into it so far and the results are pretty terrible up to this point:
Nothing in your XF error log? I wonder if maybe one of your optimization softwares is misconfigured or not working as expected.
What your optimize options? Also did your images optimize before?How is it working for you so far?
I'm a week into it so far and the results are pretty terrible up to this point:
View attachment 263398
I have already asked him that, but he doesn't answer that question.What your optimize options? Also did your images optimize before?
How is it working for you so far?
I'm a week into it so far and the results are pretty terrible up to this point:
View attachment 263398
What your optimize options? Also did your images optimize before?
I have already asked him that, but he doesn't answer that question.
What settings are you using?It also optimizes new uploads.
My current stats:
Code:Total New Size 298.7 GB Total Old Size 630.7 GB Saving 52.63%
How are current uploaded images way more optimized compared to older attachments?The current uploaded images are way more optimized already so the savings are way less
We use essential cookies to make this site work, and optional cookies to enhance your experience.