We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 24676
    • 60 Posts
    Hi

    Hoping someone can help here.

    For some reason articles are not displaying in the manager at all although they are working on the front end. Works fine on my localhost but on my producttion server I am having this issue.

    I just checked the error logs and I am getting the following error which I suspect is the issue.

    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table class for class: quipComment
    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table name for class: quipComment
    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) No foreign key definition for parentClass: quipComment using relation alias: Author
    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) No foreign key definition for parentClass: quipComment using relation alias: Resource
    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table class for class: quipComment
    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table name for class: quipComment
    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table class for class: quipComment
    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table name for class: quipComment
    [2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Error 42000 executing statement: 
    Array
    (
        [0] => 42000
        [1] => 1064
        [2] => 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 'AS `ct` WHERE  ( `ct`.`thread` = `quipComment`.`thread` AND  ( `ct`.`deleted` = ' at line 1
    )
    
    [2015-12-04 16:06:45] (ERROR @ /assets/components/articles/connector.php) Could not get table class for class: quipComment
    [2015-12-04 16:06:45] (ERROR @ /assets/components/articles/connector.php) Could not get table name for class: quipComment
    [2015-12-04 16:06:45] (ERROR @ /assets/components/articles/connector.php) No foreign key definition for parentClass: quipComment using relation alias: Thread
    [2015-12-04 16:06:45] (ERROR @ /assets/components/articles/connector.php) Error 42000 executing statement: 
    Array
    (
        [0] => 42000
        [1] => 1064
        [2] => 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 'AS `quipComment` JOIN `cc_quip_threads` `Thread` ON  WHERE Thread.resource = Art' at line 1
    )
    
    


    I am running revolution 2.4.2 and the latest version of articles. Completely stuck on this one - all help gratefully received.
    • just had this issue.

      my components were in the wrong place. but that might not be your problem. look under manager/assets and see if the components directory is there. it should have all the component goodness, mine was under plain old assets.

      if not then go repair tables, clear caches, uninstall and reinstall and run set up in upgrade mode.

      but I'd look in the console on the empty articles screen and see what it says there first.
        ________

        Anne
        Toad-in-Chief
        Red Toad Media - Web Design, Louisville KY
        Hear me tweet: http://www.twitter.com/redtoadmedia
        "Bring on the imperialistic condiments." - Rory Gilmore
        • 24676
        • 60 Posts
        Thanks for your response. I ended up creating a fresh install of modx and moving everything over which wasn't ideal but fixed it. I had expected clearing cache and running setup again would have fixed it but not this time. Something more sinister must have been going on!
        • I really think that path thing might be a Thing but then again it might be just me not taking a break after 12 hours. tongue glad you're better anyhow!! so sorry you had to do that. I want to see the finished site too!!
            ________

            Anne
            Toad-in-Chief
            Red Toad Media - Web Design, Louisville KY
            Hear me tweet: http://www.twitter.com/redtoadmedia
            "Bring on the imperialistic condiments." - Rory Gilmore
            • 24676
            • 60 Posts
            Once it is live I will post it!
            • The components folder belongs in assets/components. The manager/assets/ is only for the Manager's extjs and other Javascript library files. There may be some Custom Manager Page extras that use the manager/assets directories, but I can't think of any right now.
                Studying MODX in the desert - http://sottwell.com
                Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                Join the Slack Community - http://modx.org
              • By the way, Articles is not the friendliest way to do blogs and so forth. I'd recommend taking a look at the Flatso theme/blogging solution. Very nice. https://github.com/modxcms/flatso/blob/master/README.md

                As far as moving a development site to a production server, I personally use Vapor to package my dev site and install it on a new installation on the production server. A better choice would be to have Teleport on your development server (or localhost) and use it to package your development site.

                Here's a nice video on packaging and moving an entire site using Teleport. (Teleport isn't alpha any more, but is being actively developed) https://vimeo.com/87146819
                  Studying MODX in the desert - http://sottwell.com
                  Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                  Join the Slack Community - http://modx.org
                  • 3749
                  • 24,544 Posts
                  What happens when you right-click on the articles container and select "Manage Articles"?

                  Clear the error log first and check it right away to see if that threw any errors.
                    Did I help you? Buy me a beer
                    Get my Book: MODX:The Official Guide
                    MODX info for everyone: http://bobsguides.com/modx.html
                    My MODX Extras
                    Bob's Guides is now hosted at A2 MODX Hosting
                  • Thanks Susan, I'll take a look at Flatso. I know the biggest thing for me was being able to import the couple hundred posts I have. That was a snap with Articles.
                      ________

                      Anne
                      Toad-in-Chief
                      Red Toad Media - Web Design, Louisville KY
                      Hear me tweet: http://www.twitter.com/redtoadmedia
                      "Bring on the imperialistic condiments." - Rory Gilmore