Duplicate database in the install [#1433718]

I just realized that after installing it over and over again due to error messages I can't seem to get rid of , I found that there are two databases: one title "commerce products and the other commerce products revisions".

I think this might be causing this error message I get after install:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '128' for key 'sku'
because there are two databases with the same sku's. not sure why ..

which is preventing me from seeing the theme or doing anything.
If i delete the commerce products db, the whole thing goes down.

Did everyone have the same issues here? i changed my max execution time to 0 to get rid of one of the other errors but can't seem to get by this one to start my theming .

Comments

Comment #1

mxa055 CreditAttribution: mxa055 commented 9 February 2012 at 09:21

There is no duplicate database in the install. The "commerce products" and "commerce_product_revisions" are two Tables, both necessary for Commerce module to function.
Best thing you could do is drop all the tables in the Database and start over.

Comment #2

frozen10 CreditAttribution: frozen10 commented 9 February 2012 at 14:58

Thanks for the reply..
I see...so why would it say that it has duplicate sku's?

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '128' for key 'sku'

Also, i have been deleted and restarting it over the past 3 days now and I still for some reason can't seem to get it installed. I think if I can get passed this error, it should work, but no matter how many times i clear out the db and reinstall it, i get this message at the end.

the first message has to do with the php ini file which i changed the execution time to 0 which got me passed that one...but this one i'm stumped.

starting over doesn't help. i must have done it a million times already.