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

Answered Database not showing all entries?

    • 40541
    • 85 Posts
    mflammia Reply #1, 11 years, 5 months ago
    Hi,

    Apologies if there is a logical answer here for a newbie...

    I have an issue with some TV's that I would like to look into the MODX db, to see what is stored where but getting an odd result.

    I'll start with some templates that I have configured, these are:

    id 1 - BaseTemplate
    id 2 - Index
    id 3 - Contact
    id4 - Allpages
    id8 - test_template
    id9 - css

    Now if I go into the DB and do

    SELECT * 
FROM  `modx_site_templates` 
LIMIT 0 , 30


    It only shows entries for ID's 1,2,3,4 but not 8 & 9.

    If I do 

    SELECT * 
FROM  `modx_site_templates` 
WHERE  `id` =1
LIMIT 0 , 30


    The entry for ID 1 shows, but if I do it for ID's 8 & 9 no entries is returned

    Same goes for TV's but it is even more exaggerated. I have TV's programmed from 1 to 27 but the DB entries for modx_site_tmplvars shows only the first 6!

    Thanks in advance.

    This question has been answered by sottwell. See the first response.

    [ed. note: mflammia last edited this post 11 years, 5 months ago.]
      • 38209
      • 26 Posts
      scherpontwikkeling Reply #2, 11 years, 5 months ago
      You should repair your table through either MySQL command line or phpMyAdmin.

      If you SELECT * you should get all rows, no matter what. Try to remove the limit (just for testing purposes)
      • sottwell Reply #3, 11 years, 5 months ago
        Do the templates and TVs show up in the element tree?
          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
          • 40541
          • 85 Posts
          mflammia Reply #4, 11 years, 5 months ago
          Yes, sorry, probably should have mentioned that, they all show up and work fine.

          I'm on Revo 2.2-4pl.

          Cheers
          • discuss.answer
            sottwell Reply #5, 11 years, 5 months ago
            There are a number of possibilities. They are in the database and for some reason your query is not accessing the correct database (I've done that a time or two), or they are not in the database but are in the cache. Try manually deleting all folders and files in the core/cache/ directory and see if they are still in the element tree.
              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
              • 40541
              • 85 Posts
              mflammia Reply #6, 11 years, 5 months ago
              Well thats the strangest thing - I know I was looking at the right database because the entries I could see where only related to the one I wonted to look at.

              I've just gone to a PC, rather than my Mac, not that it probably matters and I can now see them all.

              Perhaps it was just a cache thing?

              Thanks for posting anyway and sorry if I have wasted anytime.

              Cheers.