14-12: Support answer:

thank you for pointing me to this bug. We'll fix it in the next update.

To make your pages working add following code to the "After application initialized" event on the Events tab:

------------------

$bSubqueriesSupported=true;

Great and quick work Support!! Thank you.
13-12: Added ftp-user/password to the support-ticket for debugging purpose.
I have an application with a master-detail-detail which gives a php error when run on a MySQL4.1 database. (at my providers server)

On my own server, I use MySQL 3.2. With exactly the same database(s), the application runs fine.
I've already posted a ticket on support and uploaded the application.

The error occurs when executing the folowing URL (in the demo-environment)

http://demo.asprunner.net/webmaster_cs_opleidingen_nl/WBT/WIA_dossier_view.php?editid1=24
In the demo-environment it's working fine. At my provider I get the following message (excuse for the dutch language):

>>>

php een fout is opgetreden
Technische informatie

Fouttype 2

Fout beschrijving Invalid argument supplied for foreach()

URL wbt.sensioit.nl/WIA_dossier_view.php?editid1=24

Fout bestand /home/vhosts/sensioit.nl/subdomains/wbt/httpdocs/include/commonfunctions.php

Fout regel 209

SQL query SELECT ID, datumAanvraag, datumBeschikking, datumStartUitkering, datumEinde, Werkgever_ID, Werknemer_ID, MateVanAO, resterendeVerdiencapaciteit, datumEersteZiektedag, oorzaakAO, Uitkomst, datumHerbeoordeling, uitkomstHerbeoordeling, Regres, kansOpHerstel, dagloonVoorZiekte, WIA_dossier_ID FROM Beschikking where WIA_dossier_ID=24 ORDER BY 1 ASC
More info
Call stack

File: line Function Arguments

0. include/commonfunctions.php:209 getdetailkeysbymastertable N/A

1. include/commonfunctions.php:209 getdetailkeysbymastertable 1. Beschikking;

2. Bezwaar;
   

   2. classes/listpage.php:2380 listpage_dpinline->countdetailsrecsnosubq 1. 0;
   

   
   
3. Array ( [ID] => 9 [datumAanvraag] => [datumBeschikking] => [datumStartUitkering] => [datumEinde] => [Werkgever_ID] => [Werknemer_ID] => [MateVanAO] => [reste...;
   
4. Array ( [0] => 9 ) ;
   

   3. classes/listpage.php:2315 listpage_dpinline->proccessdetailgridinfo 1. Array ( [edit_link] => 1 [inlineedit_link] => 1 [view_link] => 1 [copy_link] => 1 ) ;
   

   
   
5. Array ( [ID] => 9 [datumAanvraag] => [datumBeschikking] => [datumStartUitkering] => [datumEinde] => [Werkgever_ID] => [Werknemer_ID] => [MateVanAO] => [reste...;
   

   4. classes/listpage.php:1864 listpage_dpinline->fillgriddata N/A
   

   5. classes/listpage_dpinline.php:295 listpage_dpinline->prepareforbuildpage N/A
   

   6. WIA_dossier_view.php:297 Global scope N/A
   

   <<<
   What could cause this problem?
   
   What database is used in the demo-environment?
   
   Could it be a database or PHP error? (both environments PHP5)
   Any solutions or directions to look for would be greatly appreciated.
   
   (I'm on a deadline for 31th of december :-( )
   Thank you,
   
   Mark Nikkels