Protuct Type music/general

[Ajeh]

did you run that in the Install SQL Patches? Or in phpMyAdmin?

[Ajeh]

oh, in phpMyAdmin the table reads zen_product_music_extra I didn't know if that would change to code.
(all the products are listed under zen_products)

Also, I want to change all the current products to music, but in the future I would like to add products under general, will I still be able?

In the future ... if you select from the dropdown Product - General you get a Product General ... if you select Product - Music you will make a Product - Music ...

[readysketty]

did you run that in the Install SQL Patches? Or in phpMyAdmin?

Install SQL Patches

[Ajeh]

Could you go to your phpMyAdmin and run this in the SQL for your database:

insert into zen_product_music_extra (products_id) select products_id from zen_products where products_type = 2 and products_id not in (select products_id from zen_product_music_extra);

[readysketty]

OK, I've never done anything like this before, (as if you couldn't already tell that )
I went into my phpMyAdmin, then clicked on database, then at the top there were tab to pick from, one being SQL, I clicked that tab and it says :
"Run SQL query/queries on server "unt1134201015452.db.8699877.hostedresource.com":"
Then under that is a big box for text, similar to the box on "install SQL patch"

Does this sound like I am in the right spot?

[Ajeh]

That sounds correct ...

To the left, you should see a list of all of your database tables ...

[readysketty]

Oh my gosh!!!!! It worked!!!!!


thank you thank you thank you!!!!!!!!!

[readysketty]

I REALLY appreciate all the time you put into helping me! Thank you so much!

[Ajeh]

You are most welcome ... glad that this was able to work for you ...

[readysketty]

Thank you again!