Roles->children is giving blank array

[irshadalif]

I had used phprbac on one site few years ago and it was working fine in my local machine and also on live server. Now this year the client change the server having latest php and apache versions but the phprbac is not working properly, it is giving blank array.

For testing i downloaded the code in my local machine with php version 5+ and it is working fine in my local machine while it is not working on server having php version 7+ and latest upgrades.

I have been pulling my hair and not getting any solution to this issue, can you please kindly help me to get out of this issue.

How a class can stop working on higher versions?

Thanks in advance

Irshad

[abiusx]

PHP 7 has many backward incompatible changes, those might be the cause. It might also be the new MySQL which is more towards standard SQL. Enable errors on the target environment, or check them from Apache logs.

…

On Nov 2, 2017, at 7:30 AM, irshadalif ***@***.***> wrote: I had used phprbac on one site few years ago and it was working fine in my local machine and also on live server. Now this year the client change the server having latest php and apache versions but the phprbac is not working properly, it is giving blank array. For testing i downloaded the code in my local machine with php version 5+ and it is working fine in my local machine while it is not working on server having php version 7+ and latest upgrades. I have been pulling my hair and not getting any solution to this issue, can you please kindly help me to get out of this issue. How a class can stop working on higher versions? Thanks in advance Irshad — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#99>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABVjW9fXQgd3plhK6m6v-LYNvv-JMeJqks5syafAgaJpZM4QPioa>.

[irshadalif]

Thanks a lot for the reply
After checking i found that all functions are working fine except the children finding execute command as below

$success=$stmt->execute ();

The above line is returning false if it is executed for finding children for "roles"/"permissions" entity. And this is core function of pdo_mysql. So, how can i predict the problem.

Can you suggest any solution to this issue ? If yes then it would be great.

Thanks

[abiusx]

Unfortunately I can’t suggest a solution without knowing the exact problem! Take a look inside that function, try to run the same SQL query direcly in the database, see what happens?

…

On Nov 2, 2017, at 10:01 AM, irshadalif ***@***.***> wrote: Thanks a lot for the reply After checking i found that all functions are working fine except the children finding execute command as below $success=$stmt->execute (); The above line is returning false if it is executed for finding children for "roles"/"permissions" entity. And this is core function of pdo_mysql. So, how can i predict the problem. Can you suggest any solution to this issue ? If yes then it would be great. Thanks — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#99 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABVjW1oMZqv9nd4iBzXihIyraem3cUR9ks5sycsngaJpZM4QPioa>.

[irshadalif]

I had already checked the query in database and it is working fine, also the same code is working fine in php 5+ version only in php 7+ version the code for fetching children returns null array, after digging we found that the execute command is returning null.

[abiusx]

Can you debug that function to figure out exactly why?

…

On Nov 2, 2017, at 10:06 AM, irshadalif ***@***.***> wrote: I had already checked the query in database and it is working fine, also the same code is working fine in php 5+ version only in php 7+ version the code for fetching children returns null array, after digging we found that the execute command is returning null. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#99 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABVjW5NZx_FReJLeYOcnq4p4BKcHFH-Fks5sycyCgaJpZM4QPioa>.

[irshadalif]

The function "$stmt->execute ();" is the core function of pdo_mysql and it is returning null so we cant move ahead.

[abiusx]

execute on PDO should return false or true. I believe it is not the PDO function, but a function of the framework that calls PDO inside itself. Dig deeper please!

…

On Nov 2, 2017, at 10:11 AM, irshadalif ***@***.***> wrote: The function "$stmt->execute ();" is the core function of pdo_mysql and it is returning null so we cant move ahead. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#99 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABVjW2HfNp3_fAuDOTBCBurqW-Xi2tmSks5syc2igaJpZM4QPioa>.