Can't create categories / products

[fidsalazar]

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,

[ogilirca]

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.

[wwwspeedsourceca]

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.

[wwwspeedsourceca]

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!

[michael_s]

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?)

[wwwspeedsourceca]

It definately was not auto_increment for me...

[michael_s]

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.

[shoppingmantra]

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]

[michael_s]

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

[shoppingmantra]

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