• Hello Guest,
    There are new packages allow you download any resources with a single purchase. Click here to upgrade your account ;)
Image Optimizer for XF 2.0

Image Optimizer for XF 2.0 [Paid] 2.0.1

No permission to buy ($29.00)

Truonglv

Staff member
Tech Support
truonglv submitted a new resource:

Image Optimizer for XF 2.0 - Optimize all attachments in your forum to save disk space.

  • Add-on have provide a powerful settings in ACP options. You MUST settings option before running optimize images.
  • All files will be overwrite then you cannot revert the file to original.

DESCRIPTION
Optimizing all images which stored in XenForo to lower size and do not loss quality.

Supported:
  • XenForo default attachments
  • Image Proxy Cache
Read more about this resource...
 

Amin Sabet

New Member
Getting these errors now:

PHP:
[LIST]
[*]XF\Db\Exception: MySQL statement prepare error [1146]: Table 'dev_talkemount.tl_image_optimizer_log' doesn't exist
[*]src/XF/Db/AbstractStatement.php:212
[*]Generated by: Amin Sabet
[*]Nov 25, 2018 at 10:44 AM
[/LIST]
Stack trace
            SELECT SUM(old_size) as total_old, SUM(new_size) AS total_new
            FROM tl_image_optimizer_log
       
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(86): XF\Db\AbstractAdapter->query('\n            SE...', Array)
#5 src/addons/Truonglv/ImageOptimizer/Repository/Log.php(40): XF\Db\AbstractAdapter->fetchRow('\n            SE...')
#6 src/addons/Truonglv/ImageOptimizer/XF/Admin/Controller/Tools.php(85): Truonglv\ImageOptimizer\Repository\Log->getSumDataStats()
#7 src/XF/Mvc/Dispatcher.php(249): Truonglv\ImageOptimizer\XF\Admin\Controller\Tools->actionIOLogs(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'IoLogs', 'html', Object(XF\Mvc\ParameterBag), 'tools', Object(Truonglv\ImageOptimizer\XF\Admin\Controller\Tools), NULL)
#9 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#11 src/XF.php(329): XF\App->run()
#12 admin.php(13): XF::runApp('XF\\Admin\\App')
#13 {main}
Request state
array(4) {
  ["url"] => string(24) "/admin.php?tools/io-logs"
  ["referrer"] => string(49) "http://dev.talkemount.com/admin.php?tools/io-logs"
  ["_GET"] => array(1) {
    ["tools/io-logs"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
}
PHP:
[LIST]
[*]XF\Db\Exception: MySQL statement prepare error [1146]: Table 'dev_talkemount.tl_image_optimizer_log' doesn't exist
[*]src/XF/Db/AbstractStatement.php:212
[*]Generated by: Amin Sabet
[*]Nov 25, 2018 at 10:43 AM
[/LIST]
Stack trace
            SELECT SUM(old_size) as total_old, SUM(new_size) AS total_new
            FROM tl_image_optimizer_log
       
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(86): XF\Db\AbstractAdapter->query('\n            SE...', Array)
#5 src/addons/Truonglv/ImageOptimizer/Repository/Log.php(40): XF\Db\AbstractAdapter->fetchRow('\n            SE...')
#6 src/addons/Truonglv/ImageOptimizer/XF/Admin/Controller/Tools.php(85): Truonglv\ImageOptimizer\Repository\Log->getSumDataStats()
#7 src/XF/Mvc/Dispatcher.php(249): Truonglv\ImageOptimizer\XF\Admin\Controller\Tools->actionIOLogs(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'IoLogs', 'html', Object(XF\Mvc\ParameterBag), 'tools', Object(Truonglv\ImageOptimizer\XF\Admin\Controller\Tools), NULL)
#9 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#11 src/XF.php(329): XF\App->run()
#12 admin.php(13): XF::runApp('XF\\Admin\\App')
#13 {main}
Request state
array(4) {
  ["url"] => string(24) "/admin.php?tools/io-logs"
  ["referrer"] => string(44) "http://dev.talkemount.com/admin.php?add-ons/"
  ["_GET"] => array(1) {
    ["tools/io-logs"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
}
 

Amin Sabet

New Member
@truonglv

I am getting this error:

PHP:
XF\Db\Exception: MySQL statement prepare error [1146]: Table 'dev_talkemount.tl_image_optimizer_log' doesn't exist in src/XF/Db/AbstractStatement.phpat line 217
[LIST=1]
[*]XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
[*]XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
[*]XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
[*]XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
[*]XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 96
[*]XF\Db\AbstractAdapter->fetchRow() in src/addons/Truonglv/ImageOptimizer/Repository/Log.php at line 40
[*]Truonglv\ImageOptimizer\Repository\Log->getSumDataStats() in src/addons/Truonglv/ImageOptimizer/XF/Admin/Controller/Tools.php at line85
[*]Truonglv\ImageOptimizer\XF\Admin\Controller\Tools->actionIOLogs() in src/XF/Mvc/Dispatcher.php at line 321
[*]XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
[*]XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
[*]XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
[*]XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2170
[*]XF\App->run() in src/XF.php at line 392
[*]XF::runApp() in admin.php at line 13
[/LIST]
 

cloferba

New Member
It optimized till attachment 12482
1543640528023.png

However, new attachments have been created (latest is 66486) but your addon isn't optimizing them or even reached the addon ID 66000

There are no errors in the admin panel so the task seems to be running OK but it isn't optimizing new attachments
 
Top