Protuct Type music/general

It should have ...

Check and see if you have any products in the table:
products_description

Also check that you are not running an old php as referenced in post #6 of this thread:
http://www.zen-cart.com/forum/showthread.php?t=153143

OK, so this is what I have figured out:
When I click on an item to edit it here is the URL it takes me too:

........................./adminurrhtcqq/product_music.php?page=1&product_type=2&cPath=1&pID=58&action=new_product

this form is blank, but when I switch the "product_type=2" in the URL to "produt_type=1":

......................./adminurrhtcqq/product_music.php?page=1&product_type=1&cPath=1&pID=58&action=new_product

Then the form is filled in again, but it is just a general product. So all of my info is still there, the code that I entered changed them all to product_2 but it won't transfer the info to the music (product_2) form.

Have you ever heard of that? Any ideas?

It sounds like you do not have the records for the Products in the table:
product_music_extra

Go to your phpMyAdmin and browse the table:
product_music_extra

how many Products are in there?

I'm sorry, I am looking through an FTP file manager on Go Daddy right now. I am having trouble finding any products listed :/ I will keep looking.........

This is NOT with FTP ...

Go to your Control Panel for your domain and you should find phpMyAdmin ... this will let you look at your database tables ...

The issue that you are having sounds like when you did the original changes, that they did not happen to change all of your Products to Product - Music and add the new records to the table product_music_extra so that they can work correct ...

This is from way back when I told you that to change ALL Products to Product - Music that you needed to Backup your database and then run the SQL commands:

UPDATE products SET products_type = 2;

insert into product_music_extra (products_id) select products_id from products where products_type = 2 and products_id not in (select products_id from product_music_extra);

The Product - Music products need:

1 record in the products table
1 record in the products_description table
1 record in the product_music_extra table

OK, I called go daddy & they were able to direct me to phpMyAdmin.
I was able to get to the tables, you are correct, I only have 3 products under "products_music_extra" and they are the products I put directly in the music type.

OK, I just want to make sure that I originally entered the code in the right place, I went Tools_Install SQL Patches
Then I entered the code in the box. I had followed that from another post, where someone was changing their product types, but with a different scenario.

Let's follow one fix for this ...

Do you want ALL of your Products to be Product - Music? If so, in the Tools ... Instal SQL Patches ... run the commands:

UPDATE products SET products_type = 2;

insert into product_music_extra (products_id) select products_id from products where products_type = 2 and products_id not in (select products_id from product_music_extra);

NOTE: if you should have a backup of your database before doing things like this ...

OK, I will give it a try :)

This looks like the same code I put in before, is the correct?

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?

I entered the code and this is what it said:

1146 Table 'unt1134201015452.products' doesn't exist
in:
[INSERT INTO zen_product_music_extra (products_id) select products_id from products where products_type = 2 and products_id not in (select products_id from product_music_extra);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

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

readysketty:

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 ...

Ajeh:

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

Install SQL Patches

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);

OK, I've never done anything like this before, (as if you couldn't already tell that :P)
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?

That sounds correct ...

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

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

:D
thank you thank you thank you!!!!!!!!!
:clap: :clap: :clap: :clap: :clap: :clap:

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

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

:D Thank you again!