Problem referring to an event custom field in database
By Helene Larocque on Wednesday, 19 August 2015
Posted in Technical Issues
Replies 6
Likes 0
Views 561
Votes 0
Hi !
I created a new category event in which I added some new custom fields (file fields) so we can associate documents to an event. Now I want to have access to this document from the module view. I wanted to query the database (table 'j3_social_fields_data') to access the files but, for the new custom fields there is no datakey. This fields is simply empty. As all other type of information is clearly identified (such as "name", "first", etc.), I wonder why there is no datakey for custom fields. I'm pretty sure this is a bug. Also, where are they saved (the files)?

Joomla version : 3.4.3
EasySocial version : 1.3.30
Hi Helene,

I am really sorry for the delay of this reply.

Can you provide us with your Joomla backend and FTP access so we can check on the issue directly?
Ezrul Fazwan
·
Wednesday, 19 August 2015 20:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Halene,

Thank you for the access. However when I'm trying to access your administrator page, the page requested me to enter additional login message as you can see from my screenshot here, http://screencast.com/t/VAXlBnXcMcD. Please advise.
Ezrul Fazwan
·
Thursday, 20 August 2015 13:32
·
0 Likes
·
0 Votes
·
0 Comments
·
refer site details below.
Helene Larocque
·
Saturday, 22 August 2015 04:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Helene,

I am really sorry for the delay of this reply as I've missed out this post earlier.

Easysocial custom field is a little bit complicated and it's actually related with different tables inside your database. If you want to query out the custom field of your event, you can try to use the following API to echo it out.
$id = 26; // Your event id

$event = $FD::event($id);

echo $event->getFieldData('FILE-1') // FILE-1 is the unique key of your file key. Refer my screenshot below

You can get the key value of the custom field by going to your backend > easysocial > event > categories > choose your category > custom field, http://screencast.com/t/ANbiq1PfIK . Hope these help.
Ezrul Fazwan
·
Thursday, 03 September 2015 13:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Excellent ! I will try it. That would be very usefull in a future release. :-)
Helene Larocque
·
Thursday, 03 September 2015 20:31
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Helene
Mark
·
Saturday, 05 September 2015 17:15
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post