ProductCart Shopping Cart Software Forums : Error in main database query on addProudctB.asp https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 06:02:17 +0000 Wed, 05 Oct 2011 19:31:43 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4754 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Error in main database query on addProudctB.asp : Ok, heard back from the host,...]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18440.html#18440 Author: bcrabtree
Subject: 4754
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.
]]> Wed, 05 Oct 2011 19:31:43 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18440.html#18440 <![CDATA[Error in main database query on addProudctB.asp : That&#039;s what I thought at...]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18436.html#18436 Author: bcrabtree
Subject: 4754
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.]]> Wed, 05 Oct 2011 16:11:36 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18436.html#18436 <![CDATA[Error in main database query on addProudctB.asp : it appears you filled your database....]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18435.html#18435 Author: Greg Dinger
Subject: 4754
Posted: 05-October-2011 at 4:06pm

it appears you filled your database.  ask your host.]]> Wed, 05 Oct 2011 16:06:16 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18435.html#18435 <![CDATA[Error in main database query on addProudctB.asp : Ok cool, thank you. I&#039;ve...]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18433.html#18433 Author: bcrabtree
Subject: 4754
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.
]]> Wed, 05 Oct 2011 15:52:33 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18433.html#18433 <![CDATA[Error in main database query on addProudctB.asp : Hi, Your site is not allowing...]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18429.html#18429 Author: Hamish
Subject: 4754
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

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.

]]> Wed, 05 Oct 2011 04:58:32 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18429.html#18429 <![CDATA[Error in main database query on addProudctB.asp : Please submit a support request...]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18427.html#18427 Author: Greg Dinger
Subject: 4754
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.]]> Tue, 04 Oct 2011 20:16:49 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18427.html#18427 <![CDATA[Error in main database query on addProudctB.asp : I&#039;m still having the issue.I...]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18426.html#18426 Author: bcrabtree
Subject: 4754
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.
]]> Tue, 04 Oct 2011 20:09:41 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18426.html#18426 <![CDATA[Error in main database query on addProudctB.asp : start here: http://wiki.early...]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18367.html#18367 Author: Greg Dinger
Subject: 4754
Posted: 25-September-2011 at 3:08pm

start here:
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.
]]> Sun, 25 Sep 2011 15:08:53 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18367.html#18367 <![CDATA[Error in main database query on addProudctB.asp : I&#039;m receiving the following...]]> https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18366.html#18366 Author: bcrabtree
Subject: 4754
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?
]]> Sun, 25 Sep 2011 15:00:10 +0000 https://forum.productcart.com/error-in-main-database-query-on-addproudctb-asp_topic4754_post18366.html#18366