PDA

View Full Version : Fatal error in show_products.func after product upload



cathobby
May 19th, 2003, 06:30 PM
Hi all,
I've uploaded new product information into the "Products" table and have uploaded categories into the "Categories" table. I added the category parent/child records into the "REL_SubCats__Cats"
table AND the product/category records into the "REL_Products__Categories" table.

From the demo.php page, the Categories appear fine in the menu on the left and in the listing in the center, but when I click a category to view actual products I get the following error:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/cathobby/public_html/squirrelcart/functions/show_products.func on line 345

We do have almost 40,000 products in the database... is the cart able to handle this much data? Or, did I perhaps miss a database piece in the upload? :confused:

Here's a link in case you need it: http://www.cathobby.com/demo.php

Jenifer

Jamie
May 20th, 2003, 04:24 PM
Hi Jenifer,

The cart can definitely handle that many products. It sounds like you may have a database problem. Can you please export your DB to a file, and place it somewhere so we can download it and check it out? If you prefer, you could send us information to login to phpMyAdmin and view it live. Either way, please send the info via a helpdesk ticket so your information is not in the forums for everyone to see.

Thanks!
Jamie

cathobby
May 20th, 2003, 04:30 PM
Okay, I just sent the information via the help desk.

Thanks!

Jenifer

cathobby
June 3rd, 2003, 02:10 AM
I wanted to let everyone know that this turned out to be a dumb error on my part when uploading the category information. I had zeros in a column where it should have been empty strings. heh. oops.

codeman43
October 4th, 2004, 10:19 AM
HI Jamie,

Was this a database problem? I seem to haave the same problem, Fatal error: Maximum execution time of 30 seconds exceeded in /home/user/public_html/squirrelcart/functions/show_products.func on line 234.

The line number changes from 232 to 234, but I don't know what the problem is. If you need to check it out, you have the login from the other issue tickets.

Thanks.

Jamie
October 4th, 2004, 09:06 PM
Hi,

I don't remember what caused this issue. It was over a year ago. I am working on your ticket now.

Thanks,
Jamie

codeman43
October 4th, 2004, 09:14 PM
Okay, thanks.