[deta]

Originally Posted by KirbyDE

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.

Hello

Now I changed in such a way, but now I get one mysql errors.
Before I still "AS user" an "AS.." attached hattte was not the error.
Only the pictures were not indicated.
Neither in the Admincp nor in the album

Ungueltige SQL-Abfrage:
SELECT vb3_user.userid, dateline, comment, vb3_user.username, vb3_user.usertitle, vb3_user.joindate, vb3_user.usergroupid
FROM vb3_customprofilepic AS customprofilepic
LEFT JOIN vb3_user AS user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0, 18

mysql error: Unknown table 'vb3_user' in field list

mysql error number: 1109

The tables are called with me all vb3 _ and are also present. Also the vb3 _ table.

cu Deta