webdesign halle
nviimedia Slider Webdesign Halle

change a product dropdown attribute to a multiselect in Magento

UPDATE eav_attribute SET
entity_type_id = '4',
attribute_model = NULL,
backend_model = 'eav/entity_attribute_backend_array',
backend_type = 'varchar',
backend_table = NULL,
frontend_model = NULL,
frontend_input = 'multiselect',
frontend_class = NULL
WHERE attribute_id = 'YOUR_ATTRIBUTE_ID_HERE';
DELETE FROM catalog_product_entity_int
WHERE entity_type_id = 4 and attribute_id = YOUR_ATTRIBUTE_ID_HERE;

Magento: get skin url, get media url, get base url, get store url

URL path in STATIC BLOCK

get SKIN URL
{{skin url='images/sampleimage.jpg'}}
get Media URL
{{media url='/sampleimage.jpg'}}
get Store URL
{{store url='mypage.html'}}
get Base URL
{{base url='yourstore/mypage.html'}}

URL path in PHTML

Hinweis: Bei Bearbeitung von PHTML vergessen Sie nicht, den folgenden Code mit PHP-Tag einzuschließen Not secure Skin URL:
<?php echo $this->getSkinUrl('images/sampleimage.jpg') ?>
Secure Skin URL
<?php echo $this->getSkinUrl('images/ sampleimage.gif', array('_secure'=>true)) ?>
Current URL
$current_url = Mage::helper('core/url')->getCurrentUrl();
Home URL
$home_url = Mage::helper('core/url')->getHomeUrl();
Magento Media Url
Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK);
Magento Media Url
Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);
Magento Skin Url
Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_SKIN);
Magento Store Url
Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);
Magento Js Url
Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS);

TYPO3 - PHP get PageId

<?php $pageid = intval($GLOBALS['TSFE']->id); ?>

Item (Mage_Eav_Model_Entity_Attribute_Option) with the same id “x” already exist

Überprüfen Sie die Datensätze, die gelöscht werden sollen (Finden Sie die Duplikationen)
SELECT value_id, option_id
FROM eav_attribute_option_value
WHERE value_id NOT IN
(
SELECT t.value_id 
FROM
(
SELECT MIN( n.value_id ) AS value_id
FROM eav_attribute_option_value n
GROUP BY n.option_id
) 
AS t
)
Wenn Sie sicher, dass die angezeigten Reihen die Überschneidungen sind, führen Sie die folgende Abfrage aus, um sie zu löschen
DELETE
FROM eav_attribute_option_value
WHERE value_id NOT IN
(
SELECT t.value_id 
FROM
(
SELECT MIN( n.value_id ) AS value_id
FROM eav_attribute_option_value n
GROUP BY n.option_id
) 
AS t
)

nvii media webdesign halle leipzig
nvii media gmbH
Kirschbergweg 14 Halle (Saale), Deutschland 06120
Phone: 0345 / 171 38 020