SQL uninstall/reinstall

[DrByte]

Each statement starts with a keyword, usually like INSERT or UPDATE or SELECT, and ends with a semi-colon.

Generally speaking you can usually use copy-and-paste to run them one by one.

[petergy]

This is the error message:

18 statements processed.
ERROR: Cannot ADD column entry_telephone because it already exists.
ERROR: Cannot ADD column shipping_telephone because it already exists.
ERROR: Cannot ADD column dropdown because it already exists.
ERROR: Cannot ADD column gift_message because it already exists.
ERROR: Cannot ADD column checkbox because it already exists.
ERROR: Cannot ADD column COWOA_account because it already exists.
ERROR: Cannot ADD column COWOA_order because it already exists.
ERROR: Cannot ADD column COWOA_order because it already exists.
ERROR: Cannot ADD column COWOA_order because it already exists.
ERROR: Cannot ADD column COWOA_order because it already exists.
ERROR: Cannot ADD column COWOA_order because it already exists.
ERROR: Cannot ADD column COWOA_order because it already exists.
ERROR: Cannot ADD column COWOA_order because it already exists.
ERROR: Cannot ADD column COWOA_order because it already exists.
Note: 7 statements ignored. See "upgrade_exceptions" table for additional details.

And the only place I see the (for example) entry_telephone is at the very beginning of the sql, which looks like this:

ALTER TABLE address_book ADD entry_telephone varchar(50) NULL default NULL;
ALTER TABLE orders ADD shipping_telephone varchar(50) NULL default NULL;
ALTER TABLE orders ADD dropdown varchar(50) NULL default NULL;
ALTER TABLE orders ADD gift_message varchar(100) NULL default NULL after dropdown;
ALTER TABLE orders ADD checkbox integer(1) NULL default NULL after gift_message;
ALTER TABLE customers ADD COWOA_account tinyint(1) NOT NULL default 0;
ALTER TABLE orders ADD COWOA_order tinyint(1) NOT NULL default 0;

And if I start adding them one by one, I get the same message:

Failed: 1
ERROR: Cannot ADD column entry_telephone because it already exists.
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

What is my next step?

[DrByte]

Those all tell me that those statements have already been run, and thus those statements don't need to be run again.

[petergy]

Nevermind Dr. Byte, I am most definitely a RETARD. I screwed up the settings in the configuration of the mod. I apologize that I took your time.
Peter

[DrByte]

Ha! I did something similar this morning! No harm done. Glad you got it sorted out.