missing mysql connection - XDebug Issue????
Hello guys.
I'm very frustrated with phpstorm 2016.3.1. Since I started to use it, I have noticed that in debugging, sometimes when connecting to a database inside a method in a class (which invokes another method from another class in the process) returns me a false connection when in reality it shouldn't! every new connection is handled in a class that returns an object with a connection. It works perfect on first level methods, but when the abstraction level of my program goes 2 or 3 other methods that requires more DB connections to retrieve pieces of info, it returns FALSE, or in rowcount -1!!!!
So I had to throw away the towel, and rely on my previous IDE: Nusphere PHPED. what was my surprise that it debugs properly the database connection and it returns me the data I needed for debug.
I also have recorded the issue in my creative session on twitch for your information:
https://www.twitch.tv/streamoverlaypro/v/106997359
watch from 1:19:27 to 1:24:58
Thanks. I expect an answer as soon as possible
Please sign in to leave a comment.
forgot to mention my server settings
Server : Ubuntu Server 14.04.5 LTS 64 Bits
php Version : 5.5.9-1ubuntu4.20
Zend Engine : 2.5.0
Xdebug: 2.4.1
Project is edited and connected over the network through a mapped disk, which it should not affect the debug session.
xdebug.ini configuration:
[xdebug]
zend_extension=/usr/lib/php5/20121212/xdebug.so
xdebug.default_enable=1
xdebug.idekey=PHPSTORM
xdebug.remote_enable=1
xdebug.remote_port=9000
xdebug.remote_connect_back=1
xdebug.remote_host=192.168.1.221
I understand that the issue is not reproducible stably, but still.
Please enable Xdebug remote log and PhpStorm extended debug logging.Reproduce the issue after that and collect both Xdebug and IDE logs, and upload them here (as an archive with a unique name, if possible).
It may be too much to ask, but a screencast of what you were doing could also help (to match your actions with the log events).
Thank you!
Hi Eugene. The error is complete reproducible all the times I run that part of the code. If needed, I will record that again.
Also I will enable the remote log and extended debug logging and IDE log and I will send that to you guys. I expect some sort of solution, since in first place Why I have to rely in TWO IDEs for my project??? I hope you guys do not let me down on this.
Erick.
If you are going to perform the exact same actions as in the screencast, a new one is not needed, thanks!
Let's see what is happening in the logs.
Hi Eugene
here the filename of the logs: tbogard-phpdebugger-minus1-mysqlrowcount.rar
btw I'm recording my creative session, and I reproduced the error consistently, so this is bad :/
For now, I will have to use Nusphere until this error is solved.
Thanks.
Eugene. I didn't hear about this in 3 days. What is happening? thanks
I am sorry for keeping you on that, unfortunately, I have to ask a developer for help, and she will only be available on Monday. Sorry again.
Please disable listening for incoming connections in PhpStorm, then add calls similar to those you've run through Debugger Console to the code after the breakpoint and dump the data they return (to mock what the debugger is doing) - is the connection to the DB successful then?
If it's not, please check the same with Xdebug disabled in php.ini. Any difference?
Also, please attach output from Help | Settings Summary | Web Debug.