0000 years in Db or something else?
Ant
My friend and I are trying to determine why both http://aqfl.net and
http://ross154.net (both runs on a PowerPC with Debian (Kernel
2.6.18-4-powerpc #1 Fri May 4 01:05:19 UTC 2007 ppc GNU/Linux) are
showing years, 0000, and won't let us log in.
We believe both Drupal v4(?) [not installed from a Debian package] and
Wordpress v2.7.1-2 are using MySQL-server v5.1.36-4. He recalls
upgrading MYSQL from v5.0 to v5.1, and unsure if it is related to the
symptoms (also can't log in at all). Or maybe it is not MySQL, but PHP5
v5.2.10.dfsg.1? We checked for logs, but PHP doesn't seem to keep any
and Apache and MySQL are unaware of an issue.
Please note that we are database/SQL newbies so we might be doing
something seriously wrong here.
Thank you in advance. :)
--
"When you can't fight on and drop to die; you're just a big tasty feast
for the crows, ants, buzzards and flies." --unknown
/\___/\
/ /\ /\ \ Phil/Ant @ http://antfarm.ma.cx (Personal Web Site)
| |o o| | Ant's Quality Foraged Links (AQFL): http://aqfl.net
\ _ / Nuke ANT from e-mail address: phi...@earthlink.netANT
( ) or ANT...@zimage.com
Ant is currently not listening to any songs on his home computer.
J.O. Aho
> My friend and I are trying to determine why both http://aqfl.net and
> http://ross154.net (both runs on a PowerPC with Debian (Kernel
> 2.6.18-4-powerpc #1 Fri May 4 01:05:19 UTC 2007 ppc GNU/Linux) are
> showing years, 0000, and won't let us log in.
PHP5.2.10 has a serious bug that affects all big endian architectures (this
includes PowerPC, Sparc and so on), where some x86 coder made a big no no when
he updated the code. You will need to rebuild the php 5.2.10 with the
following patch:
--- php/php-src/branches/PHP_5_2/ext/date/php_date.c 2009/06/05 22:34:30 281735
+++ php/php-src/branches/PHP_5_2/ext/date/php_date.c 2009/06/21 22:19:19 282540
@@ -798,7 +798,7 @@
/* year */
case 'L': length = slprintf(buffer, 32, "%d", timelib_is_leap((int)
t->y)); break;
case 'y': length = slprintf(buffer, 32, "%02d", (int) t->y % 100); break;
- case 'Y': length = slprintf(buffer, 32, "%s%04ld", t->y < 0 ? "-" : "",
llabs(t->y)); break;
+ case 'Y': length = slprintf(buffer, 32, "%s%04lld", t->y < 0 ? "-" : "",
llabs(t->y)); break;
/* time */
case 'a': length = slprintf(buffer, 32, "%s", t->h >= 12 ? "pm" : "am");
break;
If you want to download a correct one, you can do that from here:
http://bugs.gentoo.org/attachment.cgi?id=198329
Sadly many distributions don't think it's a big issue as they mainly see x86
users are everything and not looking at the needs of the second largest
desktop and server architecture and of course the largest embedded
architecture, but you have proven it is.
Other options if you don't want to compile PHP yourself, downgrade to 5.2.9 or
upgrade to 5.2.11/5.3.0.
--
//Aho
Jerry Stuckle
> Hello!
>
> My friend and I are trying to determine why both http://aqfl.net and
> http://ross154.net (both runs on a PowerPC with Debian (Kernel
> 2.6.18-4-powerpc #1 Fri May 4 01:05:19 UTC 2007 ppc GNU/Linux) are
> showing years, 0000, and won't let us log in.
>
> We believe both Drupal v4(?) [not installed from a Debian package] and
> Wordpress v2.7.1-2 are using MySQL-server v5.1.36-4. He recalls
> upgrading MYSQL from v5.0 to v5.1, and unsure if it is related to the
> symptoms (also can't log in at all). Or maybe it is not MySQL, but PHP5
> v5.2.10.dfsg.1? We checked for logs, but PHP doesn't seem to keep any
> and Apache and MySQL are unaware of an issue.
>
> Please note that we are database/SQL newbies so we might be doing
> something seriously wrong here.
>
> Thank you in advance. :)
Did you upgrade both MySQL and PHP at the same time? Have you done any
troubleshooting on your own? Have you checked the WordPress and Drupal
support groups (the FIRST place you should go when you have product
problems).
BTW - how many more newsgroups can you find to post this to? What does
this have to do with Apache, for instance? It is generally accepted
practice to post to at most about three newsgroups - and those being
where you have previously determined are the most applicable.
Set FUPs to comp.lang.php and alt.comp.databases.mysql only.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================
Ant
to the box and OS.
--
"A coconut shell full of water is a(n) sea/ocean to an ant." --Indians
/\___/\
/ /\ /\ \ Phil/Ant @ http://antfarm.ma.cx (Personal Web Site)
| |o o| | Ant's Quality Foraged Links (AQFL): http://aqfl.net
\ _ / Nuke ANT from e-mail address: phi...@earthlink.netANT
( ) or ANT...@zimage.com
Ant is/was listening to a song on his home computer: Brooklyn Bridge -
Unchained Melody
Ant
> Did you upgrade both MySQL and PHP at the same time? Have you done any
> troubleshooting on your own? Have you checked the WordPress and Drupal
> support groups (the FIRST place you should go when you have product
> problems).
Why would it be Drupal if both WordPress and Drupal are having the same
problems?
> BTW - how many more newsgroups can you find to post this to? What does
> this have to do with Apache, for instance? It is generally accepted
> practice to post to at most about three newsgroups - and those being
> where you have previously determined are the most applicable.
Because it is not specific to one program. It seems to be related to Db
or Apache server with the issues. I did post in Drupal forum a few days
ago, but my friend and I noticed the WordPress has issue. Also, no one
knew what was wrong in Drupal forum too.
--
"A coconut shell full of water is a(n) sea/ocean to an ant." --Indians
/\___/\
/ /\ /\ \ Phil/Ant @ http://antfarm.ma.cx (Personal Web Site)
| |o o| | Ant's Quality Foraged Links (AQFL): http://aqfl.net
\ _ / Nuke ANT from e-mail address: phi...@earthlink.netANT
( ) or ANT...@zimage.com
Ant
> (this includes PowerPC, Sparc and so on), where some x86 coder made a
> big no no when he updated the code. You will need to rebuild the php
> 5.2.10 with the following patch:
>
> Sadly many distributions don't think it's a big issue as they mainly see
> x86 users are everything and not looking at the needs of the second
> largest desktop and server architecture and of course the largest
> embedded architecture, but you have proven it is.
>
> Other options if you don't want to compile PHP yourself, downgrade to
> 5.2.9 or upgrade to 5.2.11/5.3.0.
My friend downgraded PHP back to v5.2.9 and now it works on both Drupal
and WordPress! Hurray! Thank you very much. :)
--
"Oh bother", said Winnie the Pooh, "There's an ant on my foot..."
Jerry Stuckle
> On 8/1/2009 3:39 PM PT, Jerry Stuckle typed:
>
>> Did you upgrade both MySQL and PHP at the same time? Have you done
>> any troubleshooting on your own? Have you checked the WordPress and
>> Drupal support groups (the FIRST place you should go when you have
>> product problems).
>
> Why would it be Drupal if both WordPress and Drupal are having the same
> problems?
>
Quite easily - many CMS's have common code - the same developers, for
instance, or code ideas "borrowed" from other CMS's. It's all open
source, after all.
>
>> BTW - how many more newsgroups can you find to post this to? What
>> does this have to do with Apache, for instance? It is generally
>> accepted practice to post to at most about three newsgroups - and
>> those being where you have previously determined are the most applicable.
>
> Because it is not specific to one program. It seems to be related to Db
> or Apache server with the issues. I did post in Drupal forum a few days
> ago, but my friend and I noticed the WordPress has issue. Also, no one
> knew what was wrong in Drupal forum too.
How does it relate to Apache Server, for instance?
It's obvious you made little or no attempt to isolate the problem before
cross posting to every newsgroup you could think of. A little bit of
could have gotten you to the PHP bug days ago.