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

installation problem

    • 6726
    • 7,075 Posts
    davidm Reply #11, 20 years, 11 months ago
    Don’t know them, but I could drop by the forum and ask...

    You probably have seen the post where I reported something strange : "...EasyPHP’s setting for collation database and collation server, it returns latin1_swedish_ci insted of latin1_general_ci... I can’t make sense of this but maybe you will ?..."

    http://modxcms.com/forums/index.php/topic,941.msg8529.html#msg8529

      .: COO - Commerce Guys - Community Driven Innovation :.

      MODx est l'outil id
      • 25663 MODX Staff
      • 12,272 Posts
      Ryan Thrash Reply #12, 20 years, 11 months ago
      Yes I saw that post. I think actually that’s the default MySQL install collation. Not sure if that’s the cause or not though.
        Ryan Thrash, MODX Co-Founder
        Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
        • 22303 MODX Staff
        • 10,725 Posts
        opengeek Reply #13, 20 years, 11 months ago
        latin1_swedish_ci is the default collation sequence for MySQL. I’ve tried every collation sequence, changing my language settings, and more and just cannot reproduce this anomaly with EasyPHP 1.8, no matter what I do with the database, create it first, let the install create it, etc.

        By chance, do any of the database names for users experiencing this problem have dashes or other non-alphanumeric characters in them?
          Jason Coward
          Chief Architect @ MODX
          http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek
          • 6726
          • 7,075 Posts
          davidm Reply #14, 20 years, 11 months ago
          Personally, no. I used "modx" as database name. No dash or special chars in it.

          This might be dumb but could this be related to the windows locale ? It would explain why you can’t reproduce the error...

          Don’t loose sleep over this, I’ll drop by the forums@easyphp and ask questions, look for similar problems when I have 5 minutes, and report here.

            .: COO - Commerce Guys - Community Driven Innovation :.

            MODx est l'outil id
            • 23527
            • 3 Posts
            pjm Reply #15, 20 years, 11 months ago
            Quote from: OpenGeek at Nov 07, 2005, 03:09 PM

            By chance, do any of the database names for users experiencing this problem have dashes or other non-alphanumeric characters in them?

            Nope. Just ’modx’ or other name without any fancy character. By the way, Etomite latest version installs just fine with Easyphp grin
              • 6726
              • 7,075 Posts
              davidm Reply #16, 20 years, 11 months ago
              New stuff is coming up...

              I have a french user reporting the same problem on install but this time it’s not windows and not EasyPHP but Ubuntu Linux with the following configurations (with an "s", because he tested with two different computers). He doesn’t speak english, thus I am reporting on his behalf :

              At home
              OS : Ubuntu Hoary
              PHP : 4.3.10-10ubuntu4.1
              MySQL :
              Cient API : 3.23.56
              Apache : 2.0.53
              MySQL : 4.1.10a-Debian_2-log

              Laptop
              OS : Ubuntu Breezy
              PHP : 5.05-2ubuntu1
              MySQL : 4.1.12-debian_1ubuntu3-log
              Client API : 4.0.24
              Apache : 2.0.54

              He solved the problem by removing all the ALTER declaration in the sql file (he was doing a fresh install).

              What do you make of this ?
              I didn’t recheck but someone suggested a locales problem, and it’s another french user this time not running windows, and not running EasyPHP...


                .: COO - Commerce Guys - Community Driven Innovation :.

                MODx est l'outil id
                • 23527
                • 3 Posts
                pjm Reply #17, 20 years, 11 months ago
                Thanks for the tip. It works perfectly. In the setup.sql it is mentioned that those ALTER are for backward compatibilty with early versions. Anyway it looks that the ADD COLUMN doesn’t work because they were previously created. Or am I wrong?
                  • 6726
                  • 7,075 Posts
                  davidm Reply #18, 20 years, 11 months ago
                  Well, I have so many things cooking right now I didn’t take the time to take a real look at this, it seems you did and you’re on to something. Maybe you’ll make the day for Jason and Ryan on this annoying problem grin

                  Let’s give proper credits : The tip is courtesy of thor . He doesn’t speak english thus I was only the messenger here.

                    .: COO - Commerce Guys - Community Driven Innovation :.

                    MODx est l'outil id
                    • 32963
                    • 1,732 Posts
                    xwisdom Reply #19, 20 years, 11 months ago
                    Question: Is the MySQL version returning french error messages?

                    Here’s how the setup works. It’s the sqlparser sees the word duplicate inside the error message then it will ignore those messages:

                    sqlParser.class.php line 93:
                    // Ignore duplicate and drop errors - Raymond 
if ($this->ignoreDuplicateErrors){
	if (eregi('^duplicate key', mysql_error()) || (eregi('^alter', $sql_do) && eregi('^duplicate', mysql_error()))) continue;
	if (eregi('^can\'t drop', mysql_error()) || (eregi('^alter', $sql_do) && eregi('^can\'t drop', mysql_error()))) continue;
}
// End Ignore duplicate


                    You might want to try and debug it from there.
                      xWisdom
                      www.xwisdomhtml.com
                      The fear of the Lord is the beginning of wisdom:
                      MODx Co-Founder - Create and do more with less.
                      • 10153
                      • 138 Posts
                      French Frog Reply #20, 20 years, 10 months ago
                      modx install on celeonet.fr does not work, same issue than the one stated here.

                      Système d’exploitation : Linux 2.4.20-28.9 
                      Version d’Apache : 2.0.54 (Unix)
                      Version de MySQL : 4.1.14
                      Version de PHP : 4.4.0 / 5.0.4

                      I cannot fully chose my database name, it has to be in this format :adminname_nameofthebase ...

                      I uploaded the revised setup.sql and it did not change a thing. I have a few CMS running sites (including etomite rc3) and they all installed without any problem.

                      celeonet.fr IS the prefered webhost in France for php based sites  sad

                      Any help to be expected ?


                        Be not deceived: evil communications corrupt good manners.
                        I Corinthians (ch. XV, v. 33)