blog documentation FAQ followers forum marketplace services youtube

Add New Sibling - ERROR

The Jamroom Network » Forum » Genosis » Page » Add New Sibling - ERROR
Nerijus
Nerijus
@info1276
8 years ago
4 posts
I just installed latest Jamroom and Genosis.

Started new tree and after adding a sibling in siblings profile under photo I get this error message:

CRI: Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rel_tree_id = '0' AND rel_type IN('child','sibling')' at line 1

Why? How to fix it?
updated by @info1276: 10/21/16 10:49:38PM
brian
@brian
8 years ago
10,148 posts
Welcome to Genosis!

Make sure you have an ACTIVE tree_id - I can see from the partial query above that your tree_id is ZERO which is wrong. Click on "Trees" in the header then select the tree, then go to the ancestor and add a sibling.

Let me know if that helps.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Nerijus
Nerijus
@info1276
8 years ago
4 posts
Hi,

Yes I do have active tree and my Sibling was added but instead of her info under picture I get this error:
CRI: Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rel_tree_id = '0' AND rel_type IN('child','sibling')' at line 1

I completely reinstalled the script but same thing... I will attach image.

Just checked...same error for my spouse and children... only parents not giving error.
adrija.jpg
adrija.jpg  •  135KB

brian
@brian
8 years ago
10,148 posts
Yep - that's no good. We just pushed out a new release of the Genosis Core today - let me get a fresh install in place so I can see what is up and get it fixed.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
8 years ago
10,148 posts
OK this should be fixed now in Genosis Core 1.5.4 - go to your marketplace -> System Updates and update and that should prevent that error from coming out.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Nerijus
Nerijus
@info1276
8 years ago
4 posts
Thank you so much for such a quick reply and fix.
Nerijus
Nerijus
@info1276
8 years ago
4 posts
Now when trying to add Sibling got another error :

Query Error: Duplicate entry '1-9-1-4' for key 'uid_uniq'

After pressing Create New Person this error appears on top:

Query Error: Duplicate entry '1-9-1-4' for key 'uid_uniq'

But it ads sibling. So it is some very minor bug.
updated by @info1276: 07/19/16 04:28:55PM
brian
@brian
8 years ago
10,148 posts
I will check that out as you should not be seeing that.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Tags