JaJuMa Ultimate Image Optimizer 2.3.29

DomiGuy said:

Anyone else come across a problem with the database prefix?

Extension installs and is able to be configured however when we go to the status page we get 'table doesn't exist' as the prefix is missing

3 exception(s):
Exception #0 (Magento\Framework\DB\Adapter\TableNotFoundException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XXXXXX_magento.jajuma_image_optimizer' doesn't exist, query was: SELECT `jajuma_image_optimizer`.`image_id` FROM `jajuma_image_optimizer` WHERE (status = 'success')
Exception #1 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XXXXXX_magento.jajuma_image_optimizer' doesn't exist, query was: SELECT `jajuma_image_optimizer`.`image_id` FROM `jajuma_image_optimizer` WHERE (status = 'success')
Exception #2 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XXXXXX_magento.jajuma_image_optimizer' doesn't exist

If we change the database table name to match the above it also fails as it appears it is also looking for the prefix table in the same query.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XXXXXX_magento.mage_jajuma_image_optimizer' doesn't exist, query was: SELECT `main_table`.* FROM `mage_jajuma_image_optimizer` AS `main_table` LIMIT 20Exception in /home/XXXXXX/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:603

Click to expand...

CREATE TABLE `jajuma_image_optimizer` (
  `image_id` int(10) UNSIGNED NOT NULL COMMENT 'Image ID',
  `path` varchar(255) DEFAULT NULL COMMENT 'Image Path',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `origin_size` int(11) DEFAULT NULL COMMENT 'Original Size',
  `optimize_size` int(11) DEFAULT NULL COMMENT 'Original Size',
  `percent` int(11) DEFAULT NULL COMMENT 'Percent',
  `highres` varchar(255) DEFAULT NULL COMMENT 'High-Res Version',
  `message` varchar(255) DEFAULT NULL COMMENT 'Message',
  `avif_optimize_size` int(11) DEFAULT NULL COMMENT 'Avif Optimize Size',
  `avif_percent` int(11) DEFAULT NULL COMMENT 'Avif Percent'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ultimate Image Optimizer Table';
ALTER TABLE `jajuma_image_optimizer`
  ADD PRIMARY KEY (`image_id`);
ALTER TABLE `jajuma_image_optimizer` ADD FULLTEXT KEY `JAJUMA_IMAGE_OPTIMIZER_STATUS` (`status`);
ALTER TABLE `jajuma_image_optimizer`
  MODIFY `image_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Image ID';
COMMIT;

Powlowski Carlo said:

file permission issue.now you can get sql from here

SQL:

CREATE TABLE `jajuma_image_optimizer` (
  `image_id` int(10) UNSIGNED NOT NULL COMMENT 'Image ID',
  `path` varchar(255) DEFAULT NULL COMMENT 'Image Path',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `origin_size` int(11) DEFAULT NULL COMMENT 'Original Size',
  `optimize_size` int(11) DEFAULT NULL COMMENT 'Original Size',
  `percent` int(11) DEFAULT NULL COMMENT 'Percent',
  `highres` varchar(255) DEFAULT NULL COMMENT 'High-Res Version',
  `message` varchar(255) DEFAULT NULL COMMENT 'Message',
  `avif_optimize_size` int(11) DEFAULT NULL COMMENT 'Avif Optimize Size',
  `avif_percent` int(11) DEFAULT NULL COMMENT 'Avif Percent'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ultimate Image Optimizer Table';
ALTER TABLE `jajuma_image_optimizer`
  ADD PRIMARY KEY (`image_id`);
ALTER TABLE `jajuma_image_optimizer` ADD FULLTEXT KEY `JAJUMA_IMAGE_OPTIMIZER_STATUS` (`status`);
ALTER TABLE `jajuma_image_optimizer`
  MODIFY `image_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Image ID';
COMMIT;

Click to expand...

bilka said:

This module does not work for me on M 2.4.6-p2
Do you have a newer version?

In ClassReader.php line 34:
Class "Jajuma\ImageOptimizerUltimate\Console\Command\Optimize" does not exist

Click to expand...