got it
The SQL syntax looked like this:
SELECT text AS __users.name #, # __ users.id AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24
Appears [Faculty Supervisor]
Docentes Responsáveis
http://easycaptures.com/fs/uploaded/726/7363199289.png
But the time of writing does not work, the field in the table is as int (11).
Error message appears [an error occurred]
I tried to change the SQL and field to see if it would:
Now to save as same name ...
Field in the table varchar (255)
SELECT text AS __users.name #, # __users.name AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24
It worked ... is recording, but the error message still appears [an error occurred]
How and why I use the the error message?
Check this out ...
Select
Dynamic FREE, funcioando in SEBLOD and Free Writing Table in MySQL, but
still appears error message [an error occurred] in joomla
Check out the pictures:
http://easycaptures.com/fs/uploaded/727/8507442992.png
Select FREE Dynamic Field was thus conformed to the image:
http://easycaptures.com/fs/uploaded/727/6206156052.png
SELECT text AS __users.name #, # __users.name AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24
And the field that refers to the table is "responsible" ...
http://easycaptures.com/fs/uploaded/727/9233089968.png
Any idea why the "error" appears in FormSeblod Select the field and also writes the Table!?
Thank you,
Solved!
Searching through the debug / joomla systems, I found that there is a relationship between Tables and Table FREE cck_core the SEBLOD and there has to be an ID Table for FREE so there is this relationship and that after every insertion via Form is pursued via Search / List ...
My table had a unique ID, but a set of fields that determined the primary key, I changed it and it worked ...
No longer appears the error message when recording or consecutively Search / List also worked!
I found this result by opening the debug joomla and checking which queries were made ... and found seguinta query SEBLOD ...
SELECT t0.id the pid, the pk t0.pk, t0.pkb the pkb, t0.cck the cck, t0.storage_location the loc, tt.id AS type_id, tt.alias AS type_alias
# __cck_core FROM `AS` t0
LEFT JOIN `AS` t1 # __disciplinas
ON t1.id = t0.pk
LEFT JOIN `#` AS tt __cck_core_types
ON = tt.name t0.cck
WHERE t0.cck = 'formulrio_disciplinas'
AND ((t1.ano LIKE '% 08'))
GROUP BY t0.pk
ORDER BY ASC t1.ano, t1.codigo ASC, ASC t1.semestre