How Can I Uninstall This SQL Patch?

[limelites]

This one has screwed up my Admin area and I didn't backup my database... I know, I know but 99.999999% of SQL patches run perfectly and i've never had to reinstate a database to this day...... Well until now

Here's the SQL I uploaded.... Does anyone know how to uninstall this???

# Admin Notes

# --------------------------------------------------------

#
# Table structure for table '`notes_categories`'
#

DROP TABLE IF EXISTS `notes_categories`;
CREATE TABLE `notes_categories` (
  `notes_categories_id` int(11) NOT NULL auto_increment,
  `notes_categories_name` varchar(64) default NULL,
  PRIMARY KEY  (`notes_categories_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table '`notes`'
#

DROP TABLE IF EXISTS `notes`;
CREATE TABLE `notes` (
  `notes_id` int(11) NOT NULL auto_increment,
  `notes_title` varchar(64) NOT NULL,
  `notes_text` text,
  `notes_date_created` datetime NOT NULL default '0001-01-01 00:00:00',
  `notes_date_modified` datetime NOT NULL default '0001-01-01 00:00:00', 
  `notes_start_date` date NOT NULL default '0001-01-01',
  `notes_end_date` date NOT NULL default '0001-01-01',  
  `notes_snooze_date` datetime NOT NULL default '0001-01-01 00:00:00', 
  `notes_categories_id` int(11) NOT NULL default '1',
  `notes_priority` int(11) NOT NULL default '1',
  `notes_status` int(1) NOT NULL default '1',
  `notes_text_message_stack_status` int(1) NOT NULL default '1',  
  `notes_catalog_status` int(1) NOT NULL default '0',    
  `notes_is_special_status` int(1) NOT NULL default '0',      
  `customers_id` int(11) default NULL,
  `orders_id` int(11) default NULL,  
  `products_id` int(11) default NULL, 
  `categories_id` varchar(64) default NULL,    
  PRIMARY KEY  (`notes_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Sample data 
#

INSERT INTO `notes_categories` VALUES (NULL, 'New notes');
INSERT INTO `notes_categories` VALUES (NULL, 'Sample notes');
INSERT INTO `notes_categories` VALUES (NULL, 'Personal');
INSERT INTO `notes_categories` VALUES (NULL, 'Add ons');

INSERT INTO `notes` VALUES (NULL, 'Welcome to Admin Notes!', 'Tired of having Post-it Notes all over the place, and never being able to find that one important note between all other notes?<br />
With Zen Cart notes you will save lots of time (and the money you spend on Post-it notes... :-)<br /><br />
Goto to your Zen Cart admin :: Extras :: Admin Notes to view, edit and create new notes.<br /><br />
If you like this contribution and would like to support the development please make a donation to [email protected]', NOW(),  NOW(), NOW(), '0001-01-01', '0001-01-01 00:00:00', 2, 2, 1, 1, 0, 0, NULL, NULL, NULL, NULL);


INSERT INTO `notes` VALUES (NULL, 'Special notes sample (attached to customer 1).', 'This is a customers note about customer 1 (customers_id = 1) ', NOW(),  NOW(), NOW(), '0001-01-01', '0001-01-01 00:00:00', 2, 2, 1, 1, 0, 1, 1, NULL, NULL, NULL);


INSERT INTO `notes` VALUES (NULL, 'Special notes sample (unattached).', 'You can attach this special note to a customer, order, category or product. When attached it will only be shown while you are viewing the details of the customer, order, category or product.<br />
<br />
There are two ways to attach a special note:<br />
<br />
1- You can attach a special note directly by editting the details, but then you will need to know the id of the object you want it to be attached to (the notifier is triggered by the cID, pID, cPath, oID value).<br />
<br />
2- If none of the ID values is > 0 (note details), then the note will be active on all special events and the notes notifier will ask you if you want to attach this note to the product, customer, order or category which you are viewing in you Zen Cart admin. Now the ID will be entered into the note editor automaticly if you click on the note link.', NOW(),  NOW(), NOW(), '0001-01-01 00:00:00', '0001-01-01 00:00:00', 2, 2, 1, 1, 0, 1, NULL, NULL, NULL, NULL);

# --------------------------------------------------------

#
# Remove data 
#

#TRUNCATE TABLE `notes`;
#TRUNCATE TABLE `notes_categories`;

# --------------------------------------------------------

#
# Delete tables 
#

#DROP TABLE IF EXISTS `notes`;
#DROP TABLE IF EXISTS `notes_categories`; 

[Steven300]

It looks like the uninstall commands are commented out at the bottom there.

DROP TABLE IF EXISTS `notes`;
DROP TABLE IF EXISTS `notes_categories`;

Though I can't see how these two tables could mess up the admin panel. It's more likely to be the mod's files.

[limelites]

Mod Files were all unique and I removed them and ran the uninstall SQL above.... Still getting the exact same errors... What on earth could be causing them ?

[Steven300]

What errors are you getting?

[DrByte]

What errors are you getting?

Probably this one: http://www.zen-cart.com/forum/showthread.php?t=128369
... which is entirely unrelated to the SQL Patch code posted above.

[sohailarif]

could you please help me with uninstalling sql


CREATE TABLE customers_additional (
field_id int(11) NOT NULL auto_increment,
field_name varchar(255) NOT NULL default '',
field_status char(2) NOT NULL default '',
PRIMARY KEY (field_id)
) ENGINE=MyISAM;


after this patch i have started getting error below

1054 Unknown column 'field_required' in 'field list'
in:
[ SELECT field_id, field_name, field_required, field_status, use_url, field_url FROM customers_additional WHERE field_status = 1 ]

[RodG]

could you please help me with uninstalling sql


CREATE TABLE customers_additional (
field_id int(11) NOT NULL auto_increment,
field_name varchar(255) NOT NULL default '',
field_status char(2) NOT NULL default '',
PRIMARY KEY (field_id)
) ENGINE=MyISAM;


after this patch i have started getting error below

1054 Unknown column 'field_required' in 'field list'
in:
[ SELECT field_id, field_name, field_required, field_status, use_url, field_url FROM customers_additional WHERE field_status = 1 ]

The error message and the patch are suggesting that the database is out of sync with the files. The 'patch' alone will not (cannot) produce this error message, and if someone DOES tell you how to reverse the patch you will actually end up with *more* errors.

You have 2 solutions.

1. Complete the rest of the SQL upgrade patches (one of them will add the missing field(s). or
2. Delete (revert back to the original) of any FILES that were installed as a part of the module that you installed that has given you this error.

Cheers
Rod

ps. Please avoid posting the same question in multiple places. It annoys people. :)