Problem with upgrade

2006-11-22 Thread Tom Ray [Lists]
I upgraded a server from 4.0 to 4.1 and then to 5.0 but I've been running into a problem. When I was running 4.0 the passwords with the password('password') command where being created like this: 2a287c002f9773dc now after I upgraded to 4.1 when I add a new user the passwords end up being like

Results Order Question

2006-09-28 Thread Tom Ray [Lists]
I'm running into a problem with a ratings script I'm writing. The overview is that a user can rate an item from 1-10. What I want it to do is display the highest rated item, with 10 being the highest rating. In case there are multiple items sharing the same score, the item that has been rated t

Re: Autoindexing

2006-06-23 Thread Tom Ray [Lists]
hould find and edit table where it sotres index/counter data.. Tom Ray [Lists] wrote: Hey, I have a really simple question (I hope)..I have a database that has a field in it that autoindexes the number. I screwed up and imported a bunch of wrong data. Up to row 200 it's right, beyond that

Autoindexing

2006-06-22 Thread Tom Ray [Lists]
Hey, I have a really simple question (I hope)..I have a database that has a field in it that autoindexes the number. I screwed up and imported a bunch of wrong data. Up to row 200 it's right, beyond that it was wrong so I had delete it all. The problem now is the autoindexing is set to 1105, I

Re: my.cnf / mysqld logging

2006-06-16 Thread Tom Ray [Lists]
How would I do that? I'm still a novice when it comes to many aspects of mysql. [EMAIL PROTECTED] wrote: Hi, Try to enable query log. Thanks & Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are in production but I noticed that there\'s not activ

my.cnf / mysqld logging

2006-06-16 Thread Tom Ray [Lists]
Hey there, I inherited a couple of servers that are in production but I noticed that there's not active logging for mysql on any of them. I looked and they don't have an active my.cnf file any where on the machines. One machine is running mysql 4.1.5 and the other is running mysql 5.0.18 When