Error: LOAD DATA INFILE failed

[LotsOfQ]

I got this error from one of my app.

Code: [Select]

Error: LOAD DATA INFILE failed
When I used htaccess for the verison of php then no error. But when I used web features for the version of php then this error.

[MRatWork]

Inform here your .htaccess content.

[LotsOfQ]

Code: [Select]

<FilesMatch \.php$>
#SetHandler x-httpd-php
#SetHandler x-httpd-php52
#SetHandler x-httpd-php53
#SetHandler x-httpd-php54
#SetHandler x-httpd-php55
SetHandler x-httpd-php56
#SetHandler x-httpd-php70
#SetHandler x-httpd-php71
</FilesMatch>
If I use this in htaccess then it work fine. If I use the 'Web Features' for the php version then it show error.

NOTE: I noticed this. When using htaccess as above then it uses this /opt/php56m/custom/php.ini and when using 'Web Features' then it uses this /opt/php56m/custom/php-fpm.ini. Not sure if the configuration are different.

[MRatWork]

Select php from .htaccess mean using in php-cgi mode. From 'web features' mean in php-fpm mode (need select 'php-fpm' in php-type).

[LotsOfQ]

PHP Type: php_fpm_event (I have always been using this)

I've been using htaccess to select php but as learned that 'Advanced PHP Configure' doesn't work. I now using 'Web Features' to select php so 'Advanced PHP Configure' work. But now by using this method I now get this error from my app. How do I fix it?

Code: [Select]

Error: LOAD DATA INFILE failed

[MRatWork]

What's phpXYm used?.

[LotsOfQ]

php56m

[LotsOfQ]

+

[MRatWork]

To enable multiple select for 'php selected', you click 'Multiple PHP Enable (for 'php-fpm')' in 'webserver configure'.

[LotsOfQ]

I am not sure if we are still on the same topic here. I have Multiple PHP selected it's work fine. That's the issue. I not sure if that's what you meant.

What I am trying to fixed is this error I got from my app.

Code: [Select]

Error: LOAD DATA INFILE failed
This error happened when I use php70, php56, etc php-fpm_event (/custom/php-fpm.ini) but what using php70, php56, etc from .htaccess php-cgi mode (/custom/php.ini) no error.

So when I used this htaccess there is no error.

Code: [Select]

<FilesMatch \.php$>
#SetHandler x-httpd-php
#SetHandler x-httpd-php52
#SetHandler x-httpd-php53
#SetHandler x-httpd-php54
#SetHandler x-httpd-php55
SetHandler x-httpd-php56
#SetHandler x-httpd-php70
#SetHandler x-httpd-php71
</FilesMatch>From what you are telling me this is using php-cgi mode. This doesn't get that [Error: LOAD DATA INFILE failed]

From the 'Web Features > PHP Seleted' I selected a PHP say php56m or php70m it doesn't matter and I do have 'Multiple PHP Enable' checked in 'Webserver Configure'. This use 'php-fpm' and it got the [Error: LOAD DATA INFILE failed].

So I guess php-cgi mode no error and php-fpm mode error. How to fix php-fpm so no error?

[MRatWork]

Where you found 'Error: LOAD DATA INFILE failed'?.

[LotsOfQ]

One of the apps I use (Piwik) show this error.

[MRatWork]

Maybe as the same as issue with https://forum.piwik.org/t/load-data-infile/8765/8

[LotsOfQ]

Too much... I am so confused. I guess I will stick with the htaccess using php-cgi mode for now.

Code: [Select]

<FilesMatch \.php$>
#SetHandler x-httpd-php
#SetHandler x-httpd-php52
#SetHandler x-httpd-php53
#SetHandler x-httpd-php54
#SetHandler x-httpd-php55
#SetHandler x-httpd-php56
#SetHandler x-httpd-php70
SetHandler x-httpd-php71
</FilesMatch>Well, this is working and I don't have to mess with other stuff. Down side is not able to use the 'Web Features' to select php to use php-fpm_event. And also not able to use the 'Advanced PHP Configure > Disable Functions' I will have to edit '/custom/php.ini' instead.

Thank you for your help.

[MRatWork]

Did you try using php56m or php70m instead php71m?.