Hello,
when setting up a many to many relationship between two tables through a relationships.ini file I get the same error all the time whichever syntax I use among the three possible ways of doing it described in Xataface's documentation.
[i](this message refers to the example app I set up so as to understand better what was going on : same error)[/i]
[code][pear_error: message="Parse error: Unknown action :s on line 1 select * from Course, ProgramCourses where Course.CourseID=ProgramCourses.CourseID and ProgramCourses.ProgramID='$ProgramID' ^ found: "s"" code=0 mode=return level=notice prefix="" info=""]
Warning: Invalid argument supplied for foreach() in /space/www/gl-ouv/1/6/1612031805215032/web/ouvaton.org/shakennotstirred.ouvaton.org/html/alpha/xataface/Dataface/Relationship.php on line 351
Warning: Cannot use a scalar value as an array in /space/www/gl-ouv/1/6/1612031805215032/web/ouvaton.org/shakennotstirred.ouvaton.org/html/alpha/xataface/Dataface/Relationship.php on line 558
Etc.[/code]
I scanned the whole forum for similar issues. Apparently it might be a problem either with the encoding of the files themselves when I FTP them to the shared host I am using, or it might be something like the PHP and MySQL settings on the host ?
I tried several flavours of quotes and even backticks around '$ProgramID' as it seems to me that the relationship PHP script isn't decoding this variable properly.
Thank you for any help
OR