Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 40
  1. #21
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: 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
    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!

  2. #22
    Join Date
    Jan 2012
    Posts
    32
    Plugin Contributions
    0

    Default Re: Protuct Type music/general

    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?

  3. #23
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Protuct Type music/general

    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!

  4. #24
    Join Date
    Jan 2012
    Posts
    32
    Plugin Contributions
    0

    Default Re: Protuct Type music/general

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

  5. #25
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Protuct Type music/general

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

  6. #26
    Join Date
    Jan 2012
    Posts
    32
    Plugin Contributions
    0

    Default Re: Protuct Type music/general

    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.

  7. #27
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Protuct Type music/general

    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:
    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);
    NOTE: if you should have a backup of your database before doing things like this ...
    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!

  8. #28
    Join Date
    Jan 2012
    Posts
    32
    Plugin Contributions
    0

    Default Re: Protuct Type music/general

    OK, I will give it a try :)

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

  9. #29
    Join Date
    Jan 2012
    Posts
    32
    Plugin Contributions
    0

    Default Re: Protuct Type music/general

    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?

  10. #30
    Join Date
    Jan 2012
    Posts
    32
    Plugin Contributions
    0

    Default Re: Protuct Type music/general

    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.

 

 
Page 3 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. Change Category from General to Music
    By thesoundsmith in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 18 Nov 2009, 11:57 AM
  2. Product Type cloned from General Type
    By mhfein in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 8 Jan 2009, 04:37 PM
  3. Music Genre added to product general
    By idlerob in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 13 Oct 2006, 05:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR