Admin Manage Products doesn't list all products

Ok guys my second post here today, now I have an actual problem rather than just trying to do some research for a potential problem. As I've said in my other post we have well over 400 products, we may even end up with over 1200 products if my other post is correct and we have to have one product code for each payment period (i.e. 1 month, 6 months and yearly) per product, anyway I've now come up against what I believe to be a rather fatal problem for us, in that the admin interface for manage products does not appear to actually list all products.

There only appears to be one page, there are no next or back buttons or any page numbers to be able to jump to the next page of products etc.

Does anyone know if there's a way around this? I do know of issues with MySQL and retrieving too many rows at once, so I'm wondering if a limit has been added to the MySQL statement that retrieves the products in the admin interface, if so great it gets round the MySQL bug but why is there no option for moving to another page of products?

Any help or advice here is appreciated.

Hi Alex,

You definitely have A LOT of products

I'm not sure if aMember suits the site model you would like to build. Give me an email codeispoetry [at] amemberincremental.com if you don't mind sharing more about your system and membership site model.

Cheers,
Lee

Thanks Lee, the conversation over email was actually quite helpful.

At this point it's looking like I may have to either completely write from scratch a subscription system, look further afield for something with more features (I'm told there isn't anything) or find religion and start praying ( Not likely).

If anyone here can give any advice on why I cannot view more than one page of products in the admin interface and why it only seems to show 200 - 300 out of my 400 products in the interface I would very much appreciate the advice.

thanks

Alex

does the page time out, and get cut off at the bottom (not giving you the bottom links to Signup Link wizard and such due to the cut off)?

or you just get a random 200-300 products listed and the page loads just fine?

Yeah, I can't see it being an amember problem... most likely something timing out on his server...

There are no mysql or php timeouts, no errors, the page appears to load absolutely fine. There are no special settings on my server for timeouts, just the usual php restriction of no more than 30 seconds to complete the task etc etc.