1. 

   ziuras, Member

   Help, after daily debian update, i got an warning:
   Warning: Invalid argument supplied for foreach() in /var/www/html/lib/db_utils.php on line 707
   and empty report.

   system: Debian stretch, php 7.0.30-0+deb9u1, apache 2.4.25-3-deb9u5
   database ms sql 2008 r8 on windows
2. 

   ziuras, Member

   mydbr: myDBR 5.1.1 (build 3664)
3. 

   myDBR Team, Key Master

   Sounds like a problem with sqlsrv-driver.

   Where do you get the error? On specific report / all reports / somewhere else. Can you check if there is something in the web server error log.

   --
   myDBR Team
4. 

   ziuras, Member

   sory it not after update.
   this warning apear in one report only in some dataset.
   i wil try myself to debug this problem.
5. 

   ziuras, Member

   Error in apache log

   [Mon Aug 27 15:23:47.659157 2018] [:error] [pid 7544] [client 10.18.156.220:54041] PHP Warning: Invalid argument supplied for foreach() in /var/www/html/lib/db_utils.php on line 707, referer: https://report.kmv.local/report.php?r=184&u1=2018.08.01&u2=2018.09.24&m=40&h=6bf2bb48932612c4f94320f4295315d8179aee57
6. 

   myDBR Team, Key Master

   The problem is that the call to SQLSRV-driver's sqlsrv_field_metadata-function fails.

   You can try to isolate which result set causes the call to fail. You can also open a support ticket with SQL export of the report so we can take a closer look at it.

   --
   myDBR Team
7. 

   ziuras, Member

   i wil write code example in support@mydbr.com ok?
8. 

   myDBR Team, Key Master

   Yes, please do.

   --
   myDBR Team
9. 

   ziuras, Member

   Problem solved in myDBR 5.1.1 (build 3665) version.
   Thank.

Reply

You must log in to post.