3 replies [Last post]
Boletus's picture
Offline
Joined: 09/09/2007
Juice: 117
Was this information Helpful?

Hi!
I just enabled the Attributes module. I am quite sure I hadn't enabled it before. I got a load of warning:

* user warning: Table 'uc_attributes' already exists query: CREATE TABLE uc_attributes ( `aid` mediumint(9) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `ordering` tinyint(2) NOT NULL default 0, PRIMARY KEY (`aid`) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ; in /home/web28743/domains/domain.com/public_html/dev/includes/database.mysql.inc on line 172.
* user warning: Table 'uc_attribute_options' already exists query: CREATE TABLE uc_attribute_options ( `aid` mediumint(9) NOT NULL, `oid` mediumint(9) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `cost` decimal(10,2) NOT NULL, `price` decimal(10,2) NOT NULL, `weight` float NOT NULL, `ordering` tinyint(2) NOT NULL default 0, PRIMARY KEY (`oid`) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ; in /home/web28743/domains/domain.com/public_html/dev/includes/database.mysql.inc on line 172.
* user warning: Table 'uc_class_attributes' already exists query: CREATE TABLE uc_class_attributes ( `pcid` varchar(32) NOT NULL, `aid` mediumint(9) NOT NULL, `ordering` tinyint(2) NOT NULL default 0, `default_option` mediumint(9) NOT NULL default '0', PRIMARY KEY (`pcid`, `aid`) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ; in /home/web28743/domains/domain.com/public_html/dev/includes/database.mysql.inc on line 172.
* user warning: Table 'uc_class_attribute_options' already exists query: CREATE TABLE uc_class_attribute_options ( `pcid` varchar(32) NOT NULL, `oid` mediumint(9) NOT NULL, `cost` decimal(10,2) NOT NULL, `price` decimal(10,2) NOT NULL, `weight` float NOT NULL, `ordering` tinyint(2) NOT NULL default 0, PRIMARY KEY (`pcid`,`oid`) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ; in /home/web28743/domains/domain.com/public_html/dev/includes/database.mysql.inc on line 172.
* user warning: Table 'uc_product_attributes' already exists query: CREATE TABLE uc_product_attributes ( `nid` mediumint(9) NOT NULL, `aid` mediumint(9) NOT NULL, `ordering` tinyint(2) NOT NULL default 0, `default_option` mediumint(9) NOT NULL default '0', PRIMARY KEY (`nid`, `aid`) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ; in /home/web28743/domains/domain.com/public_html/dev/includes/database.mysql.inc on line 172.
* user warning: Table 'uc_product_options' already exists query: CREATE TABLE uc_product_options ( `nid` mediumint(9) NOT NULL, `oid` mediumint(9) NOT NULL, `cost` decimal(10,2) NOT NULL, `price` decimal(10,2) NOT NULL, `weight` float NOT NULL, `ordering` tinyint(2) NOT NULL default 0, PRIMARY KEY (`nid`,`oid`) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ; in /home/web28743/domains/domain.com/public_html/dev/includes/database.mysql.inc on line 172.
* user warning: Table 'uc_product_adjustments' already exists query: CREATE TABLE uc_product_adjustments ( `nid` mediumint(9) NOT NULL, `combination` varchar(255) NOT NULL, `model` varchar(255) NOT NULL, PRIMARY KEY (`nid`, `combination`) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ; in /home/web28743/domains/domain.com/public_html/dev/includes/database.mysql.inc on line 172.

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Enabled Product Attributes module

That's really odd that it would try to install itself twice. But if attributes still work, there isn't anything to be done. Just hope that the tables it tried to create are the same as the ones that are already there.

Boletus's picture
Offline
Joined: 09/09/2007
Juice: 117
Re: Re: Enabled Product Attributes module

Let's say I did enable it; shouldn't the module check to see if the tables already existed?

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Re: Re: Enabled Product Attributes module

Drupal is supposed to do that for us. I don't know why it didn't happen this time, but it shouldn't happen again.