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 VIP membership
27 Posts
jsfernando
11 years ago
0
Level 1

Solved!

Found because the result of the Search / List does not bring all the data from Table ...
I had entered through a script much data in Table FREE MySQL I created for a Form

The SEBLOD launches in the table "# __cck_core" all inserts that are made via Form and then when u do a Search / List Form that it will search this table all records inserted by Form.

Some appeared in my case I did test the Form, but others do not, for he found no relationship Database (Id) with table SEBLOD "# __cck_core"!!

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

In my example I have registered Disciplines year 2008-2013, the 2013 I had inserted the Form, but not too ... Select and above that provided quotes Where the year 2008, there appeared nothing in the query ...

The Result is ... make a php script that Read Table Free Disciplines all records and insert those not entered in "# __cck_core" example below ...
INSERT INTO `database`. __cck_core `#` (
`Id`, ==> id is auto-increment
`` Cck, ==> is the name of the form
`Pk` ==> is the id of the record inserted by the form or the id of the record you have on the table FREE
`` Pkb, ==> default 0 zero
`` Storage_location, ==> the type of storage that I used "FREE"
Storage_table `` ==> my table "FREE" # __disciplinas
`Author_id` ==> Author I am using for this
`Parent_id`,
`Store_id`,
`Date_time`,
`App`
)
VALUES (
NULL, 'formulrio_disciplinas', '439 ', '0', 'free', '# __disciplinas', '477 ', '0', '0 ', '2013-08-19 12:06:03',''
);

Now yes ... with everything working consultation in Table FREE, even if you have inserted records by Form ... but it is a rare case!
For inserting the Form ... everything will appear normally ...
My case is that I had files. "Csv" with much of all records and may be included / added usually after the Form tbém ...

Hugs

Get a VIP membership