Get "Resoruce id #n" error

Is this due to Mysql version?

[tomda]

I have put my local website online and got many resource id error messages. I have notice that my local version of Mysql is different to the one on host.

I just want a confirmation.
Is Mysql the online program involved when getting resource id error message.

If yes, then I need to get the same version than the host one. Thank you

[mcavic]

There are many reasons for errors involving resource ids. If you're getting the errors at a time when the site should be doing database access then yes, it's probably MySQL.

First check that the web site is using the correct database hostname, database name, username, and password, and that you are able to log into the database manually using those settings.

If you moved to an older version of MySQL - especially from 4.x to 3.x, then there could be some SQL statements that aren't compatible.

[tomda]

Thanks Mcavic.

Indeed, I had downloaded a previous version of MySQL (3.x) and got the same error in localhost (I had a 4.x on local). So, I manage to rectify some SQL statements.

But it is somehow hard to find where the error is as the error message does not provide much more information than the short "Resource id#n".

[coopster]

I often setup a DEBUG mode in my code that I can turn on to alter the logic/flow of any statement execution. It's at that point that I use use the mysql_error apis to get more specifics on MySQL error messages.