Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: Goba
Status: patch (code needs review)
Well, you can actually vote with your money, and go to a different
hosting provider. There are plenty already supporting PHP 4.3+ and PHP
5. Note that the latest stable PHP version in the 4.x family is already
4.4.0! 4.3.0 was released on 27th December 2002, so it is becoming three
years old software in no time.
Goba
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
------------------------------------------------------------------------
Sat, 10 Sep 2005 07:17:54 +0000 : beginner
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:22:23 +0000 : Prometheus6
Here's your test.
<?php
if (version_compare(phpversion(), '5', '<')) {
require_once('amazon.php4.inc');
} else {
require_once('amazon.php5.inc');
}
?>
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:52:41 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.patch (562 bytes)
Thanks Prometheus6.
here's a proper patch on includes/database.mysql.inc
tested on local (php 4.3.x) and remote (php 4.2.x).
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:56:09 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.2.patch (560 bytes)
Am I doing things the wrong way round?? (I am beginner, and new to this
diff thing!)
here's the negative of the previous one...
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:01:13 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.3.patch (560 bytes)
grrr....
Did I say I was a beginner?
I was diffing against the already modified file.
This patch should be the good one (either that or expect to have a
flood of support request when drupal 4.7 comes out!).
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:16:47 +0000 : Goba
Well, other parts of Drupal also expect PHP 4.3+ (the search indexing
code is one example if I remember well), so if you give the impression
at this point that it is fine to run with PHP 4.3-, then other things
will probably break. I am not certain though :)
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:30:28 +0000 : Prometheus6
"Thanks Prometheus6.
"
I decided to play patch bingo.
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:52:24 +0000 : beginner
Playing bingo is good! :-D
"Well, other parts of Drupal also expect PHP 4.3+ (the search indexing
code is one example if I remember well), so if you give the impression
at this point that it is fine to run with PHP 4.3-, then other things
will probably break.
"
Goba,
Precisely, that's why I said earlier to write a warning in
admin/settings about the sub-requirements php version used and let them
have a quick idea of what may not work. Currently, I am running
http://www.wechange.org/ on drupal cvs (two days ago) and php 4.2.3.
Drupal can still work, even if some features can be expected to be
broken. I haven't tried search indexing yet, but now I shall know that
I cannot use it until I manage to persuade my host to upgrade php
(unlikely in the short term!).
So, I'd rather use a slightly broken Drupal than no drupal at all! The
site admin just needs to be warned (so that they don't flood the forum
with support requests). Just let them know in admin/settings what is
likely to be broken.
OR, if the drupal core developpers are purists and only care about
self-hosting drupal users and ignore the mass of users who don't really
have a choice, they should at least put a proper warning when failing to
connect:
<ul>
<li>Are you sure you have the correct username and password?</li>
<li>Are you sure that you have typed the correct hostname?</li>
<li>Are you sure that the database server is running?</li>
<li>Are you sure the php version in use is >= 4.3.0? If not, either
upgrade php, or if you can't, piss off: Drupal is not for you.</li>
</ul>
(shall I create a patch for this one? Now I know how to do one!)
as I said earlier:
it's either that (my patch, or the piss-off message) or expect to have
a flood of support request when drupal 4.7 comes out!
Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: beginner
Status: patch (code needs review)
Playing bingo is good! :-D
"Well, other parts of Drupal also expect PHP 4.3+ (the search indexing
code is one example if I remember well), so if you give the impression
at this point that it is fine to run with PHP 4.3-, then other things
will probably break.
"
Goba,
Precisely, that's why I said earlier to write a warning in
admin/settings about the sub-requirements php version used and let them
have a quick idea of what may not work. Currently, I am running
http://www.wechange.org/ on drupal cvs (two days ago) and php 4.2.3.
Drupal can still work, even if some features can be expected to be
broken. I haven't tried search indexing yet, but now I shall know that
I cannot use it until I manage to persuade my host to upgrade php
(unlikely in the short term!).
So, I'd rather use a slightly broken Drupal than no drupal at all! The
site admin just needs to be warned (so that they don't flood the forum
with support requests). Just let them know in admin/settings what is
likely to be broken.
OR, if the drupal core developpers are purists and only care about
self-hosting drupal users and ignore the mass of users who don't really
have a choice, they should at least put a proper warning when failing to
connect:
<ul>
<li>Are you sure you have the correct username and password?</li>
<li>Are you sure that you have typed the correct hostname?</li>
<li>Are you sure that the database server is running?</li>
<li>Are you sure the php version in use is >= 4.3.0? If not, either
upgrade php, or if you can't, piss off: Drupal is not for you.</li>
</ul>
(shall I create a patch for this one? Now I know how to do one!)
as I said earlier:
it's either that (my patch, or the piss-off message) or expect to have
a flood of support request when drupal 4.7 comes out!
beginner
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
------------------------------------------------------------------------
Sat, 10 Sep 2005 07:17:54 +0000 : beginner
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:22:23 +0000 : Prometheus6
Here's your test.
<?php
if (version_compare(phpversion(), '5', '<')) {
require_once('amazon.php4.inc');
} else {
require_once('amazon.php5.inc');
}
?>
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:52:41 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.patch (562 bytes)
Thanks Prometheus6.
here's a proper patch on includes/database.mysql.inc
tested on local (php 4.3.x) and remote (php 4.2.x).
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:56:09 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.2.patch (560 bytes)
Am I doing things the wrong way round?? (I am beginner, and new to this
diff thing!)
here's the negative of the previous one...
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:01:13 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.3.patch (560 bytes)
grrr....
Did I say I was a beginner?
I was diffing against the already modified file.
This patch should be the good one (either that or expect to have a
flood of support request when drupal 4.7 comes out!).
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:16:47 +0000 : Goba
Well, other parts of Drupal also expect PHP 4.3+ (the search indexing
code is one example if I remember well), so if you give the impression
at this point that it is fine to run with PHP 4.3-, then other things
will probably break. I am not certain though :)
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:30:28 +0000 : Prometheus6
"Thanks Prometheus6.
"
I decided to play patch bingo.
Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: Prometheus6
Status: patch (code needs review)
"Thanks Prometheus6.
"
I decided to play patch bingo.
Prometheus6
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
------------------------------------------------------------------------
Sat, 10 Sep 2005 07:17:54 +0000 : beginner
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:22:23 +0000 : Prometheus6
Here's your test.
<?php
if (version_compare(phpversion(), '5', '<')) {
require_once('amazon.php4.inc');
} else {
require_once('amazon.php5.inc');
}
?>
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:52:41 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.patch (562 bytes)
Thanks Prometheus6.
here's a proper patch on includes/database.mysql.inc
tested on local (php 4.3.x) and remote (php 4.2.x).
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:56:09 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.2.patch (560 bytes)
Am I doing things the wrong way round?? (I am beginner, and new to this
diff thing!)
here's the negative of the previous one...
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:01:13 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.3.patch (560 bytes)
grrr....
Did I say I was a beginner?
I was diffing against the already modified file.
This patch should be the good one (either that or expect to have a
flood of support request when drupal 4.7 comes out!).
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:16:47 +0000 : Goba
Well, other parts of Drupal also expect PHP 4.3+ (the search indexing
code is one example if I remember well), so if you give the impression
at this point that it is fine to run with PHP 4.3-, then other things
will probably break. I am not certain though :)
Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: Goba
Status: patch (code needs review)
Well, other parts of Drupal also expect PHP 4.3+ (the search indexing
code is one example if I remember well), so if you give the impression
at this point that it is fine to run with PHP 4.3-, then other things
will probably break. I am not certain though :)
Goba
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
------------------------------------------------------------------------
Sat, 10 Sep 2005 07:17:54 +0000 : beginner
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:22:23 +0000 : Prometheus6
Here's your test.
<?php
if (version_compare(phpversion(), '5', '<')) {
require_once('amazon.php4.inc');
} else {
require_once('amazon.php5.inc');
}
?>
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:52:41 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.patch (562 bytes)
Thanks Prometheus6.
here's a proper patch on includes/database.mysql.inc
tested on local (php 4.3.x) and remote (php 4.2.x).
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:56:09 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.2.patch (560 bytes)
Am I doing things the wrong way round?? (I am beginner, and new to this
diff thing!)
here's the negative of the previous one...
------------------------------------------------------------------------
Sat, 10 Sep 2005 09:01:13 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.3.patch (560 bytes)
grrr....
Did I say I was a beginner?
I was diffing against the already modified file.
This patch should be the good one (either that or expect to have a
flood of support request when drupal 4.7 comes out!).
Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: beginner
-Status: patch (ready to be committed)
+Status: patch (code needs review)
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.3.patch (560 bytes)
grrr....
Did I say I was a beginner?
I was diffing against the already modified file.
This patch should be the good one (either that or expect to have a
flood of support request when drupal 4.7 comes out!).
beginner
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
------------------------------------------------------------------------
Sat, 10 Sep 2005 07:17:54 +0000 : beginner
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:22:23 +0000 : Prometheus6
Here's your test.
<?php
if (version_compare(phpversion(), '5', '<')) {
require_once('amazon.php4.inc');
} else {
require_once('amazon.php5.inc');
}
?>
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:52:41 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.patch (562 bytes)
Thanks Prometheus6.
here's a proper patch on includes/database.mysql.inc
tested on local (php 4.3.x) and remote (php 4.2.x).
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:56:09 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.2.patch (560 bytes)
Am I doing things the wrong way round?? (I am beginner, and new to this
diff thing!)
here's the negative of the previous one...
Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: beginner
Status: patch (ready to be committed)
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.2.patch (560 bytes)
Am I doing things the wrong way round?? (I am beginner, and new to this
diff thing!)
here's the negative of the previous one...
beginner
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
------------------------------------------------------------------------
Sat, 10 Sep 2005 07:17:54 +0000 : beginner
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:22:23 +0000 : Prometheus6
Here's your test.
<?php
if (version_compare(phpversion(), '5', '<')) {
require_once('amazon.php4.inc');
} else {
require_once('amazon.php5.inc');
}
?>
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:52:41 +0000 : beginner
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.patch (562 bytes)
Thanks Prometheus6.
here's a proper patch on includes/database.mysql.inc
tested on local (php 4.3.x) and remote (php 4.2.x).
Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: beginner
-Status: patch (code needs work)
+Status: patch (ready to be committed)
Attachment: http://drupal.org/files/issues/db-connect.database.mysql.inc.patch (562 bytes)
Thanks Prometheus6.
here's a proper patch on includes/database.mysql.inc
tested on local (php 4.3.x) and remote (php 4.2.x).
beginner
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
------------------------------------------------------------------------
Sat, 10 Sep 2005 07:17:54 +0000 : beginner
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
------------------------------------------------------------------------
Sat, 10 Sep 2005 08:22:23 +0000 : Prometheus6
Here's your test.
<?php
if (version_compare(phpversion(), '5', '<')) {
require_once('amazon.php4.inc');
} else {
require_once('amazon.php5.inc');
}
?>
Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: Prometheus6
Status: patch (code needs work)
Here's your test.
<?php
if (version_compare(phpversion(), '5', '<')) {
require_once('amazon.php4.inc');
} else {
require_once('amazon.php5.inc');
}
?>
Prometheus6
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
------------------------------------------------------------------------
Sat, 10 Sep 2005 07:17:54 +0000 : beginner
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
Issue status update for
http://drupal.org/node/30761
Post a follow up:
http://drupal.org/project/comments/add/30761
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: Anonymous
Reported by: beginner
Updated by: beginner
-Status: active
+Status: patch (code needs work)
I've seen that the list of requirements states php > 4.3.0, but I guess
I won't be the only one to be surprised to see that drupal doesn't work
AT ALL (no DB connection) when they upgrade.
Yet, by modifying the line above, to make it look like version 4.6, I
am able to use drupal cvs on my server with an older php version (I'm
on the lookout for other similar bugs).
I was trying to add a if loop, checking on the php version used, so
that we have:
<?php
if ($php_version >= 4.3.0){
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
}else{
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
}
?>
but I cannot find in the documentation how this variable can be tested.
Also, once connected to the data base, a warning in admin/settings can
be added about the php version used.
Or do you really mean to shut out all the people who depend on the
(lack of) will of their host to upgrade php? If so, at the very least,
add a list item in the error message to remind people to check for the
php version.
B.
beginner
Previous comments:
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:11:51 +0000 : beginner
Hello,
I just downloaded and installed the cvs version. It works on my local
system, but it doesn't on the remote host. I checked dozens of time the
settings.php password, db, etc...
Drupal 4.6 works perfectly at the same host, using the same data base,
same user, same password (different prefix only, and different
url/domain).
I get an empty string as sql error message:
The MySQL error was: .
"Are you sure you have the correct username and password?
"
Yes. the same as existing drupal 4.6 install.
"Are you sure that you have typed the correct hostname?
"
Yes. idem.
"Are you sure that the database server is running?
"
Yes. working for other installation.
To check that the settings.php was properly uploaded, I changed the
username in settings.php and uploaded again: the name changed in the
mention at the bottom of the new error page, but the mysql error is
still an empty string.
I do have a mysql error message if I change the username on my
localhost:
The MySQL error was: Access denied for user: 'testerror@localhost'
(Using password: YES).
Currently, the username is testerror and the database server is
localhost.
????
------------------------------------------------------------------------
Fri, 09 Sep 2005 09:58:29 +0000 : beginner
If I suppress the @ I have the following error message:
Warning: Wrong parameter count for mysql_connect() in
.../includes/database.mysql.inc on line 37
which seems strange in this context.
I have a - in the database host: out-data.org. Would that affect the
parsing of the variable in settings.php?
------------------------------------------------------------------------
Fri, 09 Sep 2005 11:26:00 +0000 : beginner
It's definitely a php problem, not mysql settings:
we use PHP Version 4.2.3
by replacing the line:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
by its values:
<?php
$connection = mysql_connect('data.out-data.org', 'user', 'pass', TRUE, 2);
?>
I still get the Wrong parameter count for mysql_connect() message...
???
4.6 works fine on the same host.
------------------------------------------------------------------------
Fri, 09 Sep 2005 13:45:29 +0000 : beginner
Drupal 4.6:
<?php
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
?>
Drupal cvs:
<?php
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
?>
One more parameter has been added.
php.net/mysql_connect :
php 4.3.0 Added the client_flags parameter.
i.e. cvs Drupal and the coming 4.7 version will not work for php
versions < 4.3.0. My hosts unfortunately uses 4.2.3.
Issue status update for
http://drupal.org/node/29681
Post a follow up:
http://drupal.org/project/comments/add/29681
Project: Drupal
Version: cvs
Component: base system
Category: bug reports
Priority: normal
Assigned to: thehunmonkgroup
Reported by: thehunmonkgroup
Updated by: killes(a)www.drop.org
-Status: patch (code needs review)
+Status: patch (ready to be committed)
I think it is obvious that the display function is overcorrecting.
At the top of the function we correct for Drupal server time or user tz
and then wwe later again shift the zone.
print date('D, M jS, G:i', time()-date('Z'));
print gmdate('D, M jS, G:i', time());
this code gives the same for me and shows that the timestmap is further
modified.
killes(a)www.drop.org
Previous comments:
------------------------------------------------------------------------
Thu, 25 Aug 2005 22:04:51 +0000 : thehunmonkgroup
Attachment: http://drupal.org/files/issues/format_date.patch (817 bytes)
function format_date in common.inc is using gmdate() incorrectly. the
function is trying to format a local timestamp, and GMT conversion is
incorrect in this case. date() should be used instead. bug also
exists in 4.6, and this patch should apply there, too. haven't checked
the earlier versions of drupal...
------------------------------------------------------------------------
Sat, 27 Aug 2005 04:47:39 +0000 : thehunmonkgroup
switching to patch status
------------------------------------------------------------------------
Sat, 03 Sep 2005 23:05:37 +0000 : clydefrog
Are you sure about the logic here? I've tried to fix timezone issues
before, and I always get confused. My reading of the documentation
makes me think your patch is wrong:
If the timestamp has already been converted to a localized time, then
gmdate() should be used because gmdate() does no timezone adjustments
(it does not care what PHP's timezone settings are). Using date() is
incorrect because it does care what PHP's timezone settings are.
------------------------------------------------------------------------
Sun, 04 Sep 2005 04:21:12 +0000 : thehunmonkgroup
i'm fairly certain that my logic is correct here. the php doc on
gmdate() is not totally clear, but i think that if you read it over
closely, you'll see that it's the other way around--gmdate() is
actually the one that adjusts the timestamp passed. i would recommend
writing some short scripts to test out how gmdate() and date() actually
operate(that's what i had to do!)--i think you'll see that what happens
is gmdate() takes the timestamp passed, applies the server timezone
offset, and returns the (formatted) result as GMT. that's what my
tests have shown, and for the format_date function, this operation is
incorrect--the goal of the function is to simply make the timestamp
passed into a human-readable date. no adjustment is necessary.