You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Error in [...]/app/code/community/SwiftOtter/Attribute/sql/SwiftOtter_Attribute/mysql4-install-1.0.0.php" - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'explanatory_note'";i:1;s:1276:"#0
I have modified the file with this code:
$installer->run("
SET _count = ( SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = {$installer->getTable('catalog/eav_attribute')} AND
COLUMN_NAME = explanatory_note);
IF _count = 0 THEN
ALTER TABLE {$installer->getTable('catalog/eav_attribute')} ADD COLUMN explanatory_note VARCHAR(255);
END IF;
");
I wish I can help you and someone with the same issue.
Oh, really: I've installed Magento 1.9.2.1 CE.
The text was updated successfully, but these errors were encountered:
I get this error:
Error in [...]/app/code/community/SwiftOtter/Attribute/sql/SwiftOtter_Attribute/mysql4-install-1.0.0.php" - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'explanatory_note'";i:1;s:1276:"#0
I have modified the file with this code:
$installer->run("
SET _count = ( SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME =
{$installer->getTable('catalog/eav_attribute')}
ANDCOLUMN_NAME =
explanatory_note
);IF _count = 0 THEN
ALTER TABLE
{$installer->getTable('catalog/eav_attribute')}
ADD COLUMNexplanatory_note
VARCHAR(255);END IF;
");
I wish I can help you and someone with the same issue.
Oh, really: I've installed Magento 1.9.2.1 CE.
The text was updated successfully, but these errors were encountered: