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   376 Views

Avatar
SS_Learner

19 April 2013 at 3:09pm Community Member, 18 Posts

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

19 April 2013 at 4:40pm Forum Moderator, 474 Posts

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.