UPDATE 'pex_plotservercreative'.'permissions_inheritance'
SET 'pex_plotservercreative'.'permissions_inheritance'.'parent' = 'Member'
FROM 'pex_plotservercreative'.'permissions_inheritance'
INNER JOIN 'phpbb'.'phpbb_profile_fields_data'
ON 'phpbb'.'phpbb_profile_fields_data'.'minecraftname' = 'pex_plotservercreative'.'permissions_inheritance'.'child'
WHERE 'phpbb'.'phpbb_profile_fields_data'.'minecraftname' = 'pex_plotservercreative'.'permissions_inheritance'.'child'
AND 'pex_plotservercreative'.'permissions_inheritance'.'parent' = 'default'

#1064 - 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 ''pex_plotservercreative'.'permissions_inheritance' SET 'pex_plotservercreative'.' at line 1

DB1: pex_plotservercreative
DB2:phpbb
DB1:T: permissions_inheritance
DB2:T: phpbb_profile_fields_data

If DB1 child is the same as DB2 minecraftname it means the user has an account on the forums an additional check is to see if the child is the parent of default as we do not want to demote people that sign up on the forums. Once checks are done We need to change default so it is the word member this will then complete the promotion.