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
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
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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?
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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:
The Product - Music products need:Code: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);
1 record in the products table
1 record in the products_description table
1 record in the product_music_extra table
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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:
NOTE: if you should have a backup of your database before doing things like this ...Code: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);
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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.
Bookmarks