installation problem

@French Frog : Nice to see you’re still around Of course help is to be expected. Ryan has come up with a bug fix, and Raymon here might just have found the solution to the problem. The fact that MODx doesn’t install on Celeonet is not good, even if OVH IS as good and way more spread in the french shared hosting world.

You can be sure we’ll do anything to fix this one. Proof is it’s at the top of the list on the bugs page :
http://modxcms.com/bugs/

We will end up nailing it, no doubt...

Back on the issue :
@Raymond : Error messages are indeed in french but it doesn’t explain why some french config work OK (local or hosting) while other do not. Furthermore, this problem might occur with other languages if the language or MySQL error messages is the source of this, which would not be good. Edit : I checked this thread and indeed lonely seems to be italian (or at least that’s what I get from his error message) this confirms it’s a plausible explanation.

I can try to edit the lines to replace them by french error messages, at least it would allow us to know it’s here we should focus. I’ll do that and report.

This is truly a maddening situation! I wish we could point to exactly what was going on!

I can’t reproduce this anywhere on this end, which makes it even more difficult. If I had access to one of the servers that was failing, I’d be able to figure it out I think... *sigh*

This is a 0.9.1 showstopper.

@Ryan : Good news, Raymond was right I replaced the error strings by the french ones in sqlParser.class.php, and managed to install MODx on EasyPHP 1.8 locally. I quickly checked, it works perfectly.

I’ll post the sqlparser modification for french and have people test it on other configuration (FrenchFrog, could you please try again on celeonet with the file I’ll post ? Thanks).

It’s not my area thus I can’t say how to do it, but the way the sql parser is built you need this bit of code apparently, or can you find an alternate way ? If not we will have to build an array of strings in multiple languages and define a variable for this error message string (bear with me, I am just starting to learn PHP since yesterday )

Another thing : ON DUPLICATE KEY has apparently been introduced since MySQL 4.1, I don’t know if this can be of importance, but I came accross that.

Quote from: davidm at Nov 25, 2005, 08:21 AM

@French Frog : Nice to see you’re still around Of course help is to be expected. Ryan has come up with a bug fix, and Raymon here might just have found the solution to the problem. The fact that MODx doesn’t install on Celeonet is not good, even if OVH IS as good and way more spread in the french shared hosting world.

As I said I will keep in touch
BTW, the fact that http://www.ibf-french.com, http://www.simplemachines-fr.org and http://www.mambofrance.org (and now http://www.joomlafrance.org/) are hosted at celeonet is enough to qualify celeonet as the best php host in France. I thought you had been involved in Mambo France, you should know about that
In a few words, I can say that if an install script does not work at Celeonet, that’s bad.

Thanks I stay tuned for the fix...

Didn’t say they weren’t among the best, I use them for my clients ! Plus I was referring to shared hosting : and there according to JDN/Witbe it’s OVH leading the way right now... But I am saying the widest user base is from Amen and OVH.

To answer your questions, no I haven’t been involved in Mambo France... never liked Mambo. Too rigid. I have dropped by xoops france at some point but never been involved there...

Back on the issue : you can download the french fix here

This is a transitionnal solution, pending complete resolution of this issue. If you can test it @Celeonet, thanks in advance...

Quote from: davidm at Nov 25, 2005, 09:27 AM

Didn’t say they weren’t among the best, I use them for my clients ! Plus I was referring to shared hosting : and there according to JDN/Witbe it’s OVH leading the way right now... But I am saying the widest user base is from Amen and OVH.

What I said in my first post was precisely : "celeonet.fr IS the prefered webhost in France for php based sites", I still have no idea why you jumped on me with your OVH "banging the chest" thing. It is probably part of your slightly irritating way to talk to people  And BTW your JDN/Witbe ranking is talking about availability time, and has nothing to do with PHP hosting...

To answer your questions, no I haven’t been involved in Mambo France... never liked Mambo. Too rigid. I have dropped by xoops france at some point but never been involved there...

You have been involved in so many things, it is easy to get lost, sorry about that 

Back on the issue : you can download the french fix here

This is a transitionnal solution, pending complete resolution of this issue. If you can test it @Celeonet, thanks in advance...

Thanks a lot for that part of your post and I will keep you posted on my test !

Quote from: French at Nov 25, 2005, 09:50 AM

What I said in my first post was precisely : "celeonet.fr IS the prefered webhost in France for php based sites", I still have no idea why you jumped on me with your OVH "banging the chest" thing.

Sorry it came out that way. I tend to think in "relative" terms, not absolutes... when I hear "best php host in france" it sound absolute and definite to me, and I admit I have a personnal tendency to overreact

It is probably part of your slightly irritating way to talk to people

You mean the part when I start "lecturing" Yeah, I can be that way...
Again, sorry it came out agressive. I’ll try to avoid being too much like that, you’re right.

And BTW your JDN/Witbe ranking is talking about availability time, and has nothing to do with PHP hosting...

Yeah I have pointed toward what I had in my bookmark not checking it was the right page...

Personnally, I use TextDrive which is not french... because they’re top notch and also I have bought a lifetime hosting for 10 domains there... and, yeah, also because they’re textpattern folks

You have been involved in so many things, it is easy to get lost, sorry about that

Well I have been here and there, but I have only been really involved in Textpattern. A little bit at e107france too. That’s where I truly contributed. The other stuff is testing, exchanging ideas...

Thanks a lot for that part of your post and I will keep you posted on my test !

Thank you !

and... it does not work  :’(

MODx setup couldn’t install/alter some tables inside the selected database.

The following errors had occurred during installation

Nom du champ ’cachepwd’ déjà utilisé during the execution of SQL statement ALTER TABLE `teddyinparis_web_users` ADD COLUMN `cachepwd` VARCHAR(100) NOT NULL COMMENT ’Store new unconfirmed password’ AFTER `password`.


etc.

Should I also use the modified setup.sql on the top of this modification ?

and I just tried with PHP5, same problem...

Please try the setup.sql also located in the bugtracker as well. Thanks!

Quote from: rthrash at Nov 25, 2005, 10:33 AM

Please try the setup.sql also located in the bugtracker as well. Thanks!

I used BOTH the new setup.sql and the "frog" version of sqlParser.class.php : I still have the same problem.
It simply does not work.