Skip to main content
2 votes
Accepted

MySQL "LOAD DATA LOCAL INFILE" with database connection object in Joomla 4

Since 4.0, Joomla database layer always uses prepared statements. And as the error states, the query you're trying to run is not supported when used in prepared statements. This is true at least for ...
Sharky's user avatar
  • 11.5k
1 vote
Accepted

Join one to many with helper table JDatabase

So got it now: In my select for the players: ... $query->select('t.title as team_title, t.id as team_id') ->join( 'LEFT', $db->quoteName('#...
Marco's user avatar
  • 685
1 vote
Accepted

Using MySQL "LOAD DATA LOCAL INFILE" with the Joomla database connection object

Updated to include the more detailed example based on the 1st comment. I have been able to get the follow statement to work, or at least not fail, in a simple Joomla 3 Model; $db = $this->getDbo(); ...
Irata's user avatar
  • 3,972

Only top scored, non community-wiki answers of a minimum length are eligible