Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions /

SS3.1 $sqlQuery->addInnerJoin Issue


Reply


2 Posts   427 Views

Avatar
SS_Learner

Community Member, 18 Posts

19 April 2013 at 3:09pm

Hi Friends

I am making a query using sqlQuery in Silverstripe 3.1 . Now when i try to add an inner join using
$sqlQuery->addInnerJoin('Member', 'testTable.OwnerID = Member.ID');

the raw query i am getting with this is something like
INNER JOIN "Member" ON testTable.OwnerID = Member.ID,
which when executed in mysql gives syntax error,as there should be no double quotes in the table name,when i remove the quotes,it works.
But how can i resolve this in my code?

Thanks for any kind of help.

Avatar
simon_w

Forum Moderator, 474 Posts

19 April 2013 at 4:40pm

The generated SQL is correct. SilverStripe runs MySQL in ANSI mode, which means that database, table and column names should be enclosed in double quotes (“) rather than the normal back ticks (`). If you are running the query in a mysql shell, or through something like PHPMyAdmin, you need to run

SET sql_mode=‘ANSI’;

first.