UPDATE won't execute in IE8 while phpadmin is open in another tab

peter_schneider

I used to devellop using xampp & IE8 (one tab running my application in and another tab running phpmydamin in).
Using this setup i ran into trouble running scripts with MYSQL UPDATE functions in it. the UPDATES were either not executed or just some of them executed, in lucky cases sometimes all were executed. on every new reload the UPDATE behaved differently.
yesterday i ran a script with two UPDATEs in it. on the first reload it would only execute the one update, on the second update the other one was executed and so on, in lucky cases both were executed ...
My soulution for now is to use another browser (for instance Chrome) instead of IE. then everything works just fine. the only way to make it work in IE is to close the second tab with phpadmin running in it!
Has anybody ever heard of that problem or has an idea what the reason for this might be???

peter_schneider

I just checked the IE setup again and it works fine - for the moment. After a few hours of work though, there is a >50% chance the problem occurs ... As long as it can be solved by using another browser it's not such a big problem for me - but there remains a bad feeling in the back of my head, not knowing why the problem occurs and whether it could also occur when the finished version runs 24/7 on a server without me noticing it ... ;(

dagon

Guessing wildly: could be db\table locking, could be a user conflict.

peter_schneider

thats an interesting point.

Roger_Ramjet

Could also be that your phpmyadmin session expired when you don't run anything in that tab for whatever the timeout is set for. That timeout then closes all connections from that browser. Just an idea.

peter_schneider

thanks David,
i dont know what my phpmyadmin session time out is set to. but executed in phpmyadmin all queries work perfectly fine. it's the queries executed via IE ... they work/don't work/work/don't work and so on ... as long as phpmyadmin is open in another tab ... sometimes ... Arrg. 😉