We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 49846
    • 22 Posts
    Hello,

    I have just newly installed articles. And have created test articles. The problem I have is that the articles are not showing in the articles' container page. The container loads but shows not listings. The individual articles are published and loads. I am struggling to see why the articles are not showing up in the articles' container. Could it be that [[+articles]] is empty i.e. some code that renders the rows are not working?

    In my error log I have the following related to articles.

    [2015-08-06 15:22:16] (ERROR @ /assets/components/articles/connector.php) Encountered empty IN condition with key contentid
    [2015-08-06 15:22:16] (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 ') )' at line 1
    )

    I am not sure what it means and how to fix. I hope someone can help. Thanks
      • 42562
      • 1,145 Posts
      Does reinstalling Articles fix it?

      Install Bacher extra, to look up those hidden sub articles, see why they are not showing up.
        TinymceWrapper: Complete back/frontend content solution.
        Harden your MODX site by passwording your three main folders: core, manager, connectors and renaming your assets (thank me later!)
        5 ways to sniff / hack your own sites; even with renamed/hidden folders, burst them all up, to see how secure you are not.
        • 36818
        • 119 Posts
        Had the same issue several times. I had to delete the content of articles directly in the DB. Save it and they showed up again in the articles listing.
        IIRC in the table site_content -> field: content. Filter for class_key "Article".

        I never found out what kind of character combination caused the problem.

        Found an issue on github: https://github.com/modxcms/Articles/issues/32