I am getting the following error when I try to add photos using the submit photo option in the My Album Module:
-------------------
Error Code: 0013


ERROR: Could not query the database.
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' res_y= WHERE lid=23' at line 1
--------------------

I am using:

Xoops 2.0.5
MyAlbum 2.04

I have checked the file permissions, etc and running "Check Config&Environments" returns all ok's.

Any ideas?

Do you mean myAlubm-P 2.04 ?

If so, try 2.50beta please.
And show the result of Check Config & Environments here.