running an sql script

[scotch33]

Sorry guys - probably a basic question but...

 

I'm trying to install 'purchase without account' and have reach a bit where the instructs asl me to run some musql scipts on the master Dbase as below. How the heck do i do this? I am in mysql and can see how to run something in the quey window - is this the same?

 

I have of course baked up etc, but thought I'd ask before i blunder in and have to re-install.

 

ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id;

ALTER TABLE customers ADD INDEX (purchased_without_account);

INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1);

INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON','true','Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;

[Winterchild]

I am in mysql and can see how to run something in the query window - is this the same?

 

 

yes

 

Before you run it, make a backup of your DB

[gmoney1917]

If you need to ask this question then you are not familiar with mysql commands. Therefore you have no way of knowing if what you are about to do is going to do what you hope it will do.

 

I tried to set up the 'purchase without account' contribution and it didn't work. Later I learned that it didn't work because the syntax in the given mysql command was wrong. In fact, almost every time I have installed a contribution involving a mysql command the syntax has been wrong.

 

Anyway, to answer your question, yes the query window is where you run the command. Chance are it won't work. If you are lucky.

[gmoney1917]

yes

 

Before you run it, make a backup of your DB

<{POST_SNAPBACK}>

 

The assumption being that someone who doesn't know how to run a query can backup a database and then reinstall it if necessary?

 

:D

[Winterchild]

Well you can make a backup through the admin and restore it through admin.

 

Anyone can do that

[scotch33]

Thanks guys for the info and the remarkable optimism!

 

As mentioned in the first post - have already backed up, and I am pretty happy with the restore thati would do if this murders my d-base.

 

In reference to not understanding the mysql queies - is there anyone who can read the queries at the top of these posts and tell me if they are good syntax - or am i being too optimistic now!

 

Thanks again guys - appreciate the fast help.

Scotch

[Winterchild]

I ran the query in one of my test databases. Doesn't return an error.

 

I also use PWA and it works so it should be okay

 

 

(I try to always suggest making a backup since I sometimes forget saying it and that can turn ugly when you're trying to help someone :) )

[scotch33]

great winterchild, thank you very much. I'll go play and see what happens...