[welo]

Installing on 3.0.1 and receive this error in albumcp.php?do=approve

Invalid SQL: 
		SELECT customprofilepic.*, user.username 
		FROM vb3_customprofilepic 
		LEFT JOIN vb3_user 
		USING (userid) 
		ORDER BY visible, username
	
mysql error: Unknown table 'customprofilepic'

mysql error number: 1051

This corresponds to line 56 of albumcp.php so for gits and shiggles I tried:

SELECT " . TABLE_PREFIX . "customprofilepic.*, " . TABLE_PREFIX . "user.username

...and it worked, except I got broken images in the ACP exactly like Bofoo was getting, and the MySQL 1064 error on album.php Calvin got.

Now you say ACP -> vB3 Member Photo -> Settings (which is actually 'Options') is the key, so I set entries per page from 18 to 12. Making progress. Now I get this error on album.php:

Invalid SQL: 
		SELECT user.userid, dateline, 
		comment, user.username, user.usertitle, 
		user.joindate, user.usergroupid
		FROM vb3_customprofilepic 
		LEFT JOIN vb3_user USING (userid) 
		WHERE visible=1
		 
		ORDER BY posts desc
		LIMIT 0, 12
	
mysql error: Unknown table 'user' in field list

mysql error number: 1109

Yet another table prefixing issue, right? This around line 193 in album.php, so now I have:

	$images = $DB_site->query("
		SELECT ".TABLE_PREFIX."user.userid, dateline, 
		comment, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle, 
		".TABLE_PREFIX."user.joindate, ".TABLE_PREFIX."user.usergroupid
		FROM ".TABLE_PREFIX."customprofilepic 
		LEFT JOIN ".TABLE_PREFIX."user USING (userid) 
		WHERE visible=1

Now it appears to be working. Beginning to look like you need to update a couple of files in your zip though.