Click to See Complete Forum and Search --> : Is there anywhere I can find the definitions of SQL errors?


neil
06-09-2003, 09:05 AM
Is there anywhere I can find the definitions of mySQL errors?

I want to know what ERROR 1044 + ERROR 1045 mean in deatail

thanks Neil

pyro
06-09-2003, 09:21 AM
Take a look at http://us3.php.net/manual/en/function.mysql-error.php

neil
06-09-2003, 09:26 AM
cheers :)

neil
06-09-2003, 09:30 AM
this is whats on that page, but there must be a site/ download somehwere that allows me to read message description

ERROR 1044: Access denied for user: 'ituser@mail.ramon.intranet' to database 'itcom'

This error ocurrs when a intent of a sql insert of no authorized user. The results: mysql_errno = 0 and the mysql_error = "" .

--does this mean if I i'm getting error 1044, I'm not authorised?

pyro
06-09-2003, 09:39 AM
Yes, it would appear that the user "'ituser@mail.ramon.intranet" does not have access to the database "itcom"

neil
06-09-2003, 09:52 AM
- I was just wondering whether it might also mean the db 'itcom' doesn't exist because I've been getting 1044 error when trying to connect (I'm still newish to all this php/mysql stuff)

pyro
06-09-2003, 09:59 AM
I think unknown database is a 1049 error

neil
06-09-2003, 10:08 AM
thanks, that gives me a better idea whats going on :)