Full service web hosting, great prices and support. Starts at $1.99/month!
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Can't create categories / products

  1. #1
    fidsalazar
    Guest


    Question Can't create categories / products

    Hello everybody from Peru. This is my first question.

    I went on sucsessfully through all the installation process and everything is ok unless the categories/products in admin.

    I got to create the first category but after that the page came to be blank neither showing the just created category or any other button.

    Yes, I changed the languages, deleting German ( as I won't never use it) and making spanish by default.

    The categories/products in admin appear in spanish (Categorias / Productos) and I think all the admin pages appeared in Spanish since the very beginning without asking me the default language (think it's automatic detection)

    I read on an OSC forum about the languages and modified directly the db to order modify the ids of the languages only to get the categories/product page again for one more time. When trying to add the second category it gave me an error of duplicate 0 value in the parents_id

    What can I do?

    OSC Max seem a good software for me as it has great features as easypopulate, etc.

    Regards,

  2. #2
    ogilirca
    Guest


    Default Re: Can't create categories / products

    it happened to me either. you may try downloading the previous version, put its sql in the new version's install directory and proceed. worked for me.

  3. #3
    wwwspeedsourceca
    Guest


    Default Re: Can't create categories / products

    I have the same problem with RC3, I can not create categories. These are being made in the DB, however, when you go to display them in the admin panel there is only a blank screen, this really sucks, can't believe there is no fix for this!

    Replicate:

    Go to admin panel -> Catalog -> Categories/Products
    Add Category
    Type in Name, Description, etc.
    Insert Category
    Go back to admin panel -> Catalog -> Categories/Products
    You will now see no categories, nor option to add a product or category, just a blank page.

  4. #4
    wwwspeedsourceca
    Guest


    Default Re: Can't create categories / products

    I've fixed this, go into your mysql database and make sure that the id field in the categories database is auto_increment, if not, it won't work!

  5. #5
    osCMax Developer


    Can't create categories / products

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,013
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default Re: Can't create categories / products

    It should be auto increment by default, as that field is set as the primary key. When I just ran the installer, it is creating the table with the auto_increment field. Not sure what the issue may be. What version of mysql are you running (all of you?)
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  6. #6
    wwwspeedsourceca
    Guest


    Default Re: Can't create categories / products

    It definately was not auto_increment for me...

  7. #7
    osCMax Developer


    Can't create categories / products

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,013
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default Re: Can't create categories / products

    For the second time, what versions of mysql are you running? If you don't provide any good debugging info, I can't help and cannot fix any issues that may be there.

    I just ran several test installs on mysql 5.0.27 and mysql 4.1 and it installs with auto-increment set.
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  8. #8
    shoppingmantra
    Guest


    Default Re: Can't create categories / products

    I'm getting this error when I click on Categories and Products:-
    Categories / ProductsSearch: Go To: TopCategories / ProductsStatusAction 1054 - Unknown column 'p.vendors_product_price' in 'field list'

    select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.vendors_product_price, p.vendors_prod_comments, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2Categories / ProductsSearch: Go To: TopCategories / ProductsStatusAction 1054 - Unknown column 'p.vendors_product_price' in 'field list'

    select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.vendors_product_price, p.vendors_prod_comments, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

    [TEP STOP]

    c.categories_id = '0' order by pd.products_name

    [TEP STOP]


  9. #9
    osCMax Developer


    Can't create categories / products

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,013
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default Re: Can't create categories / products

    @ shoppingmantra:
    Your error is due to a mod you have added to oscmax incorrectly. You have added p.vendors_product_price to your code but not to the database...
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  10. #10
    shoppingmantra
    Guest


    Default Re: Can't create categories / products

    Hi,
    I didn't add anything. Its just a fresh installetion and nothing is changed. Please do something

Page 1 of 2 12 LastLast

Similar Threads

  1. No Products in Categories box
    By kenlyle in forum osCMax v2 Features Discussion
    Replies: 11
    Last Post: 11-08-2005, 08:21 PM
  2. No Products in Categories box
    By kenlyle in forum osCmax v1.7 Discussion
    Replies: 2
    Last Post: 11-06-2005, 07:31 AM
  3. Directory of categories-products
    By damnedpig in forum osCmax v1.7 Discussion
    Replies: 7
    Last Post: 06-28-2005, 06:46 PM
  4. Categories box. How can I create a new one (or two...)??
    By Csc in forum osCommerce 2.2 Modification Help
    Replies: 1
    Last Post: 01-15-2005, 03:20 PM
  5. uploading categories and products from ms1 to ms2-max 1.5
    By jloyzaga in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 09-14-2003, 07:56 PM

Bookmarks

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
  •