Results 1 to 10 of 27

Hybrid View

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

    Default Re: Deleting an Option with a "TEXT" or "FILE" value for ALL products

    Are you able to Export the table products_attributes from your database and Zip it then attach it to your post?
    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!]
    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. #2
    Join Date
    Dec 2008
    Location
    Toronto
    Posts
    347
    Plugin Contributions
    0

    Default Re: Deleting an Option with a "TEXT" or "FILE" value for ALL products

    Quote Originally Posted by Ajeh View Post
    Are you able to Export the table products_attributes from your database and Zip it then attach it to your post?
    I believe this is the correct table...KCB.sql.zip

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

    Default Re: Deleting an Option with a "TEXT" or "FILE" value for ALL products

    While it is the right table, I believe you only exported some of it ...

    See if you can try again by going to phpMyAdmin so that you see all the table names for your database in the right hand panel of the screen, then click on EXPORT and you should see the selection for:
    Export Method:

    Quick - display only the minimal options
    Custom - display all possible options
    Pick Custom and you will see all the tables listed ... just pick the one for products_attributes ...
    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!]
    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. #4
    Join Date
    Dec 2008
    Location
    Toronto
    Posts
    347
    Plugin Contributions
    0

    Default Re: Deleting an Option with a "TEXT" or "FILE" value for ALL products

    Quote Originally Posted by Ajeh View Post
    While it is the right table, I believe you only exported some of it ...

    See if you can try again by going to phpMyAdmin so that you see all the table names for your database in the right hand panel of the screen, then click on EXPORT and you should see the selection for:


    Pick Custom and you will see all the tables listed ... just pick the one for products_attributes ...
    I think I've got it this time...KCBTake2.sql.zip

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

    Default Re: Deleting an Option with a "TEXT" or "FILE" value for ALL products

    Could you post, from the server, the two files:
    /includes/configure.php
    /your_secret_admin/includes/configure.php

    WITHOUT your database password and WITHOUT your secret admin directory name ...
    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!]
    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. #6
    Join Date
    Dec 2008
    Location
    Toronto
    Posts
    347
    Plugin Contributions
    0

    Default Re: Deleting an Option with a "TEXT" or "FILE" value for ALL products

    Quote Originally Posted by Ajeh View Post
    Could you post, from the server, the two files:
    /includes/configure.php
    /your_secret_admin/includes/configure.php

    WITHOUT your database password and WITHOUT your secret admin directory name ...
    Here you go...
    Thanks for your help on this!
    Attached Files Attached Files
    Last edited by kcb410; 3 Feb 2015 at 06:21 PM.

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

    Default Re: Deleting an Option with a "TEXT" or "FILE" value for ALL products

    So far, this is making no sense ...

    Go to phpMyAdmin and do a search on the products_attributes for the products_id 1032 ... could you do a screen shot of what comes up? I only need to see the first 4-5 fields, the rest of the fields are not important ...
    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!]
    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!

 

 

Similar Threads

  1. v150 Is this a bug in v1.50? orders_total doesn't output "text" but "value"
    By inception in forum General Questions
    Replies: 10
    Last Post: 10 Sep 2012, 05:38 AM
  2. HELP - ALL Attributes are showing up as "Text" for option value!
    By NWFAP in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 2 Jan 2012, 01:14 AM
  3. How to remove ellipses ("...") after "All Products" and "New Products" on home page?
    By jthurman in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 18 May 2010, 03:30 PM
  4. Ability to get a list of "option value" by "customer"?
    By Banhi in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 26 Jan 2008, 07:57 PM
  5. Inside the "Categories" box it says "New Products" and "All Products"...
    By john9 in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 25 Feb 2007, 07:55 AM

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