Adding discount coupons when processing order in admin section

[balambi]

got rid of that error by replacing TYPE='MyISAM' with ENGINE=MyISAM
in the sqlpatch.php file

[swguy]

Thank you for describing this error, and its resolution, which other people are sure to come across.

(adding a restatement to help searchers.)
Newer versions of MySQL require the syntax

ENGINE=MyISAM

instead of

TYPE=MyISAM

just change the SQL and run it again.

[balambi]

after running the pass.sql
I now get this error
ERROR: Cannot insert configuration_key "MASTER_PASS" because it already exists

not 100% sure what to make of it.. since I didn't set that password..
should the script be written to update rather than insert?

current script..

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description,

configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Master

Password', 'MASTER_PASS', 'v2cigs99@', 'This password will allow you to login to any customer\'s account.', 1, 23,

now(), now(), NULL, NULL);

[swguy]

That part of the original script succeeded; just the create table failed and you fixed that by making the change you posted.
You're good to go now - set the password in admin->configuration->my store.

[balambi]

GREAT IT WORKS >>>>>THANKS A MIL FOR YOU HELP.. . saved me from having to write code for this :)

[swguy]

Glad to help. You can show your appreciation by supporting the Zen Cart project using the Donate link at the top right hand side of this page.

[balambi]

quick follow up.... how do I modify the code such that every time that someone wants to sign in as a customer the master password will be required. ?
currently >> once placeorder is clicked then one is automatically signed in as the customer. I want it to be restricted such that only individual/s with that master password can sign as a customer. ..
so once place order is clicked the email address shows up and the password field is blank and then the master password will be input.