On Sun, May 4, 2008 at 5:37 PM, Patrick Aljord <[EMAIL PROTECTED]> wrote:
> > Your doing a left join which can increase the number of rows returned.
> > This is then GROUP BYed and run through a HAVING. Is:
> > posts.poster_id=users.id
> > a one to one relationship? If it is not, then count(
> Your doing a left join which can increase the number of rows returned.
> This is then GROUP BYed and run through a HAVING. Is:
> posts.poster_id=users.id
> a one to one relationship? If it is not, then count(*) would be a
> larger number and pass the HAVING. This may not be your problem, but
Glyn Astill wrote:
I'd back up the data directories then try and then re-install mysql (sorry, I
know little about red hat and it's package management). It shouldn't overwrite
your data if it's already present anyway.
Great. Thought that would be the case, but without sleep, I wasn't sure. :-
See http://dev.mysql.com/doc/refman/5.0/en/comments.html.
Regards,
Baron
On Sun, May 4, 2008 at 1:05 AM, Moon's Father <[EMAIL PROTECTED]> wrote:
> Thanks for your reply.This works for me.
> Can you tell me why the number is 9?
> when I try others,it can not work at all.
>
> On Wed, Apr 30
Decided to run up2date -u
I noticed that our website was tossing off mysql errors. Quickly
realized that mysql was down. Went to restart but it couldn't find
mysqld_safe, mysqld, mysqladmin, etc.
I used locate and it couldn't find the binaries anywhere...it appears
that up2date -u had someho