Need help undoing this SQL change

[StoreOwner]

How would i Undo this

# Add the following to your database via Zen Cart Admin.

# NOTE...IF YOU USE A DATABASE PREFIX YOU MUST ADD IT INTO THESE TABLE UPDATES - FOR EXAMPLE:

# If your db prefix is zen_, then change 
# CREATE TABLE `free_gifts` ( 
# to 
# CREATE TABLE `zen_free_gifts` (




CREATE TABLE `free_gifts` (
  `gift_id` tinyint(4) NOT NULL auto_increment,
  `threshold` mediumint(9) NOT NULL default '0',
  `products_id` mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (`gift_id`)
) TYPE=MyISAM;

insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (1200, 'Gifts Image Width', 'GIFTS_IMAGE_WIDTH', '90', 'The pixel width of heading images', '4', '25', now(), now(), NULL, NULL);
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (1201, 'Gifts Image Height', 'GIFTS_IMAGE_HEIGHT', '100', 'The pixel height of heading images', '4', '26', now(), now(), NULL, NULL);
ALTER TABLE `products` ADD `products_carrot` tinyint(1) default '0' AFTER `products_status` ;

[Design75]

It should be the line below:

DROP TABLE `free_gifts`;
DELETE FROM configuration WHERE configuration_key= GIFTS_IMAGE_WIDTH;
DELETE FROM configuration WHERE configuration_key= GIFTS_IMAGE_HEIGHT;
ALTER TABLE products DROP products_carrot;

[StoreOwner]

it's saying no SQL database found, maybe it didn't install yet but I'm still getting an error for some reason
this is what i tried to install: http://www.zen-cart.com/downloads.php?do=file&id=802

I tried running the SQL thing then it showed up an error so i decided to upload the files.

after i uploaded the files I tried it again and now it's saying WARNING: An Error occurred, please refresh the page and try again.

And the admin page wouldnt even load.

I deleted the new files from carrot and put my old ones back on and now my admin page don't work but why not my store page? WARNING: An Error occurred, please refresh the page and try again.

[Design75]

to instal you will need to change

TYPE=MyISAM

to

ENGINE=MyISAM

"Type=" is deprecated, will give an error

[DrByte]

this is what i tried to install: http://www.zen-cart.com/downloads.php?do=file&id=802

Careful reminder: That plugin is designed for a much older version of Zen Cart. It will require many alterations to be used on v1.5.x
Installing it as-is will corrupt many core files, and also dump obsolete code into your site.

[StoreOwner]

Thanks for the replies, Design75 your help with the mysql install fixed my issue now I ran into one other and i think it will work after this.

when i overwrite admin\includes\functions\general.php it doesn't let me load the admin page


also would like to say:
Thanks for the information DrByte and for making zen cart possible.

[Design75]

Thanks for the replies, Design75 your help with the mysql install fixed my issue now I ran into one other and i think it will work after this.

when i overwrite admin\includes\functions\general.php it doesn't let me load the admin page


also would like to say:
Thanks for the information DrByte and for making zen cart possible.

I am no familiar with the mod you are trying to install , but drByte already said it is ancient. So I expect it lies in the fact it needs to be updated to work with new Zen cart versions.
Did you just overwrite the file, or merge it to add the stuff for the new mod? Otherwise you might have ended up with the wrong version of general.php, which would explain why you can not load your admin.

[StoreOwner]

I am no familiar with the mod you are trying to install , but drByte already said it is ancient. So I expect it lies in the fact it needs to be updated to work with new Zen cart versions.
Did you just overwrite the file, or merge it to add the stuff for the new mod? Otherwise you might have ended up with the wrong version of general.php, which would explain why you can not load your admin.

renamed the old with _old.php

[mc12345678]

renamed the old with _old.php

First off, renaming files in ZC should never still end with .php.
Second, for the purpose of the site loading the code, this type of renaming is the same as replacing the file. The code content of the changes made to this version of the file applicable to make this plugin function need to be carried over to the version for your store or incorporated otherwise. It's been a while since I've looked for a possible new compare utility, but winmerge and beyond compare are two applications that come to mind to help with this type of merge which should be verified with any installation.

[StoreOwner]

im having an issue now, i installed it like you said but now when users go to 2nd checkout page and try to confirm it, it brings them back to the first 1...

i tried:
DROP TABLE `free_gifts`;
DELETE FROM configuration WHERE configuration_key= GIFTS_IMAGE_WIDTH;
DELETE FROM configuration WHERE configuration_key= GIFTS_IMAGE_HEIGHT;
ALTER TABLE products DROP products_carrot;

"Uknown Table"