45 Posts
ca_V
7 years ago
1
Topic

Hi,

In a list of comment I try to display the image avatar with a SQL field and this query :

SELECT avatar FROM #__users WHERE id =$cck->getValue( 'user_note_user_2' )

Error 1054 tell me "Unknown column 'avatar'" but my field avatar is actually store in Standard | Users | avatar

Whait is wrong?

Get a Book for SEBLOD
1283 Posts
Bucklash
7 years ago
0
Level 1

Hi

Your field is not in the Joomla #__users table, is it?

It is in either the global Seblod user table:

#__cck_store_item_users


or the table specific to the content type

#__cck_Store_form_somecontenttyype

check out the db, look in #__cck_core_fields if need to.

Get a VIP membership