this is the structure from the extension archive:
- app
- js
- lib
- skin
this is the instructions:
1. Navigate to Admin > Tools > Compilation and deactivate the compilation mode for your store.
2. Check if your Magento store cache is enabled.
3. Unpack all files from extension archive into your magento store root directory.
4. Refresh your magento store cache.
5. Logout from your store admin and then login back, to refresh your admin user access rights.
6. Navigate to System > Configuration > Templates-Master > Page Speed and enable extension for any store you need.
this is exactly the path I have taken.
But no table is created in the database. All other functions of the extension work.
the path to the mysql4-install-0.1.0.php:
app/code/local/TM/Pagespeed/sql/tm_pagespeed_setup/mysql4-install-0.1.0.php
<?php
//throw new Exception;
/* @var $installer Mage_Core_Model_Resource_Setup */
$installer = $this;
$installer->startSetup();
$filenameSize = TM_Pagespeed_Model_Smu**bleep**::FILENAME_SIZE_LIMIT;
$table = $installer->getConnection()
->newTable($installer->getTable('tm_pagespeed_smu**bleep**'))
->addColumn(
'id', Varien_Db_Ddl_Table::TYPE_INTEGER, 11, array(
'identity' => true,
'unsigned' => true,
'nullable' => false,
'primary' => true,
), 'ID'
)
->addColumn(
'path', Varien_Db_Ddl_Table::TYPE_TEXT, $filenameSize, array(
'nullable' => false,
), 'Path'
)
->addColumn(
'source', Varien_Db_Ddl_Table::TYPE_TEXT, $filenameSize, array(
'nullable' => false,
), 'Source'
)
->addColumn(
'src_size', Varien_Db_Ddl_Table::TYPE_INTEGER, 7, array(
'unsigned' => true,
'nullable' => false,
), 'Source size'
)
->addColumn(
'dest_size', Varien_Db_Ddl_Table::TYPE_INTEGER, 7, array(
'unsigned' => true,
'nullable' => false,
), 'Destanation size'
)
->addColumn(
'percent', Varien_Db_Ddl_Table::TYPE_SMALLINT, 5, array(
'unsigned' => true,
'nullable' => true,
), 'Percent'
)
->addColumn(
'smushed', Varien_Db_Ddl_Table::TYPE_TINYINT, 1, array(
'nullable' => false,
'default' => 0,
), 'Optimized'
)
->addColumn(
'created', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, 10, array(
'unsigned' => true,
'nullable' => false,
'default' => Varien_Db_Ddl_Table::TIMESTAMP_INIT,
), 'Created'
);
$installer->getConnection()->createTable($table);
$installer->endSetup();the code seems to be okay.
Is there another way to run this file?
Or extract the SQL query from the file and simply execute it manually in the DB?
