SPPC again

[JoeyRocket]

I tried to install SPPC on a clean copy of OSC. When I ran sppc_v41_install.sql I got this error:

 

Error

SQL query:

ALTER TABLE customers ADD customers_group_id smallint UNSIGNED NOT NULL default '0',

X ADD customers_group_ra enum( '0', '1' ) NOT NULL ,

ADD customers_payment_allowed varchar( 255 ) NOT NULL default '',

ADD customers_shipment_allowed varchar( 255 ) NOT NULL default '';

 

MySQL said: http://dev.mysql.com/doc/refman/4.1/en/err...htmlFPRIVATE "TYPE=PICT;ALT=Documentation" http://dev.mysql.com/doc/refman/4.1/en/error-returns.html

 

#1060 - Duplicate column name 'customers_group_id'

 

Is this bad? Is it workable? Should I change something? Any help is appreciated.

[JoeyRocket]

Is this insignificant?

[Jan Zonjee]

Is this insignificant?

In a way... yes. Given your assurance this was a clean osC it most likely means you (accidently probably) tried to run the sql file twice. The changes in the table customers are the first ones in that sql file so you should be fine.

 

It is advisable to use the SPPC thread on questions regarding it. That goes for every contribution (assuming they have a thread).