Use this code in an installer or upgrade script. The backend key is the most important otherwise the time is not saved at all.
$installer = $this;
$setup = new Mage_Eav_Model_Entity_Setup('core_setup');
$setup->addAttribute('catalog_product', 'event_date_time', array(
'group' => 'Deal Info',
'input' => 'datetime',
'type' => 'datetime',
'time' => true,
'label' => 'Event date',
'backend' => "eav/entity_attribute_backend_time_created",
'visible' => true,
'required' => false,
'user_defined' => true,
'searchable' => true,
'filterable' => false,
'comparable' => false,
'visible_on_front' => true,
'visible_in_advanced_search' => false,
'is_html_allowed_on_front' => false,
'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
Magento database uses Innodb as storage engine and uses foreign keys to check the integrity between the tables. So, importing the sql dump will cause an integrity violation and we need to disable the integrity check before the import session.
Before importing the dump file, we need to insert this string at the beginning of the sql file itself:
SET FOREIGN_KEY_CHECKS = 0;
then save the file and eventually gzip it.
We can now proceed to the import process
To add a prefix to the magento order, invoice or credit number, it is possible to set it into the eav_entity_store table, column increment_prefix.It is necessary to set it for each store id , while the entity_type_id is 5 for orders, 6 for invoices, 8 for memos.
I was looking at some guides about the Magento’s module creator that is very helpful tool to create a module skeleton. On the developer’s github account, I was able only to download the latest version 0.0.9.2 (4 years old) that creates two modules for the frontend and backend and, the most important thing, it seems to not work on Magento 1.8.
While googling for a solution, I found the previous version on a forum and I’ve downloaded. It works perfectly and I’ve pushed it on my github account, so if anyone need it, here is the link: https://github.com/apedicdev/magento-module-creator
Recently, I’ve got a problem working on a wordpress website that uses jQuery easing to display posts. Clicking on one post, the first time the post was loaded but it lacks of images and comments, the second time the post was loaded but in a new page without the lighbox effect. So, I’ve activated firebug and I’ve seen that there was an endless count of errors on the jquery easing function. As the first time the comments were not displayed, I tried to disable the akismet plugin and it works fine! I don’t know if the issue was due because akismet was not configured or because there is really a conflict with jquery library, but if you have a wordpress template that loads posts in lightbox and they are not displayed, try disable akismet.
I’m glad to have worked on the website about the Paolo Fresu’s documentary, 365. The movie will be available starting from 5th June for EST and VOD on Own Air.