Hello. I really need the subsites module to run on my website. I am currently using ss version 2.3.7 on windows. When I run db/build to install the module, I got these errors...

[User Error] Couldn't run query: SELECT `SubsiteDomain`.*, `SubsiteDomain`.ID, if(`SubsiteDomain`.ClassName,`SubsiteDomain`.ClassName,'SubsiteDomain') AS RecordClassName FROM `SubsiteDomain` INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('localhost:81' LIKE replace("SubsiteDomain"."Domain",'*','%')) GROUP BY `SubsiteDomain`.ID ORDER BY "IsPrimary" DESC You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND
GET /cms/silverstripe/db/build?flush=1

Line 401 in C:\wamp\www\cms\silverstripe\sapphire\core\model\MySQLDatabase.php

Anyone got any solutions for this matter? Thank you in advance.

Just change double quotes (") to backtricks (`) in sql queries in subsites module code or turn on ANSI SQL mode
mixing (`) and (") in SQL queries produce these error

I believe if you are trying subsites trunk you will need to be running 2.4 rather that 2.3 for full support.

Thanks for the help guys. Anyway, I installed the branch version and it working fine now.

I'm having exactly the same problem... can you tell me what steps you took to get it working? Did you change any code - if so, in which files?

Thanks

Just added this Successful installation of Subsites module on SS 2.3.0 (2.3.7 seems feasible) -- might help.