Error: Call to a member function fetch_object()

[Robert Pace]

I checked out the latest code via svn today and after configuring all the files, I started getting this error:

( ! ) Fatal error: Uncaught Error: Call to a member function fetch_object() on boolean in D:\wamp64\www\symbiota\classes\ProfileManager.php on line 72

( ! ) Error: Call to a member function fetch_object() on boolean in D:\wamp64\www\symbiota\classes\ProfileManager.php on line 72

Call Stack#TimeMemoryFunctionLocation

10.0024395224   {main}( )...\index.php:0

20.0147692704   ProfileManager->authenticate( )...\index.php:68

My setup is: Wamp64 utilizing Apache 2.4.20, MySQL 5.7.12, and PHP 7.0.5.

[Herrick Brown]

I suspect that might be a timeout error check your settings on the wamp  server. And look at line 72 in profile manager.php. 

--
You received this message because you are subscribed to the Google Groups "Symbiota" group.
To unsubscribe from this group and stop receiving emails from it, send an email to symbiotagrou...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Robert Pace]

Hi Herrick,

Here is what I am seeing in regards to this general error.

http://w3guy.com/fatal-error-call-member-function-fetch_object-non-object/

I think it has to do with the query results being of a different type than expected.

Here is the section of code that is throwing the error:

--
You received this message because you are subscribed to a topic in the Google Groups "Symbiota" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/symbiotagroup/qILClk5jno4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to symbiotagrou...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Robert Pace
Cell: (606) 621-9012
Moore #125 Spatial Data Research Lab
EKU Herbarium Memorial Science #170
robert...@mymail.eku.edu
rober...@eku.edu
http://people.eku.edu/pacer/
Richmond, KY
USA
--

[Herrick Brown]

Perms to write to DB.  I'm just grasping at straws here. 

[Robert Pace]

Hi Herrick,

Just tried with dbconnections  using root credentials for MySQL server and still same error.

On Friday, May 13, 2016 at 7:00:38 PM UTC-4, Herrick Brown wrote:

Perms to write to DB.  I'm just grasping at straws here. 

On Friday, May 13, 2016, Robert Pace <que...@gmail.com> wrote:

Hi Herrick,

Here is what I am seeing in regards to this general error.

http://w3guy.com/fatal-error-call-member-function-fetch_object-non-object/

I think it has to do with the query results being of a different type than expected.

Here is the section of code that is throwing the error:

On Fri, May 13, 2016 at 6:29 PM, Herrick Brown <herric...@gmail.com> wrote:

I suspect that might be a timeout error check your settings on the wamp  server. And look at line 72 in profile manager.php. 

On Friday, May 13, 2016, Robert Pace <que...@gmail.com> wrote:

I checked out the latest code via svn today and after configuring all the files, I started getting this error:

( ! ) Fatal error: Uncaught Error: Call to a member function fetch_object() on boolean in D:\wamp64\www\symbiota\classes\ProfileManager.php on line 72

( ! ) Error: Call to a member function fetch_object() on boolean in D:\wamp64\www\symbiota\classes\ProfileManager.php on line 72

Call Stack#TimeMemoryFunctionLocation

10.0024395224   {main}( )...\index.php:0

20.0147692704   ProfileManager->authenticate( )...\index.php:68

My setup is: Wamp64 utilizing Apache 2.4.20, MySQL 5.7.12, and PHP 7.0.5.

--
You received this message because you are subscribed to the Google Groups "Symbiota" group.

To unsubscribe from this group and stop receiving emails from it, send an email to symbiotagroup+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "Symbiota" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/symbiotagroup/qILClk5jno4/unsubscribe.

To unsubscribe from this group and all its topics, send an email to symbiotagroup+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Robert Pace
Cell: (606) 621-9012
Moore #125 Spatial Data Research Lab
EKU Herbarium Memorial Science #170
robert...@mymail.eku.edu
rober...@eku.edu
http://people.eku.edu/pacer/
Richmond, KY
USA
--

--
You received this message because you are subscribed to the Google Groups "Symbiota" group.

To unsubscribe from this group and stop receiving emails from it, send an email to symbiotagroup+unsubscribe@googlegroups.com.

[Ed Gilbert]

Robert,

 

See if the following SQL successfully runs on your database. It’s not going to return any results because your won’t have that user/password combination, but it should return the SQL server error that is causing your problem. This is the SQL causing the PHP error.

 

SELECT u.uid, u.firstname, u.lastname

FROM users u INNER JOIN userlogin ul ON u.uid = ul.uid

WHERE (ul.username = "JoeUser")

AND (ul.password = PASSWORD("SamplePassword") OR ul.password = OLD_PASSWORD("SamplePassword "))

 

-Ed

--

You received this message because you are subscribed to the Google Groups "Symbiota" group.

To unsubscribe from this group and stop receiving emails from it, send an email to symbiotagrou...@googlegroups.com.

[Robert Pace]

Hi Dr. Gilbert,

Here is the results of your query:

Error

SQL query: 

SELECT u.uid, u.firstname, u.lastname 
FROM users u INNER JOIN userlogin ul ON u.uid = ul.uid
WHERE (ul.username = "JoeUser")
AND (ul.password = PASSWORD("SamplePassword") OR ul.password = OLD_PASSWORD("SamplePassword "))

MySQL said: 

#1305 - FUNCTION symbiota.OLD_PASSWORD does not exist

--
You received this message because you are subscribed to a topic in the Google Groups "Symbiota" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/symbiotagroup/qILClk5jno4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to symbiotagrou...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Robert Pace]

Could this have anything to do with the problem?

http://dev.mysql.com/doc/refman/5.7/en/password-hashing.html

It looks like there may have been some changes to the old_password function in version 5.7.5+

[Robert Pace]

I changed line 72 of the ProfileManager.php to

if($pwdStr) $sql .= 'AND (ul.password = PASSWORD("'.$this->cleanInStr($pwdStr).'")) ';

and it fixed the problem for me.

--

You received this message because you are subscribed to a topic in the Google Groups "Symbiota" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/symbiotagroup/qILClk5jno4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to symbiotagrou...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ed Gilbert]

Robert,

 

Yes, you are right OLD_PASSWORD has been redacted from the latest version of PHP. Furthermore, it’s not really needed anymore. I removed the old code from GitHub.  

 

https://github.com/Symbiota/Symbiota/commit/f70429f6b013f705e0e87e7d0d4e1e3a9f9ef132

 

Thanks for the heads up.

 

-Ed

 

 

 

From: symbio...@googlegroups.com [mailto:symbio...@googlegroups.com] On Behalf Of Robert Pace

Sent: Friday, May 13, 2016 4:28 PM
To: Symbiota <symbio...@googlegroups.com>

--

You received this message because you are subscribed to the Google Groups "Symbiota" group.

To unsubscribe from this group and stop receiving emails from it, send an email to symbiotagrou...@googlegroups.com.