SQL uninstall/reinstall

[petergy]

When I reinstall a sql patch, I got some errors saying that was not able to install because that column is already exist.

Is that because when I uninstalled it did not remove 100% and I need to manually delete it? If yes, where do I delete it?

Is it because I need to remove the entire mod before I reinstall the SQL?

Please let me know what do I need to do. (It is the FEC I needed to reinstall. I looked on that forum but had not found anything related to the sql issue I am having)

Thank you

[DrByte]

If the column already exists, it can't be added.
But if you WANT it to exist (and it sounds like you DO since you're trying to install the mod), then you can safely ignore the error/warning.

If whatever method you're using to run those SQL statements actually carries on and attempts all the next SQL statements, then you should be fine. But if that one error causes it to abort, then you may need to manually run all the subsequent statements one by one to get them to take effect.

[petergy]

I copied and pasted the sql content into the patch uploader through tools in admin. The mod does not work properly because of the issue.
How do I manually run all subsequent statements?

Thank you

[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.