CMS MADE SIMPLE FORGE

Cataloger

 

[#5425] Manage User-Defined Attributes doen't work anymore

avatar
Created By: Andi Petzoldt (andiministrator)
Date Submitted: Wed Sep 15 03:18:17 -0400 2010

Assigned To:
Version: 0.8.0
CMSMS Version: None
Severity: Critical
Resolution: None
State: Open
Summary:
Manage User-Defined Attributes doen't work anymore
Detailed Description:
After an upgrade from Cataloger 0.7.7 to 0.8.0, all my User-Defined Attributes
seems to be deleted. I tried to add them, but I get the following error: Unknown
column 'alias' in 'field list'


History

Comments
avatar
Date: 2010-09-15 04:23
Posted By: Andi Petzoldt (andiministrator)

The problem seems to be the upgrade, the new fields for catalog_attr table are
not in after the upgrade.
After I added the fields manually, the module works fine.

Here my SQL-Statement for adding the fields manually:
ALTER TABLE `cms_module_catalog_attr` ADD `order_by` INT( 4 ) NOT NULL AFTER
`attribute` ,ADD `alias` VARCHAR( 60 ) NOT NULL AFTER `order_by` ,ADD `length`
INT( 11 ) NOT NULL AFTER `alias` ,ADD `defaultval` TEXT NOT NULL AFTER `length`
;
      
Updates

Updated: 2010-09-15 04:23
resolution_id: => 5