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,011
    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,011
    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,011
    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, 07:21 PM
  2. No Products in Categories box
    By kenlyle in forum osCmax v1.7 Discussion
    Replies: 2
    Last Post: 11-06-2005, 06: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, 02: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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •