mysql> select count(*) from members where signup_date = '2001-03-01';
ERROR 1032: Can't find record in 'members'
Indicates a problem with the table structure; the result would be
+----------+
| count(*) |
+----------+
| 0 |
+----------+
If there was a problem with the data.
I suggest reviewing the isamchk results, and I'll leave it to the MySQL guys
to interpret the error further.
Good Luck
Quentin
-----Original Message-----
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 March 2001 4:33 p.m.
To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Ok, here goes...
mysql> select member_id, signup_date from members order by member_id desc
limit 410;
+-----------+-------------+
| member_id | signup_date |
+-----------+-------------+
(here's the last 20 or so rows)
| 0120472 | 2001-03-01 |
| 0120471 | 2001-03-01 |
| 0120470 | 2001-03-01 |
| 0120469 | 2001-03-01 |
| 0120468 | 2001-03-01 |
| 0120467 | 2001-03-01 |
| 0120466 | 2001-03-01 |
| 0120465 | 2001-02-28 |
| 0120464 | 2001-02-28 |
| 0120463 | 2001-02-28 |
| 0120462 | 2001-02-28 |
| 0120461 | 2001-02-28 |
| 0120460 | 2001-02-28 |
| 0120459 | 2001-02-28 |
| 0120458 | 2001-02-28 |
+-----------+-------------+
This tells me that there are about 400 people that have signed up TODAY. The
date is correct on the server:
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2001-03-01 19:33:05 |
+---------------------+
So, the question is, why does this not return 400, like it should???
OK, weird! Now I am getting this error...
mysql> select count(*) from members where signup_date = '2001-03-01';
ERROR 1032: Can't find record in 'members'
I have checked the tables using the checking utility, they show up fine.
What's going on? =)
-----Original Message-----
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:45 PM
To: 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Can you post some of the data - e.g the first 500 rows of the 'order by'
select, and the results of the select with signup_date='2001-03-01'.
Also, how about
Select now(), signup_date from ...., to see what things are being compared.
Regards
Quentin
-----Original Message-----
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 March 2001 3:34 p.m.
To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Quentin,
that does not work either, I still get the 125 number, when there are
actually 500 records =(
I am using version 3.22.32
-----Original Message-----
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:18 PM
To: 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Hi,
Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that
gives.
Also, what version are you on - I have had some date problems where the end
of one month and the begining of another get confused (usually when doing a
UNIX_TIMESTAMP).
Maybe then use mysqlbug to report the issue, and include the results of your
tests.
Not much help, I know, but the more information you post, the more help we
can be.
Regards
-----Original Message-----
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 March 2001 1:03 p.m.
To: [EMAIL PROTECTED]
Subject: more date problems
okay, this is a follow-up to my past email...
since I KNOW more than 122 people have signed up today, I did the following
query:
SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit
200;
there are at LEAST 200 people that have signed up today. however, when i do:
SELECT count(*) FROM members WHERE signup_date = now();
I only get 122 results! And YES, I have tried "2001-03-01" instead of
"now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever.
Does anyone have any idea what could be going on? I run this query quite
often, is it possible the result is somehow being saved in a buffer? Should
I shutdown the mysql server and restart it?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
