New install problem
After completing a new install of Modx I get this when I try to visit the main page of the website.
? MODx Parse Error ?
MODx encountered the following error while attempting to parse the requested resource:
? Execution of a query to the database failed ?
? ? ? SQL: SELECT DISTINCT sc.id,sc.pagetitle,sc.description,sc.parent,sc.alias FROM `shinji`.modx_site_content sc LEFT JOIN `shinji`.modx_document_groups dg on dg.document = sc.id LEFT JOIN `shinji`.modx_documentgroup_names dgn ON dgn.id = dg.document_group WHERE sc.parent = ’0’ AND sc.published=1 AND sc.deleted=0 AND (1=’1’ OR NOT(dgn.private_webgroup<=>1)) ORDER BY sc.menuindex ASC;?
I have shell access so I executed the command directly onto the database and ended up with this error.
ERROR 1: Can’t create/write to file ’/var/tmp/#sql_373b_0.MYD’ (Errcode: 17)
Any suggestions?
BTW, /var/tmp is chmodded 0777 so it should of been writable.? I mean come on.
My website url:
https://kaosports.vn/
I am running version 2.0 RC3
The straight Etomite install works fine.
*edit*
I checked out the query some more and dropped the keyword DISTINCT. Now it works but since it is supposed to only give unique names I think this might have an adverse effect if I use it in the script. Can anyone give me a modified query for the various SELECT DISTINCT statements? I was reading that there is a way to make it faster and not use the DISTINCT keyword.
See more:
https://goo.gl/4vNRdM
https://goo.gl/4tyvjz
[ed. note: kaosports last edited this post 8 years, 4 months ago.]
