Error using Cousins mod (unknown column)

[Barry Ennever 0]

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

[Newfloridian 0]

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  

 

 

[Barry Ennever 0]

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

[Ken Roy 0]

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

[Barry Ennever 0]

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