27 Posts
jsfernando
11 years ago
1
Topic

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

http://easycaptures.com/fs/uploaded/727/7896084462.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,

Get a Book for SEBLOD
27 Posts
jsfernando
11 years ago
0
Level 1

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

Get a Book for SEBLOD