Home » Forums » Ubercart » Bug Reports

Enabled Product Attributes module

Submitted by Boletus on Mon, 11/19/2007 - 06:34
Boletus

Posts: 50
 Joined: 09/09/2007

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.
permalink #1 Mon, 11/19/2007 - 10:30
Lyle

Posts: 2102
 Joined: 08/07/2007
AdministratoreLiTe!

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.

permalink #2 Mon, 11/19/2007 - 11:22
Boletus

Posts: 50
 Joined: 09/09/2007

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

permalink #3 Mon, 11/19/2007 - 12:00
Lyle

Posts: 2102
 Joined: 08/07/2007
AdministratoreLiTe!

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.