installation problem

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[davidm]

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...

[pjm]

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?

[davidm]

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

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

[xwisdom]

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:

Code:

// 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.

[French Frog]

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 

Any help to be expected ?

[davidm]

@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.

[rthrash]

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.

[davidm]

@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.

[French Frog]

@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...

[davidm]

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...

[French Frog]

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 !

[davidm]

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 !

[French Frog]

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...

[rthrash]

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

[French Frog]

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.