We're updating the issue view to help you get more done. 

Searches fail because temp files fail without adding 'LOCAL' to the SQL statement

Description

app/lib/core/BaseFindEngine.php

This is an existing problem that I resolved about 6 months ago, but only now got around to reporting it.

My server was failing to create/retrieve temp files until I modified the SQL statement to add the 'LOCAL' statement ( app/lib/core/BaseFindEngine.php line 95) from :
$this->opo_db->query("LOAD DATA INFILE '{$this->ops_tmp_file_path}' INTO TABLE {$this->ops_tmp_table_name} (row_id)");

to:
$this->opo_db->query("LOAD DATA LOCAL INFILE '{$this->ops_tmp_file_path}' INTO TABLE {$this->ops_tmp_table_name} (row_id)");

I do not know really what/why....but it works.

Environment

shared server hosted by ipower.com (php 5.3.13 mySQL 5.0.51)

Assignee

User known

Reporter

bruce klotz

Labels

None

Components

Affects versions

Priority

Major
Configure