Hello,
The module is not working when drupal is using Mysqli and also shows lots of errors on the screen.
Everthing works fine when switching the drupal settings to use mysql.
Here is an error I see when entering the config for tngintegration
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 366.
Here are the errors when I browse to the home page.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 123.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 308.
warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\wamp\www\drupal\includes\common.inc on line 1986.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 123.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 308.
user warning: Duplicate entry 'patrick' for key 2 query: INSERT INTO tng_users (UserID, description, username, password, realname, email, dt_activated) VALUES (3, 'patrick','patrick','cfb70ffd1f49dd8df4e1a6ec8b044b8c','patrick', 'PATRICKACRAIG@FASTMAIL.FM', '2008-03-23 00:32:50') in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
user warning: Duplicate entry '1' for key 1 query: INSERT INTO tngintegrate (uid, tuid, created, lastlogin) VALUES (1, 3, 1206250370, 1206250370) in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 123.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 308.
user warning: Duplicate entry 'patrick' for key 2 query: INSERT INTO tng_users (UserID, description, username, password, realname, email, dt_activated) VALUES (3, 'patrick','patrick','0f2a2d0eebdc1bd5da5cacc2e683c4bd','patrick', 'PATRICKACRAIG@FASTMAIL.FM', '2008-03-23 00:32:51') in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
user warning: Duplicate entry '1' for key 1 query: INSERT INTO tngintegrate (uid, tuid, created, lastlogin) VALUES (1, 3, 1206250371, 1206250371) in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 123.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 308.
user warning: Duplicate entry 'patrick' for key 2 query: INSERT INTO tng_users (UserID, description, username, password, realname, email, dt_activated) VALUES (3, 'patrick','patrick','b07bc546bb76d1b244bd66205e171258','patrick', 'PATRICKACRAIG@FASTMAIL.FM', '2008-03-23 00:32:52') in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
user warning: Duplicate entry '1' for key 1 query: INSERT INTO tngintegrate (uid, tuid, created, lastlogin) VALUES (1, 3, 1206250372, 1206250372) in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 123.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 308.
user warning: Duplicate entry 'patrick' for key 2 query: INSERT INTO tng_users (UserID, description, username, password, realname, email, dt_activated) VALUES (3, 'patrick','patrick','e0dd580d5228d67db18a843b106e15bc','patrick', 'PATRICKACRAIG@FASTMAIL.FM', '2008-03-23 00:32:52') in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
user warning: Duplicate entry '1' for key 1 query: INSERT INTO tngintegrate (uid, tuid, created, lastlogin) VALUES (1, 3, 1206250372, 1206250372) in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 123.
warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\drupal\modules\tngintegrate\tngintegrate.module on line 308.
user warning: Duplicate entry 'patrick' for key 2 query: INSERT INTO tng_users (UserID, description, username, password, realname, email, dt_activated) VALUES (3, 'patrick','patrick','f9d751f9719d73f7067f71efaba9e2ba','patrick', 'PATRICKACRAIG@FASTMAIL.FM', '2008-03-23 00:32:53') in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.
user warning: Duplicate entry '1' for key 1 query: INSERT INTO tngintegrate (uid, tuid, created, lastlogin) VALUES (1, 3, 1206250373, 1206250373) in C:\wamp\www\drupal\includes\database.mysqli.inc on line 151.I am using WAMP with PHP 5.2.5
Comments
Comment #1
arturoramos commentedTo fix the bug related to not running MySQL, can you try changing the following line in the tngintegrate.module file?
if (mysql_num_rows($result) == 0) {
to
if (!db_num_rows($result)) {
Comment #2
arturoramos commentedSee newest 2.4 version which should address this bug.
Comment #3
spankee commentedI had to make that change in two spots. I also had to make two more changes.
if (mysql_num_rows($result)) {
to
if (!db_num_rows($result)) {
I don't know if it is correct but the errors went away.
Thanks
Comment #4
spankee commentedI made that last post after you posted. I will check out 2.4