CF Error on Adding a Discount in Admin

in Cartweaver ColdFusion • 1 year ago

This is a new install of the latest CartWeaver. I'm trying to add a new discount and it's throwing me a CF/Database error. Please advise. Thanks

- Korey

Error Executing Database Query.
Cannot add or update a child row: a foreign key constraint fails (`jackrabbits_cw/tbl_discount_amounts`, CONSTRAINT `tbl_discount_amounts_ibfk_1` FOREIGN KEY (`discountAmount_id`) REFERENCES `tbl_discounts` (`discount_id`))

The error occurred in D:\home\shopjackrabbits.com\wwwroot\store\cw3\Admin\DiscountDetails.cfm: line 174
Called from D:\home\shopjackrabbits.com\wwwroot\store\cw3\Admin\DiscountDetails.cfm: line 127
Called from D:\home\shopjackrabbits.com\wwwroot\store\cw3\Admin\DiscountDetails.cfm: line 1
Called from D:\home\shopjackrabbits.com\wwwroot\store\cw3\Admin\DiscountDetails.cfm: line 174
Called from D:\home\shopjackrabbits.com\wwwroot\store\cw3\Admin\DiscountDetails.cfm: line 127
Called from D:\home\shopjackrabbits.com\wwwroot\store\cw3\Admin\DiscountDetails.cfm: line 1

172 :
173 :
174 : <cfquery datasource="#request.dsn#" username="#request.dsnUsername#" password="#request.dsnPassword#">
175 : INSERT INTO tbl_discount_amounts
176 : (discountAmount_minimumAmount,

Replies(3)

Michael E.. Team Cartweaver

Re: CF Error on Adding a Discount in Admin

1 year ago

Hi Korey,

the error gives it away - a foreign key 'constraint fails' meaning "what one table expects in a certain column of another table isn't what it is getting".

Not to worry - if this is mySQL you can, from my experience, remove the foreign key (using a tool like navicat makes it extremely easy to do so) - this may produce another CF error or things might work just fine afterwards, depending on the details of the underlying problem. As an application, CW has all of the relationships it needs defined right in the queries themselves , so the fk is really just a failsafe on the database side.

Probably a good idea to first check out the full query code that is being passed by CF,

and see if there isn't something more obvious at play.

Was this by any chance an 'upsize' from an access database? I've seen lots of similar issues with foreign keys during the upsize process.

Michael Evangelista
Team Cartweaver (CF)
Twitter: http://twitter.com/m_evangelista
--
ColdFusion Reseller Hosting
http://www.GoWestHosting.com
CF Programming / Web Design
http://www.GoWestWeb.com

terrancre..

Re: CF Error on Adding a Discount in Admin

1 year ago

I do use Navicat - would I open the table up in design view, select the Foreign Keys tab and delete the row? There is only one row there for that table.

I took a quick look through the code and nothing jumped out at me. What I did try was commenting out all the insert values (for the query throwing the error only) with the cfqueryparam tags and then just used the bare form variables instead - exact same CF error.

In fact, this was an 'upsize' from the default access database - I didn't realize there was any other way to create the database. I only found the default access database (which I imported into Navicat to create the MySQL database), and then the MySQL update files.

Thanks for your insight. I'll wait for your reply before making any changes.

Korey

terrancre..

Re: CF Error on Adding a Discount in Admin

1 year ago

I just went ahead and removed the FK and it works! That was a painless fix!

Thanks for your help!

Korey

Top Reply

Response title

Attachments

New to this Portal?