DBH Call to a member function execute() on boolean

[rogoit]

Hi,

i got this bug. Can anybody help please ;)

Call to a member function execute() on boolean in /projectpath/vendor/codeception/codeception/src/Codeception/Module/Dbh.php on line 121

See you
Roland

[tomtomsen]

I think:

it seems like you are generating an invalid query. probably in the criteria parameter of seeInDatabase or dontSeeInDatabase.
But you are right the result of ->prepare($query) should be validated and a different error should get generated.

it seems like Dbh module is deprectated and will be removed in 2.2. so i'm not sure if that fix is relevant?

[tomtomsen]

maybe running codeception with the "-vvv" parameter could help you find the error.

[rogoit]

So maybe you can tell me how i can get all datasets with a where statement and not only one...that is my problem to do a simple request on the database

[tomtomsen]

I'm not sure what you are trying to accomplish. can you explain what you are trying to test?
which method are you using, and how?

@DavertMik: what are the default-parameter in https://github.com/Codeception/Codeception/blob/2.1/src/Codeception/Module/Dbh.php#L102 and https://github.com/Codeception/Codeception/blob/2.1/src/Codeception/Module/Dbh.php#L95 used for? doesn't they produce an invalid query? (like "select count(*) from [table] where") required because of the DbInterface
if criteria is empty, the where part should be removed

[rogoit]

Hi,

sure i do an Api Test. I want to read the parameters from an table. Than i will do the api call with this params in a loop and check the response.

Thx

[raistlin]

Can you post your test here?

[rogoit]

I throw it away but when i use grapFromDatabase i will not get all datasets...like where status = 1...

[raistlin]

Thanks @rogoit for reporting, even if it's deprecated, bug fixes are relevant.
Thanks @tomtomsen for research.