Jump to content


setrelation_n_n doesn't show items until saved by grocerycrud

unicode setrelation join data missing database

  • Please log in to reply
1 reply to this topic

#1 dwasden

dwasden

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 26 September 2012 - 01:54 PM

GroceryCRUD is great, but I have run into a showstopper. I am hoping there is a solution.

I created a setrelation_n_n for my categories. It works perfectly, in that if I create a category from within the groceryCRUD (GC) edit form, they are saved and visible when I come back. However I have hundreds of items that already have these database entries (not added by GC) and they are not visible in my groceryCRUD edit form until I change them there. GroceryCRUD does not create duplicates; it updates the existing ones, but after they are edited in GC, they are visible. I am thinking that maybe they cannot initially be seen due to unicode characters or something. I am reporting it as a bug, but if there is some solution I am missing, please let me know.

#2 dwasden

dwasden

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 27 September 2012 - 06:28 AM

I will answer my own question here. Turns out it has nothing to do with the collation or character-set. Just my data model design. My n to n relationship was not pointing to the primary key of the main table in the relationship. I made my unique key the primary key, and all was well. sorry for wasting anyone's time.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users