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

[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