Jump to content
TNG Community
Barry Ennever

Error using Cousins mod (unknown column)

Recommended Posts

Barry Ennever

Hello, I have recently installed the Cousins mod and I would recommend it to anyone who is interested in the sometimes complex relationships which exist in close families.

In 8 of my 9 trees it works perfectly while in one tree I receive the following error msg:

"An error has occurred in the TNG software. This could be due to a setup issue, an incomplete upgrade or a program bug. If you are the site owner, you may contact TNG support for help with this problem. Please copy the query below and paste it into your message.

Query: insert into tng_inlaw_marriages (gedcom,husband) VALUES (Ennever6,'-1')

Unknown column 'Ennever6' in 'field list'  "

Can anyone help plse?

Many thanks

Barry

Share this post


Link to post
Share on other sites
Newfloridian

Hi Barry

The final release versions of the cousins mod may have been updated (polished) since I had my own version. However I believe that the error message is coming from this segment of code:

    $res = tng_query("select * from $table where gedcom='$tree'");
    if (tng_num_rows($res) ==0) {
        tng_query("insert into $table (gedcom,husband) VALUES ($tree,'-1')");
        return false;
    }

If the mod works satisfactorily for 8 of your 9 trees, it could be that there is an error somewhere in the naming of the ninth tree.

Alan  

 

 

Share this post


Link to post
Share on other sites
Barry Ennever

Thanks Alan, the tree name had brackets in it but then so did other trees for which the report worked ok. 

I did remove the brackets but no change unfortunately.

There's so little data in the tree name and mine are all the same format so that make's it hard to work out what could be at fault.

Barry

Share this post


Link to post
Share on other sites
Ken Roy

Report the problem to the developer.  Chris may not be monitoring the forum

Share this post


Link to post
Share on other sites
Barry Ennever

Chris has identified the problem & will issue an update asap.

Line 339 of in-law marriages should read:

                        tng_query("insert into $table (gedcom,husband) VALUES ('$tree','-1')");

 

Barry

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×