How do I run the stock_attribute.sql via Install SQL Patches in admin

[vivaraquel]

I've looked all over the forums, even googled it but I'd be damned if i know how to use the Admin>Tools>Install SQL Patches.

I've installed the Stock by attributes mod and have done everything except run the stock_attribute.sql via Admin>Tools>Install SQL Patches. I have no idea what to type in there and I've looked everywhere.

I kinda know what it's talking about where it says to do it another way. Creating the table in the database manually by going to phpMyAdmin but as I don't know what I am doing there wigther I don't feel confortable messing arouund with it.

I think the admin way would be easier if I just knew what to say. Can someone please just let me know. It's all I need to so to get past this step. I'm thinking there will be other hiccups after that.

Thank you so much in advance to anyone that can take the time.

[kobra]

You would open the sql patch file in a "PLAIN TEXT" editor like notepad then in the admin > tools > install sql patches > copy the notepad contents and paste it into the admin "Enter the query to be executed:" box and send

[vivaraquel]

You're bloody kidding me!!! That's all I had to do?!! LOL

Well, while I waited I tried looking into it some more and did it myself via phpMyAdmin. I'll see if I remember what I did and let everyone else know as I did it on the fly, a bit of a guessing game.

Access you db via phpmyadmin. elect your db and a scroll down to the bottom of the list. enter the new table name u want to create, in this case zen_products_with_attributes_stock. If you don't have the zen_ prefix, drop it

Then I entered the details found in the sql file to include the extra fields, there are 4. just choose the options for each field mentioned in the file and leave the rest blank.

Make stock_id the primary key and hit the save button.
Pretty damn easy when you know what to do and not bad for a newb to guess it.
Hope this helps anyone and thanks for the reply.

[vivaraquel]

Ok, if anyone else is having probs with this, do not do what I said, do what kobra said cuz I just realised I am missing some more stuff in stting up this table. So I'm gonna scrap it and do it kobra's way.

I may learn some day. Sry for any inconvinience.

[kobra]

OP asked this initially:

if i know how to use the Admin>Tools>Install SQL Patches.

and why I answered with this as the answer - but phpmyadmin is also a good tool that can be used