Parameter must be an array and Internet Server 500 error












2















I'm currently working with a database and I keep running into a similar problem. I've looked at many of the similar forums and it's answers but wasn't able to fix it.



Ubuntu 18.04
Apache/2.4.29 (Ubuntu)
PHP version: 7.2.15-0ubuntu0.18.04.1
PMA: 4.6.6deb5



Every time I click on a database Table, i always get the following error.



count(): Parameter must be an array or an object that implements Countable


I did configure the file (looked at many forums) but when i changed the following lines, this is what i get.



error in processing request error code 500 error text internal server error


I changed the following lines:



(count($analyzed_sql_results['select_expr'] == 1)


TO



((count($analyzed_sql_results['select_expr']) == 1)


Please help me out. Thank you.










share|improve this question







New contributor




Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    2















    I'm currently working with a database and I keep running into a similar problem. I've looked at many of the similar forums and it's answers but wasn't able to fix it.



    Ubuntu 18.04
    Apache/2.4.29 (Ubuntu)
    PHP version: 7.2.15-0ubuntu0.18.04.1
    PMA: 4.6.6deb5



    Every time I click on a database Table, i always get the following error.



    count(): Parameter must be an array or an object that implements Countable


    I did configure the file (looked at many forums) but when i changed the following lines, this is what i get.



    error in processing request error code 500 error text internal server error


    I changed the following lines:



    (count($analyzed_sql_results['select_expr'] == 1)


    TO



    ((count($analyzed_sql_results['select_expr']) == 1)


    Please help me out. Thank you.










    share|improve this question







    New contributor




    Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      2












      2








      2


      1






      I'm currently working with a database and I keep running into a similar problem. I've looked at many of the similar forums and it's answers but wasn't able to fix it.



      Ubuntu 18.04
      Apache/2.4.29 (Ubuntu)
      PHP version: 7.2.15-0ubuntu0.18.04.1
      PMA: 4.6.6deb5



      Every time I click on a database Table, i always get the following error.



      count(): Parameter must be an array or an object that implements Countable


      I did configure the file (looked at many forums) but when i changed the following lines, this is what i get.



      error in processing request error code 500 error text internal server error


      I changed the following lines:



      (count($analyzed_sql_results['select_expr'] == 1)


      TO



      ((count($analyzed_sql_results['select_expr']) == 1)


      Please help me out. Thank you.










      share|improve this question







      New contributor




      Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I'm currently working with a database and I keep running into a similar problem. I've looked at many of the similar forums and it's answers but wasn't able to fix it.



      Ubuntu 18.04
      Apache/2.4.29 (Ubuntu)
      PHP version: 7.2.15-0ubuntu0.18.04.1
      PMA: 4.6.6deb5



      Every time I click on a database Table, i always get the following error.



      count(): Parameter must be an array or an object that implements Countable


      I did configure the file (looked at many forums) but when i changed the following lines, this is what i get.



      error in processing request error code 500 error text internal server error


      I changed the following lines:



      (count($analyzed_sql_results['select_expr'] == 1)


      TO



      ((count($analyzed_sql_results['select_expr']) == 1)


      Please help me out. Thank you.







      server apache2 phpmyadmin






      share|improve this question







      New contributor




      Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 5 hours ago









      Jainam PatelJainam Patel

      111




      111




      New contributor




      Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Jainam Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          1 Answer
          1






          active

          oldest

          votes


















          0














          I've experienced the same problem, with PhpMyAdmin 4.6.6 on Ubuntu 18.04, and found the solution, provided by Jacky Nguyen, on Stack Overflow:




          Edit file /usr/share/phpmyadmin/libraries/sql.lib.php:



          sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php


          Replace: count($analyzed_sql_results['select_expr'] == 1)



          With: (count($analyzed_sql_results['select_expr']) == 1)



          Restart the server apache:



          sudo service apache2 restart






          share|improve this answer
























          • That was my default line. It keeps giving me the same error.

            – Jainam Patel
            5 hours ago











          • If i do configure it, then it would give me the "internal 500 error".

            – Jainam Patel
            5 hours ago











          • @JainamPatel: Strange, I just checked my PMA instance and it works well with this fix. The only idea I have is to try to flush your browser's cache.

            – pa4080
            5 hours ago






          • 1





            I have cleared cache and cookies. Still nothing.

            – Jainam Patel
            5 hours ago











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "89"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Jainam Patel is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1125396%2fparameter-must-be-an-array-and-internet-server-500-error%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          I've experienced the same problem, with PhpMyAdmin 4.6.6 on Ubuntu 18.04, and found the solution, provided by Jacky Nguyen, on Stack Overflow:




          Edit file /usr/share/phpmyadmin/libraries/sql.lib.php:



          sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php


          Replace: count($analyzed_sql_results['select_expr'] == 1)



          With: (count($analyzed_sql_results['select_expr']) == 1)



          Restart the server apache:



          sudo service apache2 restart






          share|improve this answer
























          • That was my default line. It keeps giving me the same error.

            – Jainam Patel
            5 hours ago











          • If i do configure it, then it would give me the "internal 500 error".

            – Jainam Patel
            5 hours ago











          • @JainamPatel: Strange, I just checked my PMA instance and it works well with this fix. The only idea I have is to try to flush your browser's cache.

            – pa4080
            5 hours ago






          • 1





            I have cleared cache and cookies. Still nothing.

            – Jainam Patel
            5 hours ago
















          0














          I've experienced the same problem, with PhpMyAdmin 4.6.6 on Ubuntu 18.04, and found the solution, provided by Jacky Nguyen, on Stack Overflow:




          Edit file /usr/share/phpmyadmin/libraries/sql.lib.php:



          sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php


          Replace: count($analyzed_sql_results['select_expr'] == 1)



          With: (count($analyzed_sql_results['select_expr']) == 1)



          Restart the server apache:



          sudo service apache2 restart






          share|improve this answer
























          • That was my default line. It keeps giving me the same error.

            – Jainam Patel
            5 hours ago











          • If i do configure it, then it would give me the "internal 500 error".

            – Jainam Patel
            5 hours ago











          • @JainamPatel: Strange, I just checked my PMA instance and it works well with this fix. The only idea I have is to try to flush your browser's cache.

            – pa4080
            5 hours ago






          • 1





            I have cleared cache and cookies. Still nothing.

            – Jainam Patel
            5 hours ago














          0












          0








          0







          I've experienced the same problem, with PhpMyAdmin 4.6.6 on Ubuntu 18.04, and found the solution, provided by Jacky Nguyen, on Stack Overflow:




          Edit file /usr/share/phpmyadmin/libraries/sql.lib.php:



          sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php


          Replace: count($analyzed_sql_results['select_expr'] == 1)



          With: (count($analyzed_sql_results['select_expr']) == 1)



          Restart the server apache:



          sudo service apache2 restart






          share|improve this answer













          I've experienced the same problem, with PhpMyAdmin 4.6.6 on Ubuntu 18.04, and found the solution, provided by Jacky Nguyen, on Stack Overflow:




          Edit file /usr/share/phpmyadmin/libraries/sql.lib.php:



          sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php


          Replace: count($analyzed_sql_results['select_expr'] == 1)



          With: (count($analyzed_sql_results['select_expr']) == 1)



          Restart the server apache:



          sudo service apache2 restart







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 5 hours ago









          pa4080pa4080

          14.5k52670




          14.5k52670













          • That was my default line. It keeps giving me the same error.

            – Jainam Patel
            5 hours ago











          • If i do configure it, then it would give me the "internal 500 error".

            – Jainam Patel
            5 hours ago











          • @JainamPatel: Strange, I just checked my PMA instance and it works well with this fix. The only idea I have is to try to flush your browser's cache.

            – pa4080
            5 hours ago






          • 1





            I have cleared cache and cookies. Still nothing.

            – Jainam Patel
            5 hours ago



















          • That was my default line. It keeps giving me the same error.

            – Jainam Patel
            5 hours ago











          • If i do configure it, then it would give me the "internal 500 error".

            – Jainam Patel
            5 hours ago











          • @JainamPatel: Strange, I just checked my PMA instance and it works well with this fix. The only idea I have is to try to flush your browser's cache.

            – pa4080
            5 hours ago






          • 1





            I have cleared cache and cookies. Still nothing.

            – Jainam Patel
            5 hours ago

















          That was my default line. It keeps giving me the same error.

          – Jainam Patel
          5 hours ago





          That was my default line. It keeps giving me the same error.

          – Jainam Patel
          5 hours ago













          If i do configure it, then it would give me the "internal 500 error".

          – Jainam Patel
          5 hours ago





          If i do configure it, then it would give me the "internal 500 error".

          – Jainam Patel
          5 hours ago













          @JainamPatel: Strange, I just checked my PMA instance and it works well with this fix. The only idea I have is to try to flush your browser's cache.

          – pa4080
          5 hours ago





          @JainamPatel: Strange, I just checked my PMA instance and it works well with this fix. The only idea I have is to try to flush your browser's cache.

          – pa4080
          5 hours ago




          1




          1





          I have cleared cache and cookies. Still nothing.

          – Jainam Patel
          5 hours ago





          I have cleared cache and cookies. Still nothing.

          – Jainam Patel
          5 hours ago










          Jainam Patel is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Jainam Patel is a new contributor. Be nice, and check out our Code of Conduct.













          Jainam Patel is a new contributor. Be nice, and check out our Code of Conduct.












          Jainam Patel is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Ask Ubuntu!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1125396%2fparameter-must-be-an-array-and-internet-server-500-error%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          香粉寮

          GameSpot