23486 Posts in 18995 Topics by 2878 members
|Go to End|
11 March 2010 at 8:01pm
I am trying to test out subsites in 2.3.6 and received a bad syntax error. i installed a new instance of SS on wamp, then installed todays trunk of the subsites module and got this error:
[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' 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
Line 401 in C:\wamp\www\subsite\sapphire\core\model\MySQLDatabase.php
documentation here says it requires genericdataadmin module, but thats been deprecated and sort of replaced with modeladmin.
how can i get subsites to install? while i'm asking this question, i'm curious if i can share pages between Top Level Domains with this module?
|Go to Top|