[Andreas]

In album.php FIND (2 instances)

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user USING (userid) 


REPLACE that with

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user AS user USING (userid) 


FIND

PHP Code:

FROM ".TABLE_PREFIX."customprofilepic 


REPLACE that with

PHP Code:

FROM ".TABLE_PREFIX."customprofilepic AS customprofilepic 


FIND

PHP Code:

LEFT JOIN ".TABLE_PREFIX."usertextfield 


REPLACE that with

PHP Code:

LEFT JOIN ".TABLE_PREFIX."usertextfield AS usertextfield 


FIND

PHP Code:

FROM ".TABLE_PREFIX."user 


REPLACE that with

PHP Code:

FROM ".TABLE_PREFIX."user AS user 


This should take care of table prefixes.