• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Strange constraint violation
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Strange constraint violation


  • Subject: Re: Strange constraint violation
  • From: Chuck Hill <email@hidden>
  • Date: Fri, 30 Sep 2011 11:12:27 -0700

It sure looks like you have a constraint that says t_pool.id = t_pool.id.  Check in FB manager.


On 2011-09-30, at 11:06 AM, Jeff Schmitz wrote:

> Hi Pascal,
>
> Yes, it gets the same error when executed directly from FrontbaseManager:
>
> INSERT INTO "t_pool"("c_spare_string", "c_name", "c_paid", "c_admin_email", "c_can_i_wins_calculated", "c_ud_bonus", "c_possibilities", "c_admin_pw", "c_weighted", "c_password", "c_stand_alone", "c_early_bird_paid", "c_entry_limit", "c_can_i_win_index", "c_seed_type", "c_admin_msg", "c_calculating_can_i_wins", "id", "c_pool_type", "c_updating_results", "applicationStateID", "c_results_index", "c_allow_one_entry_per_user") VALUES ('', 'ZEBRAS NEW 401K PLAN', 'false', 'email@hidden', 'false', 'false', 1, 'pw', 'false', 'pw', 'false', 'false', 0, 0, 0, NULL, 'false', 1000002, 1, 'false', 1000001, 0, 'false');
>
> Exception 361 (23:000). Integrity constraint violation (FOREIGN KEY, t_pool.t_pool_id_id_FK(id=1000002)).
> Exception 363 (40:000). Transaction rollback.
>
> Again, there is no row with id 1000002 in the t_pool table.
>
> Thanks,
> Jeff
>
> On Sep 30, 2011, at 6:33 AM, Pascal Robert wrote:
>
>>> withBindings:
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden

--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects







 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >Strange constraint violation (From: Jeff Schmitz <email@hidden>)
 >Re: Strange constraint violation (From: Pascal Robert <email@hidden>)
 >Re: Strange constraint violation (From: Jeff Schmitz <email@hidden>)

  • Prev by Date: Re: Strange constraint violation
  • Next by Date: Re: Strange constraint violation
  • Previous by thread: Re: Strange constraint violation
  • Next by thread: Re: Strange constraint violation
  • Index(es):
    • Date
    • Thread