目前,我正在一个SilverStripe项目上,一切似乎运行顺利。
但是后来事情变了..今天早晨,我尝试登录,并收到一条消息,指出发生了错误。
在开发模式下运行时,出现以下错误消息:
[用户错误]无法运行查询:SELECT“ SiteTree_Live”。“ ClassName”,
“ SiteTree_Live”。“已创建”,“ SiteTree_Live”。“最后编辑”,
“ SiteTree_Live”。“ URLSegment”,“ SiteTree_Live”。“标题”,
“ SiteTree_Live”。“ MenuTitle”,“ SiteTree_Live”。“内容”,
“ SiteTree_Live”。“ MetaTitle”,“ SiteTree_Live”。“ MetaDescription”,
“” SiteTree_Live“。” MetaKeywords“,” SiteTree_Live“。” ExtraMeta“,
“ SiteTree_Live”。“ ShowInMenus”,“ SiteTree_Live”。“ ShowInSearch”,
“ SiteTree_Live”。“ HomepageForDomain”,
“ SiteTree_Live”。“ ProvideComments”,“ SiteTree_Live”。“排序”,
“” SiteTree_Live“。” HasBrokenFile“,” SiteTree_Live“。” HasBrokenLink“,
“ SiteTree_Live”。“状态”,“ SiteTree_Live”。“ ReportClass”,
“ SiteTree_Live”。“ CanViewType”,“ SiteTree_Live”。“ CanEditType”,
“ SiteTree_Live”。“待办事项”,“ SiteTree_Live”。“版本”,
“ SiteTree_Live”。“ ParentID”,
阅读完整的错误消息:http://pastebin.com/TrjrEzUn
... WHERE ("SiteTree_Live"."ClassName" IN ('Page','BlogEntry','BlogTree','DienstHolder','DienstPage','FaqHolder','FaqPage','FrontPage','MemberPage','TeamPage','ErrorPage','RedirectorPage','VirtualPage','UserDefinedForm','BlogHolder')) AND (ParentID = ) ORDER BY "Sort" 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 ') ORDER BY "Sort"' at line 1
GET /Security/login?BackURL=%2Fadmin
Line 525 in /home/admin/domains/stargroup.nl/public_html/sapphire/core/model/MySQLDatabase.php
我检查了有关空类名的mysql,找到了一些空类名却得到了正确的类名。
任何人都有关于如何克服此错误并使登录重新恢复工作的建议?
提前thnx!
最佳答案
发布的查询中的问题是参数之一缺少值-就在最后:
AND (ParentID = ) ORDER BY "Sort"
在不知道silverstripe的情况下,我想您的一篇文章/帖子以某种方式缺少ID或ParentID。
关于php - Silverstripe/admin/突然停止工作,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/9699331/