I have been using MODX for about 18 months now and have made 1000s of changes to our website.
I made about 10 changes yesterday, but I logged in today to add an image to a page and this is what occurred;
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Can’t open file: ’modx_site_content.MYI’ (errno: 145) »
SQL: SELECT DISTINCT sc.id, sc.menutitle, sc.pagetitle, sc.introtext, sc.menuindex, sc.published, sc.hidemenu, sc.parent, sc.isfolder, sc.description, sc.alias, sc.longtitle, sc.type,if(sc.type=’reference’,sc.content,’’) as content, sc.template, sc.link_attributes FROM `modx`.`modx_site_content` sc LEFT JOIN `modx`.`modx_document_groups` dg ON dg.document = sc.id WHERE sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu=0 AND sc.id IN (1,935,934,933,948,27,28,29,966,967,32,911,912,937,913,2,5,13,19,24,944,914,950,26,34,14,18,483,479,491,499,516,510,524,532,716,3,4,33,922,10,939,943,12,940,916,6,11,915,8,7,919,920,931,918,917,941,9,965,970,971,972,973,974,975,976,977,978,979,35,20,22,21,23,938,963,945,927,930,932,925,923,928,964,946,926,929,951,952,25,953,954,955,956) GROUP BY sc.id ORDER BY sc.menuindex ASC ;
[Copy SQL to ClipBoard]
Parser timing
MySQL: 0.0047 s (0 Requests)
PHP: 0.1358 s
Total:
I have boldened the error message above. I logged into my ftp server and cannot find the file modx_site_content.MYI, what has happened and how do I fix this problem? I read 2 other posts with the same error message but they seemed to vary a little from mine.
I don’t know much about my hardware and software on the webserver I will find out now. I am running modX 0.9.6, windows vista, mozzilla firefox 3.0.11
Can someone help me to resolve this issue?
Thankyou.
☆ A M B ☆
