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

    I have my client with modx migrate into new our hosting server. on our old server is working fine and also on local server.
    The site have a lot of TV on 1 page, about around 400.

    After press Save, there are some TV (bottom) that cannot be saved into database, no error message. But on the upper TV, data can be saved properly..

    I tried to change the setting on apache Max Connection and mysql Maxconnection but still didn’t work.

    Any Suggestion?

    Thanks
    Ricky
      Bali Web Design - www.babonmultimedia.com
      "When my brain got bottleneck of code, get into the garden , drink cup a coffee and enjoy Sun shining and warm weather in tropical island"
      • 25663 MODX Staff
      • 12,272 Posts
      It could be a MySQL timeout or PHP memory issue. That’s a TON of TVs ... why so many? It sounds like you might want to rethink the approach there.
        Ryan Thrash, MODX Co-Founder
        Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
        • 2742
        • 13 Posts
        Quote from: rthrash at Jan 27, 2010, 07:30 AM

        It could be a MySQL timeout or PHP memory issue. That’s a TON of TVs ... why so many? It sounds like you might want to rethink the approach there.

        Yes, this is learning a language website, there are alot of questions and quiz. But if it is timeout or memory out, is there any way to see those report?

        Thanks
        Ricky
          Bali Web Design - www.babonmultimedia.com
          "When my brain got bottleneck of code, get into the garden , drink cup a coffee and enjoy Sun shining and warm weather in tropical island"
          • 25663 MODX Staff
          • 12,272 Posts
          You would best be served by a custom database for the quizzes, using MODx pages as a view into those questions.
            Ryan Thrash, MODX Co-Founder
            Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
            • 2742
            • 13 Posts
            This site is running for 2 years with no problem, I dont have any plan to modified it yet.

            I still guess that there’s server’s setting that need to changed, but so far i have difficulty because there’s no pop up error message when saved.

            I have root access and can change the settings. thx Ryan
              Bali Web Design - www.babonmultimedia.com
              "When my brain got bottleneck of code, get into the garden , drink cup a coffee and enjoy Sun shining and warm weather in tropical island"
              • 25663 MODX Staff
              • 12,272 Posts
              You’ve likely reached the point where the cache is so large that it just times out trying to create it or something like that.
                Ryan Thrash, MODX Co-Founder
                Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
                • 2742
                • 13 Posts
                Yes, I think that could be the problem maker. But I try to clone into our local server, it works like a charm.
                  Bali Web Design - www.babonmultimedia.com
                  "When my brain got bottleneck of code, get into the garden , drink cup a coffee and enjoy Sun shining and warm weather in tropical island"
                  • 25663 MODX Staff
                  • 12,272 Posts
                  What’s the server specs and PHP configuration?
                    Ryan Thrash, MODX Co-Founder
                    Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
                    • 2742
                    • 13 Posts
                    Server Specs:

                    Intel QuadCore , 2 Gb , 250Gb , Redhat Linux 64bit
                    PHP Config can be seen here http://babonmultimedia.com/info.php

                    Local Server is only atom with 2Gb memory
                      Bali Web Design - www.babonmultimedia.com
                      "When my brain got bottleneck of code, get into the garden , drink cup a coffee and enjoy Sun shining and warm weather in tropical island"
                      • 2742
                      • 13 Posts
                      Problem Fixed grin

                      After rebuilding PHP & Apache module, the site is working like a charm again..

                      Got critical limitation modx on 400 Template Variables in a document ?? You must be joking. Modx still can do more smiley
                        Bali Web Design - www.babonmultimedia.com
                        "When my brain got bottleneck of code, get into the garden , drink cup a coffee and enjoy Sun shining and warm weather in tropical island"