tng_users table issue

There should not be two databases. Both Drupal and TNG need to be installed in the same database.

Andrew, you should install and configure TNG (using the same database as Drupal), before you enable and configure tngintegrate.
—Alex

I'm having a similar problem:
-fresh install of drupal 7.14
-enabled hidden "profile" module
-TNG installed in sites/all/libraries/tng, using same database as drupal install.
-installed and enabled module "The Next Generation Integration" v7.x-1.0
-can successfully access the TNG site via http://mysite.com/sites/all/libraries/tng/

When I try to change and save any configuration on the configuration page for the TNGintegration module, I get an error:
"The TNG user information table "tng_users" was not found. Perhaps the TNG Genealogy software is not initialized."

I have confirmed the table "tng_users" does indeed exist in the database.

-Paul

GreenDog, did you initialize (i.e. configure) TNG as prescribed in the installation instructions from Darrin Lythgoe? You should initialize TNG immediately after installing it, and before enabling the Drupal "The Next Generation Integration" module. During the TNG initialization/configuration, make sure you specify tng_users (the default) as the name of the users table for TNG in the same database used by Drupal. If you specify a different name, then you should change the name accordingly once you enable and configure the Drupal "The Next Generation Integration" module.

The installation procedure is a bit user-unfriendly, mainly because TNG is in fact not integrated as a Drupal module, but only interfaced to Drupal and hidden behind it.

Hope this helps.

A.

Alexxikon - Thanks for posting.

Yes, I walked through the initiation/configuration of the TNG installation before I installed and enabled the tngintegrate module.

To confirm, today I did a fresh install:
-installed drupal 7.14
-installed TNG 9.02, using the same database as the drupal installation.
-installed and enabled the tngintegration module v7.x-2.0-beta2
-while enabling the module, encountered a essage saying t needed to enable the hidden Profile. I let it.
-then got an error message:
"DatabaseSchemaObjectExistsException: Table tngintegrate already exists. in DatabaseSchema->createTable() (line 657 of
/includes/database/schema.inc)."
-I then disabled the tngintegrate module, then enabled it, with no errors.
-I still get error "The TNG user information table "tng_users" was not found. Perhaps the TNG Genealogy software is not initialized." when i try to save any changes on the TNG Integration configuration page in drupal administration.

GreenDog, I will need to try to duplicate your environment to see if I can diagnose the problem.

I just want to make sure that, before enabling the Drupal tngintegration module, you ran the TNG configuration script by pointing your browser to http://mysite.com/sites/all/libraries/tng/readme.html and you followed all the steps which should have completed successfully.

If you did do that, please confirm this, before I try to duplicate your problem. Your message above only reports installing TNG 9.02, but you said nothing about configuring it and receiving a notification of successful completion.

(Note that you may have to open a temporary alternate access to the readme.html file on your hosting provider via an Addon domain that points to the public_html/sites/all addon directory. This is necessary because Drupal prevents you from accessing readme.html on the server. If you don't understand what I mean, chances are that you did not initialize TNG at all, as I don't think there is another way, unless you have direct control of your host.)

A.

Yes, I did configure TNG prior to enabling the Drupal tngintegration module, using the readme.html on the server.

I was able to access it by using http://mysite.com/sites/all/libraries/tng/readme.html

I used the express method. No errors, all steps completed successfully. I also accessed the tng web site, using http://mysite.com/sites/all/libraries/tng/index.php and I was able to login as the admin. I tested navigating the site, and could make changes in the administration section.

I then went back to my drupal site and downloaded and enabled the tngintegrate module, following the instructions in the readme file.

GreenDog, sorry for not following up earlier. I don't know what your problem might be, but I suspect that the express installation of TNG sets up a separate database.

I just tried to re-install and configure from scratch and everything worked fine for me. This is the log of the procedure:

1. Create Drupal 7 site (let's call it for example www.yoursite.com), per instructions at http://drupal.org (I am using version 7.17 of the Drupal core)
2. Install the TNG Integrate module
3. Download the latest version of The Next Generation (I am using version 9.0.4) and install it under /my_drupal_root/sites/all/libraries/tng, where /my_drupal_root is the installation root of your Drupal site, sometimes called /public_html by some hosting services.
4. Open /my_drupal_root/sites/all/libraries/tng/readme.html in your browser and follow the Regular Installation procedure (IMPORTANT: you must open the readme.html file that is installed on the host machine, not a copy, and you must open it with http:// protocol, not with file:// protocol)
5. Configure TNG to use the same database as Drupal (the database name, username, and password are in the /my_drupal_root/sites/default/settings.php file if you have a single-site Drupal setting, or in the /my_drupal_root/sites/www.yoursite.com/settings.php file if you have a multi-site Drupal setting)
6. Enable the TNG Integrate module
7. Set the permissions of the TNG Integrate module (you should probably give the Drupal administrator also the TNG Genealogy administrator rights; other users should have rights to view the TNG Genealogy)
8. Configure the TNG Integrate module, specifying sites/all/libraries/tng as the Path to TNG directory
9. Navigate to the home page of www.yoursite.com and click on the TNG Genealogy link

Note that, if any of these steps fails or is not carried out completely and properly, chances are that the integration between Drupal and TNG will not work.

Hope this helps

Alex

I am closing this issue because I cannot duplicate the problem.
Please try to follow to the letter the instructions provided in comment #9 and, if you still have a problem, please open another issue and provide enough detail for me to try to duplicate.