We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

MODx Parse Error at line 1

    • 19036
    • 119 Posts
    mehdi Reply #1, 17 years, 7 months ago
    Hello,

    Does anyone had the same parse error when trying to create a new document ? It’s happened after I created and moved several articles from some folders to others (archiving).

    « MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 '' at line 1 »
      SQL: SELECT fullname FROM `lordsofr`.`modx_user_attributes` WHERE `lordsofr`.`modx_user_attributes`.id =
      [Copy SQL to ClipBoard]
 
Parser timing
  MySQL: 	0,0596 s	(40 Requests)
  PHP: 	0,2107 s	 
  Total: 	0,2704 s


    I’m disappointed because I don’t know how to resolve the case (I already try to re-install modx, no way !)

    Does someone have a solution ?

    Thanks.
    Mehdi


      Scuse my english...I'm swiss
      • 25663 MODX Staff
      • 12,272 Posts
      Ryan Thrash Reply #2, 17 years, 7 months ago
      What version of MODx? What about your server environment (PHP/MySQL versions)? What modules and plugins are you running?
        Ryan Thrash, MODX Co-Founder
        Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
        • 19036
        • 119 Posts
        mehdi Reply #3, 17 years, 7 months ago
        Hello Ryan,

        I’m running version 0.9.6.  rev 4077 - MySQL 5.0.22

        And using all the base snippets such as ditto, reflect, ajaxsearch, etc

        The problem happend after I used a "home made" snippet for archiving
        See the code here: http://modxcms.com/forums/index.php/topic,31501.msg191064.html#msg191064

        But I already use it without any problem, and I tried to remove it, nothing change...I also deleted some old articles, maybe it’s that ?!

        All my old documents are still working and I can edit them, but create a new is impossible without a parse error.

        I’m just lost...

        Thanks for your help..
        Mehdi



          Scuse my english...I'm swiss
          • 25663 MODX Staff
          • 12,272 Posts
          Ryan Thrash Reply #4, 17 years, 7 months ago
          My first suggestion would be to upgrade to 0963. I’d also try repairing the DB table ... it could have crashed I suppose.
            Ryan Thrash, MODX Co-Founder
            Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
            • 19036
            • 119 Posts
            mehdi Reply #5, 17 years, 7 months ago
            Hi,

            I tried to repare and optimize, didn’t work...

            Now I have empty my database, and try to upload a backup from last week. And now this is what I get:

            /*!40000 ALTER TABLE `modx_manager_log` DISABLE KEYS */;


            Impossible to load the backup on Phpadmin.

            What means this message, please ?

            Thanks
            Mehdi
              Scuse my english...I'm swiss