MySQL 4.1.10a and Noah's Classifieds

[Paul B]

I have two sites with host who has just upgrade to MySQL 4.1.10a.

Unfortunately both sites are running Noah's Classified. Now existing advertisers cannot log in (says "The given username password pair is invalid.") And new advertisers are told their user name has to be 32 characters.

Noah's don't answer emails and I can't see any mention of this in G. Any ideas? Otherwise all works. Any ideas?

[Paul B]

OK now I know a bit more Noah's uses the PASSWORD()function more info here:
http://dev.mysql.com/doc/mysql/en/password-hashing.html

But how to fix it...

[Paul B]

And finally - the answer:

in > gorum/dbproperty change this line near the end from:

$data = mysql_query("select password('$s')");
to


$data = mysql_query("select old_password('$s')");

and all is well with the world...