MySQL Field Type Plugin

12 years 10 months ago #164684 by pepperstreet
Replied by pepperstreet on topic MySQL Field Type Plugin | softforge vs. incubator
Hello,
there are also two SQL related incubator fields... are there any pros and cons? What are the differences or benefits?

Please Log in to join the conversation.

12 years 7 months ago #171377 by ragutierrez
Replied by ragutierrez on topic Re: MySQL Field Type Plugin
I am trying to read from extenral ms sql database table, is it possibly to modify the plugin to read to this table??

Please Log in to join the conversation.

12 years 7 months ago #172344 by seniyajw
Replied by seniyajw on topic Re: MySQL Field Type Plugin
I got a unique selection of table and wanted to show this field in a list of users. She no longer works in 1.3.1 using PHP5.3. An installation with 5.2.9 is still working.

Please Log in to join the conversation.

12 years 6 months ago #176388 by zflexsoftware
Replied by zflexsoftware on topic Re:MySQL Field Type Plugin
I would really like this feature as well. Get my vote as a vice function to added.

Thanks - ZF

Please Log in to join the conversation.

12 years 6 months ago #176671 by fenixsz
Replied by fenixsz on topic Re:MySQL Field Type Plugin
There is an sql error when I attempt to open User Manangement Tab.

From the tools section, found this:

There are 2 column(s) missing in the comprofiler table, which are defined as fields (rows in comprofiler_fields):

- Field cb_make - Column cb_make is missing from comprofiler table.

- Field cb_country - Column cb_country is missing from comprofiler table.

This one can be fixed by deleting and recreating the field(s) using components / Community Builder / Field Management.
Please additionally make sure that columns in comprofiler table are not also duplicated in users table.

Please Log in to join the conversation.

12 years 1 month ago #190341 by 3cellhosting
Replied by 3cellhosting on topic Re: MySQL Field Type Plugin
This is a great addition to CB B)

I am using Joomla 1.7 with CB 1.7 and I have 2 fields using this plugin.

The first field is a simple single result and works just fine...

SELECT CONCAT ('User ID',' ',id)
FROM #__users
WHERE id = {USERID}

The second is a more complex multiple result and doesn't appear to work at all....

SELECT CONCAT(DATE_FORMAT(FROM_UNIXTIME(date_submitted),'%d/%m/%Y'),' Time Keeping = ',score_a,' Appearance = ',score_b,' Accuracy = ',score_c,' Productivity = ',score_d,' Follow Instructions = ',score_e,' Client Knowledge = ',score_f,' Interaction = ',score_g) AS 'detail'
FROM rms_ind_scores
WHERE username = {USERID} AND rms_ind_scores.storeid IN (SELECT DISTINCT store_id FROM rms_users LEFT JOIN rms_user_usergroup_map ON rms_users.id = rms_user_usergroup_map.user_id LEFT JOIN rms_clients ON rms_user_usergroup_map.group_id = rms_clients.usergroups_id LEFT JOIN rms_stores ON rms_clients.client_id = rms_stores.client_id WHERE rms_user_usergroup_map.user_id = {VIEWERID} AND store_id IS NOT NULL)
ORDER BY date_submitted DESC
LIMIT 0, 3

We have also tried substituting #__ for the prefix rms_ but get no results displayed.

Any suggestions would be appreciated.

David
www.3cellhosting.com - where personality, creativity and integrity come as standard.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.192 seconds

Facebook Twitter LinkedIn