I have recently updated my php version to 4.3.2 from 4.2.2 I have only done this so I can run Zend Studio.
Since doing this I cannot use the LOCAL INFILE feature of mysql I am getting the error:
'The used command is not allowed in this version my mysql'
I have traced this to the php4apache.dll file that comes with php 4.3.2 and have discovered that 4.2.2 used the mysql client API 3.23.39 (which works great!) and 4.3.2 uses mysql client API 3.23.49 (which sucks).
I have read every thread under the sun about the security issues concerning LOCAL INFILE and have edited my.ini (mysql config file) till I am blue in the face, but no joy.
The only thing that resolves this problem is to revert back to the
php4apache.dll that comes with php 4.2.2
I now cannot use Zend Studio!
Can anyone suggest how I might resolve this problem or suggest how I can find which mysql client API php 4.3.4 uses maybe.
Thanks in advance
Ryan