Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Admin - category shows no products


larsba

Recommended Posts

Some of the categories in my store have more than 200 entries and the problem I have is that I can not see those categories in the Admin tool - categories/products I have checked the categories and products_to_categories, which seem to be OK.

 

Is there some limit I should know about ? Can any variable in MySQL cause this ?

 

Please help as this is making life difficult when wanting to update products in the big categories.

 

Regards,

 

Lars Barasinski

LB Consulting

www.pcshopping.be (set-up still going on)

Link to comment
Share on other sites

Some of the categories in my store have more than 200 entries and the problem I have is that I can not see those categories in the Admin tool - categories/products I have checked the categories and products_to_categories, which seem to be OK.

 

Is there some limit I should know about ? Can any variable in MySQL cause this ?

 

Please help as this is making life difficult when wanting to update products in the big categories.

 

Regards,

 

Lars Barasinski

LB Consulting

www.pcshopping.be (set-up still going on)

I would like to add that I now have checked that the categories.php is execting the correct statements and everthing looks fine. The echo statement that should produce the table content to be show on the screen is executed with the right content, but for some reason I never get to see that generated page - I still see the sub-category overview. For other smaller categories I can see the result, but not the categories that contain many products.

 

Please - does anyone have info about this behaviour in order to get it working.

 

Lars Barasinski

Link to comment
Share on other sites

I would like to add that I now have checked that the categories.php is execting the correct statements and everthing looks fine. The echo statement that should produce the table content to be show on the screen is executed with the right content, but for some reason I never get to see that generated page - I still see the sub-category overview. For other smaller categories I can see the result, but not the categories that contain many products.

 

Please - does anyone have info about this behaviour in order to get it working.

 

Lars Barasinski

 

After deleting all products in a category and afterwards adding them 1 by 1 I actually saw when the problem happened. To ensure that it was not data related I added just enough records to provoke the problem and them I removed a record, but not the last.

When the record was deleted I could again see the products for the category in the admin section.

 

Is there any memory limitation I should know about or how can this be solved ?

 

I have a category with more than 1000 products, but without the capabilities of updating the records inside the admin tool I can't finish my set-up, so please help me with this problem.

 

Lars Barasinski

Link to comment
Share on other sites

1000 products is nothing, i am thinking you have some code wrong, corrupt database, etc. what have you added contribution wise. when you deleted the items before, did you start from a totally clean database?

Link to comment
Share on other sites

I have just made a test on a new installation (MS2.2) in an empty domain.

 

No modifications made to any code.

 

I emptied the following tables:

categories

categories_description

manufacturers

manufacturers_info

products*

 

I added one int(11) field to the end of the products table.

 

After this I loaded my own data into categories, cate..._description, manufacturers, manu...info, products, products_description and products_to_categories.

 

Access to some of the categories in the admin part gives no result. On the public web-site the categories can be accessed fine and all products are visible, so it is specific to the code in the categories.php under the admin section. Could it be data related ? Could a raw import of data into products_description cause the HTML to be invalid and therefore not show up at all ?

 

As you can see I made a test where I had 185 records in a catagory - added one more (tried with different records), and the admin section suddenly didn't return any result anymore. The product was visible on the public part of the site.

If I removed the record again the admin section showed all the records again.

 

At the same time the products_attributes screen became unavailable, so there must be some data problems with the categories* tables.

 

I will continue investigating, but ideas are welcome.

 

Lars Barasinski

Link to comment
Share on other sites

I have now a database containing only 1 category, 1 sub-category and 195 products - most of then active and I still get the problem.

 

The only change that has been done is the addition of the field products_ext_id at the end of the products table.

 

If I remove 6 products the products will again show up in the admin section.

 

I have created a zip file with the content of the tables categories, categories_description, products, products_description and products_to_categories in case someone want to take a look and maybe quickly can say what's wrong, but can I attach them anywhere on this forum ?

 

In case anyone has the time to do a quick check, the file can be picked up on http://www.barasinski.com/admin_err.zip

 

 

Lars Barasinski

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...