#181 SVN Revision 1117

[Anonymous]

After new install, get the following error when trying to authenticate:

Fatal error: Call to a member function numRows() on a non-object in /var/www/localhost/htdocs/login.php on line 289

[Kenneth Kline]

Ok this sounds like we have some new table fields not in the database.

do the following:

[root@fs1 opt]# cat /opt/Inprotect/install/REV
1.9.2.015

[root@fs1 opt]# mysql -p inprotect3
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 123078
Server version: 5.1.40 Mandriva Linux - MySQL Standard Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select settingValue from inprotect_Settings where settingName='version';
+--------------+
| settingValue |
+--------------+
| 1.9.2.015 |
+--------------+
1 row in set (0.00 sec)

mysql> describe inprotect_Users;
+------------------+---------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------+------+-----+-------------------+-----------------------------+
| userID | int(11) | NO | PRI | NULL | auto_increment |
| pn_uname | varchar(25) | NO | UNI | NULL | |
| pn_email | varchar(60) | NO | | NULL | |
| pn_pass | varchar(40) | NO | | NULL | |
| pass_lastchanged | datetime | NO | | NULL | |
| expire | varchar(8) | YES | | NULL | |
| locked | int(11) | NO | | 0 | |
| lockout_reset | datetime | YES | | NULL | |
| forcePassChange | enum('0','1') | NO | | 0 | |
| dtCreated | datetime | NO | | NULL | |
| lastaccessed | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| owniponly | char(1) | NO | | N | |
| defProfile | int(11) | NO | | 1 | |
| user_TZ | varchar(25) | YES | | NULL | |
+------------------+---------------+------+-----+-------------------+-----------------------------+
14 rows in set (0.14 sec)

mysql>

I suspect the following may not be in your database

forcePassChange or QQ_deleted

[Kenneth Kline]

Ok, it looks like a few files from my post 1.9.2.15 got published early. as the schema is not there.

per grep QQ_deleted on /opt/Inprotect/install/sql/upgrade* not returning an entry. I will have to go through the new code and get it merged back in. I am currently enhancing the logging for reporting purposes, etc.

otherwise for now edit the following line

285 & 293 to remove the QQ_deleted code. A newer version will be published in short term.

example:

285 $query = "SELECT userID, pass_lastchanged, expire, locked, DATE_FORMAT(lockout_reset, '%Y%m%d%H%i%s') as lockout_reset, forcePassChange, pn_email
FROM inprotect_Users
WHERE pn_uname = '$username'";

293 list( $userID, $pass_lastchanged, $expire, $locked, $lockout_reset, $forcePassChange, $pn_email ) = $result->fields;