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

    I just installed the dbedit module (from https://github.com/ncrossland/ModX-Evo-dbEdit) into a MODX Evo site, now version Evo 1.1, PHP 5.6

    The module reports:
    mysql_query(): No such file or directory in (home path here)/assets/modules/dbedit/module.list.tables.inc.php on line 108
    Warning: mysql_query(): A link to the server could not be established in (home path here)/assets/modules/dbedit/module.list.tables.inc.php on line 108


    In line 108 we have
    include_once $base_path."manager/includes/controls/datagrid.class.php";


    I can't add and connect to a table, after choosing the table the "Loading Configuration"-icon keeps turning ... no configuration ist loaded.

    Any ideas? Thanks for any hints!
    Guenter
      • 13226
      • 953 Posts
      I am taking a wild guess at this as I am not a programmer

      Looking at GitHub, the code hasn't realy been touched since 2011, which might be the reason you are having problems.

      The code may not be compatible with PHP5.6 and Evo has seen some major changes since 2011

      My suggestion: create a post in the Evo issues section on GitHub, that way the Evo dev team will see the issue long before seeing it in the Forum
      • Have you renamed/moved your manager folder? Then you have to change this path

        $base_path."manager/includes/controls/datagrid.class.php"


        to something valid on base of MGR_DIR
          • 36649
          • 77 Posts
          Quote from: Jako at Mar 15, 2016, 08:35 AM
          Have you renamed/moved your manager folder? Then you have to change this path

          $base_path."manager/includes/controls/datagrid.class.php"


          to something valid on base of MGR_DIR

          Hello, thanks for your reply, but the manager folder has not been changed.
          I'll give a downgrade to PHP 5.5. or 5.4 a chance.
          • The line 108 causing the error looks different than you mentioned above:
            https://github.com/ncrossland/ModX-Evo-dbEdit/blob/master/module.list.tables.inc.php#L108

            You will have to rewrite the whole package from mysql to mysqli to use this in PHP 5.6. Or rewrite it to DBAPI.
              • 36649
              • 77 Posts
              Quote from: iusemodx at Mar 14, 2016, 10:39 PM
              I am taking a wild guess at this as I am not a programmer

              Looking at GitHub, the code hasn't realy been touched since 2011, which might be the reason you are having problems.

              The code may not be compatible with PHP5.6 and Evo has seen some major changes since 2011

              My suggestion: create a post in the Evo issues section on GitHub, that way the Evo dev team will see the issue long before seeing it in the Forum

              Thanks for the link, I posted the issue there.
                • 36649
                • 77 Posts
                Hello,

                I solved this problem by changing mysqli to mysql database type in config.inc.php

                Now when saving a table edit I get the error "Es wurde keine Ressourcen ID in der Abfrage angegeben!" - no ressource id given.

                I'm using PHP 5.4 and MODX Evo 1.1. - seems to have to do with PHP version and variables handling?

                Thx for hints - I also posted the issue here https://github.com/ncrossland/ModX-Evo-dbEdit
                  • 36649
                  • 77 Posts
                  Hello,

                  in dbEdit in MODX Evo 1.1. with PHP 5.4 or 5.5, 5.6 I'm now getting an error when editing data.

                  "Es wurde keine Ressourcen ID in der Abfrage angegeben!" (no ressource id given with the request)

                  The entry is not beeing saved. Are any other changes required to get dbEdit to save edits?

                  Thx!
                    • 9995
                    • 1,613 Posts
                    hgw7m, did you got it working again?

                    I use it too and also have a problem, it does save in the database but the module isn't correct:
                    See attachment.

                    Can't click on the link..
                      Evolution user, I like the back-end speed and simplicity smiley
                      • 36649
                      • 77 Posts
                      Quote from: fourroses666 at Jun 23, 2016, 10:13 AM
                      hgw7m, did you got it working again?

                      I use it too and also have a problem, it does save in the database but the module isn't correct:
                      See attachment.

                      Can't click on the link..

                      Sorry I just saw your post now. UnfortunatelyI did not get it to work until now...