We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 23849
    • 223 Posts
    thefutureforward Reply #1, 17 years ago
    Hi All,

    I recently moved all of my modx files (using evo 1.0) for a site into a new folder. Everything is working fine, but when I try to save a document I’m suddenly getting this error:

    « MODx Parse Error »
    MODx encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - Got error 28 from storage engine »
          SQL: SELECT DISTINCT tv.*, IF(tvc.value!='',tvc.value,tv.default_text) as value FROM `bfs_modx`.`modx_site_tmplvars` AS tv INNER JOIN `bfs_modx`.`modx_site_tmplvar_templates` AS tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `bfs_modx`.`modx_site_tmplvar_contentvalues` AS tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = '5' LEFT JOIN `bfs_modx`.`modx_site_tmplvar_access` tva ON tva.tmplvarid=tv.id WHERE tvtpl.templateid = '6' AND (1='1' OR ISNULL(tva.documentgroup)) ORDER BY tv.rank;
     
    Parser timing
      MySQL: 	0.0007 s	(1 Requests)
      PHP: 	1255005176.3780 s	 
      Total: 	1255005176.3787 s
    


    I have no idea why this would be.. anyone ever seen this problem?
      Nick Hoag
      Creative Partner
      The FutureForward

      http://thefutureforward.com
      • 23849
      • 223 Posts
      thefutureforward Reply #2, 17 years ago
      Ugh... Now I’m getting this issue when trying to access the homepage (all sub-pages are fine....):

      « MODx Parse Error »
      MODx encountered the following error while attempting to parse the requested resource:
      « Execution of a query to the database failed - Got error 28 from storage engine »
            SQL: SELECT stv.name,stc.tmplvarid,stc.contentid,stv.type,stv.display,stv.display_params,stc.value FROM `bfs_modx`.`modx_site_tmplvar_contentvalues` stc LEFT JOIN `bfs_modx`.`modx_site_tmplvars` stv ON stv.id=stc.tmplvarid WHERE stv.name='blog_day' AND stc.contentid IN (5,7) ORDER BY stc.contentid ASC;
            [Copy SQL to ClipBoard]
       
      Parser timing
        MySQL: 	0.0033 s	(7 Requests)
        PHP: 	0.0358 s	 
        Total: 	0.0390 s
      
        Nick Hoag
        Creative Partner
        The FutureForward

        http://thefutureforward.com
        • 10487 MODX Staff
        • 1,535 Posts
        Garry Nutting Reply #3, 17 years ago
        From what I’ve found out by doing a bit of googling - this error is related to MySQL running out of disk space on the server to store it’s DB files. I suggest you contact your host and ask them to investigate.
          Garry Nutting
          Senior Developer
          MODX, LLC

          Email: [email protected]
          Twitter: @garryn
          Web: modx.com
          • 23849
          • 223 Posts
          thefutureforward Reply #4, 17 years ago
          Hi Gary,

          Thanks for the tip and you are definitely right. Contacting our host now, thanks for the info!
            Nick Hoag
            Creative Partner
            The FutureForward

            http://thefutureforward.com