Image Optimizer for XF 2.0

Image Optimizer for XF 2.0 [Paid] 2.1.8

No permission to buy ($29.00)
@truonglv

Code:
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
Code:
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?
 
Is it possible to set it so that only new attachments after installation are optimized instead of going back and queuing all existing attachments?

If you disable the [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:

You might have something wrong. I also started a week ago and these are my results so far:

Screen Shot 2022-01-15 at 5.35.11 PM.webp
 
My guess is the uploaded images are already optimized. See that on my forum also. Old images were optimized, current images have little optimization.
 
Are the default settings best to go with? Or should adjustments be made? What settings is everyone else using?
 
Last edited:
Nothing special. Just remember I ran this tool with images that were up to 15+ years old.
The current uploaded images are way more optimized already so the savings are way less
 
Top Bottom