Jump to:

10928 Posts in 2612 Topics by 1809 members

All other Modules

SilverStripe Forums » All other Modules » Subsites Module fail to install

Discuss all other Modules here.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 1410 Views
  • ikhwanb
    Avatar
    Community Member
    2 Posts

    Subsites Module fail to install Link to this post

    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.

  • dvp
    Avatar
    Community Member
    4 Posts

    Re: Subsites Module fail to install Link to this post

    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

  • Willr
    Avatar
    Forum Moderator
    5482 Posts

    Re: Subsites Module fail to install Link to this post

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

  • ikhwanb
    Avatar
    Community Member
    2 Posts

    Re: Subsites Module fail to install Link to this post

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

  • timcole
    Avatar
    Community Member
    32 Posts

    Re: Subsites Module fail to install Link to this post

    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

  • christian.b
    Avatar
    Community Member
    8 Posts
    1410 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.