Using ProductCart - Error in main database query on addProudctB.asp

Print Page | Close Window

Error in main database query on addProudctB.asp

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4754
Printed Date: 06-March-2025 at 11:10am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Error in main database query on addProudctB.asp

Posted By: bcrabtree
Subject: Error in main database query on addProudctB.asp
Date Posted: 25-September-2011 at 3:00pm

I'm receiving the following error message when attempting to clone a product:
"Error in main database query on addProudctB.asp"
I can add and edit products just fine though.

I've searched this error message and only came up with a couple solutions, both of which did not work for me.

Any suggestions?

Replies:

Posted By: Greg Dinger
Date Posted: 25-September-2011 at 3:08pm

start here:

http://wiki.earlyimpact.com/how_to/show_raw_errors" rel="nofollow - http://wiki.earlyimpact.com/how_to/show_raw_errors

Make a similar change to adminv.asp in your admin folder.

Presumably you have altered something in your store, and the aabove procedure should allow you to detect what got broken.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: bcrabtree
Date Posted: 04-October-2011 at 8:09pm

I'm still having the issue.

I tried commenting out the "on error resume next" lines and now all I get is a 500 Internal Server error.

Posted By: Greg Dinger
Date Posted: 04-October-2011 at 8:16pm

Please submit a support request Brian. You are asking for assistance beyond what can likely be accomplished here in the forum. Someone with development skills, and an understanding of server settings, likely needs to become involved.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Hamish
Date Posted: 05-October-2011 at 4:58am

Hi,
Your site is not allowing raw errors. Not only as it relates to this issue, but also going forward... it's
imperative for troubleshooting purposes that your server be able to show the raw (detailed) error to the browser. Please contact your hosting provider and have them make the change on the server, which is explained under (a)
here:

http://classicasp.aspfaq.com/general/why-do-i-get-a-500-internal-server-error-for-all-asp-errors.html" rel="nofollow - http://classicasp.aspfaq.com/general/why-do-i-get-a-500-internal-server-error-for-all-asp-errors.html

It's the IIS setting called "Send detailed error messages to the client".
Once we know the actual error, we can debug the problem. In IIS 7, you might have to use a "web.config" file to force the raw error to be shown. If that's not possible, you can find the actual error in the server logs.

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: bcrabtree
Date Posted: 05-October-2011 at 3:52pm

Ok cool, thank you. I've sent a request to my host to turn on client side debugging.

But in the meantime I checked my server log and saw this error:
2011-10-05 19:44:39 W3SVC82 PSS005 50.22.14.85 POST /shop/cms/addProductB.asp |492|80040e14|Could_not_allocate_space_for_object_'dbo.products'_in_database_'mydatabase'_because_the_'PRIMARY'_filegroup_is_full._Create_disk_space_by_deleting_unneeded_files__dropping_objects_in_the_filegroup__adding_additional_files_to_the_filegroup__or_setting_autogrowth_on_for_existing_files_in_the_filegroup.

Posted By: Greg Dinger
Date Posted: 05-October-2011 at 4:06pm

it appears you filled your database. ask your host.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: bcrabtree
Date Posted: 05-October-2011 at 4:11pm

That's what I thought at first. But the error only occurs when I try to CLONE a product. I can add new products just fine.

Posted By: bcrabtree
Date Posted: 05-October-2011 at 7:31pm

Ok, heard back from the host, looks like there was an error when they transferred my DB from my old host. All good now.