We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 28042 ☆ A M B ☆
    • 24,524 Posts
    The "client" that phpinfo is reporting is not the server, it is the application that accesses the server. Since your PHP didn’t change, then it’s still using the same client.

    Likewise the mysql client that your linux is using is not the version of the MySQL engine. Try "mysql -v" at your command line.

    Also, when you first open phpMyAdmin it will display the version of MySQL at the top of the screen.

    I get this:
    littlemac:/Applications/MAMP/Library/bin sottwell$ ./mysql -v
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 598 to server version: 5.0.19
    and can’t replicate the error.
      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
      • 7455
      • 2,204 Posts
      my phpadmin say’s:

      MySQL 4.1.15-standard running on localhost

      what does you phpinfo in the sysinfo say’s in modx?

      If you login you could grab a mysql backup and import it on your server to see if you get the same problems.

      I hope that this can be fixed.


      I tryed mysql -v but i get this error:
      ERROR 1045 (28000): Access denied for user ’root’@’localhost’ (using password: YES)

      that is strange case I have root acces
        follow me on twitter: @dimmy01
        • 28042 ☆ A M B ☆
        • 24,524 Posts
        My phpinfo reports the Client API version to be 4.1.12.

        Log in to your mysql command line, and enter this query:
        select version();


        I get

        littlemac:/Applications/MAMP/Library/bin sottwell$ ./mysql -u root -p
        Enter password:
        Welcome to the MySQL monitor. Commands end with ; or \g.
        Your MySQL connection id is 620 to server version: 5.0.19

        Type ’help;’ or ’\h’ for help. Type ’\c’ to clear the buffer.

        mysql> select version();
        +-----------+
        | version() |
        +-----------+
        | 5.0.19 |
        +-----------+
        1 row in set (0.00 sec)
          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
          • 7455
          • 2,204 Posts
          mm so how do I upgrade the Client API?

          do I need to upgrade php or apache for that?
            follow me on twitter: @dimmy01
            • 7455
            • 2,204 Posts
            Readhead needs capital V so it worked now using: mysql -V and this is the output I got:

            [email protected]:/root $ mysql -V
            mysql Ver 14.7 Distrib 4.1.15, for pc-linux-gnu (i686) using readline 4.3
            [email protected]:/root $
              follow me on twitter: @dimmy01
              • 28042 ☆ A M B ☆
              • 24,524 Posts
              So you are using MySQL version 4.1.15

              The client doesn’t have anything to do with your problem. It just gives you access to the MySQL engine.
                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
                • 7455
                • 2,204 Posts
                ok so I still have this problem with this mysql release.
                You do not have this problem with your version?
                or could it be somthing else?
                  follow me on twitter: @dimmy01
                  • 22303 MODX Staff
                  • 10,725 Posts
                  Quote from: Dimmy at Aug 26, 2006, 11:00 AM

                  mm so how do I upgrade the Client API?

                  do I need to upgrade php or apache for that?

                  For *nix systems, you’ll need to compile PHP with the latest version of the mysql extension, from my understanding. Windows systems can get the binaries from MySQL at http://dev.mysql.com/downloads/connector/php/.
                  We do not provide binary downloads for any other operating systems. On Unix and Mac OS X you can compile PHP and the PHP extensions yourself. This is described well in the PHP Manual for Unix and its variants and Mac OS X Server or Client.
                  Information available for Unix and it’s variants at http://www.php.net/manual/en/install.unix.php and for Mac OS X at http://www.php.net/manual/en/install.macosx.php.

                  But as sottwell proclaimed as well, I’m not convinced this has anything to do with the problem here. I think this is simply a matter of missing indexes on the tables. Now I’m thinking some index probably did not get created properly on the older version, and unless you created everything from scratch (i.e. new install) on the newer version of MySQL, updating isn’t going to change it. This may require some manual table structure intervention, because I use MySQL 4.1 all the time without this issue.
                    • 7455
                    • 2,204 Posts
                    mm strange so what can I do to change that? do I need to import the database again or do i need to change something in de database?

                    I had this problem on all my websites I made from the beginning (etomite) til now (modx 1.9.2)

                    I did not create a new modxsite with the new mysql yet to see if it is fixed

                    the error does not ocure on small sites with just 1 level is goes wrong in the 2nd and 3th level duplicating.

                    if it misses somthing and make tv shift places the first item that goes wrong has duplicayed tv’s (exely it gets tv’s from the next document aswhell) and the next document has the tv valeus of the 3th document and the 3th of the 4th and so on. so it does duplicate but it shifts places normaly only from lever 2 and below
                      follow me on twitter: @dimmy01
                      • 10487 MODX Staff
                      • 1,535 Posts
                      Garry Nutting Reply #20, 20 years ago
                      the error does not ocure on small sites with just 1 level is goes wrong in the 2nd and 3th level duplicating.
                      Okay, the fix for this is relatively simple and can be done on a MODx 0.9.1 install so I’ll post the fix here as well as in the SVN.

                      In duplicate_content.processor.php, look for these lines:
                      // duplicate the TVs and keywords for the document's children
                      			for($i=0;$i<$affected;$i++) {
                      				$newid +=$i;
                                                      duplicateTVs($myChildren[$i],$newid);
                      				duplicateKeywords($myChildren[$i],$newid);
                      				duplicateAccess($myChildren[$i],$newid);
                      


                      And, change to:
                      // duplicate the TVs and keywords for the document's children
                      			for($i=0;$i<$affected;$i++) {
                                                      duplicateTVs($myChildren[$i],$newid);
                      				duplicateKeywords($myChildren[$i],$newid);
                      				duplicateAccess($myChildren[$i],$newid);
                      				$newid +=$i;
                      

                      Let’s increment the ID in the right place, heh? lol

                      EDIT: Still working out a few of the other issues, I’ve also noticed the ’TVs duplicating twice’ thing as well so looking into that at the moment.

                      Hope that helps,
                      Garry
                        Garry Nutting
                        Senior Developer
                        MODX, LLC

                        Email: [email protected]
                        Twitter: @garryn
                        Web: modx.com