10 years ago
10
Topic
I´m trying to list a free object table, it say no results but it´s wrong. I have debug the query and is:
SELECT t0.id as pid, t0.pk as pk, t0.pkb as pkb,t0.cck as cck, t0.storage_location as loc,tt.id AS type_id, tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__rede_docencia` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t2.state = 1 AND t2.access IN (1,1) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2014-03-26 09:33:53' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2014-03-26 09:33:53' ) AND t0.cck = 'rede' AND t1.Ativo REGEXP "(::activo::).*1.*(::/activo::)" GROUP BY t0.pk
ORDER BY t2.title ASC
Seblod are hardcoding values that i haven´t selected.
LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk ??!! i haven´t selected any content field...
t2.state = 1 AND t2.access IN (1,1) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2014-03-26 09:33:53' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2014-03-26 09:33:53' ) I don´t have these field´s, and t2 in query is #_content but i don´t use content table...
SELECT t0.id as pid, t0.pk as pk, t0.pkb as pkb,t0.cck as cck, t0.storage_location as loc,tt.id AS type_id, tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__rede_docencia` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t2.state = 1 AND t2.access IN (1,1) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2014-03-26 09:33:53' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2014-03-26 09:33:53' ) AND t0.cck = 'rede' AND t1.Ativo REGEXP "(::activo::).*1.*(::/activo::)" GROUP BY t0.pk
ORDER BY t2.title ASC
Seblod are hardcoding values that i haven´t selected.
LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk ??!! i haven´t selected any content field...
t2.state = 1 AND t2.access IN (1,1) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2014-03-26 09:33:53' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2014-03-26 09:33:53' ) I don´t have these field´s, and t2 in query is #_content but i don´t use content table...
10 years ago
1
Level 1
My fault, after i review and review all steps i find that cck type select i have choose wrong type... amateur ://
85 Posts
10 years ago
0
Level 2
Hi Codigo Aberto !
Can you specify in few steps how have you list a free table ?
Thanks in advance
Jpeg
Can you specify in few steps how have you list a free table ?
Thanks in advance
Jpeg
10 years ago
7
Level 1
1 - I have created a free content type, all free field´s are from the existing custom table.
2 - Since the table have has already populated, are have created a loop script to insert records in #_cck_core to match the custom table. ( the pass in necessary only if you have already a populated table.
3 - Created a list free content type and the item menu.
2 - Since the table have has already populated, are have created a loop script to insert records in #_cck_core to match the custom table. ( the pass in necessary only if you have already a populated table.
3 - Created a list free content type and the item menu.
85 Posts
10 years ago
6
Level 2
Thanks a lot Codigo Aberto,
It's that I seem, we have still needing to reached the #__cck_core table. I was thinking that you had a solution to pass over this step.
BR
Jpeg
It's that I seem, we have still needing to reached the #__cck_core table. I was thinking that you had a solution to pass over this step.
BR
Jpeg
10 years ago
5
Level 3
in seblod these table is like assets table of joomla core.
We are developp a component to help that.
We are developp a component to help that.
85 Posts
10 years ago
4
Level 4
Yes I know... but component don't help me (but it's a very good idea for purpose), my table was refreshed all nights, changed or delete id, pk, pkb and all stuff was too boring for me :)
BR
Jpeg
BR
Jpeg
10 years ago
3
Level 5
component will sync that...
85 Posts
10 years ago
2
Level 6
hum ! with CRON job ? you wake me up :)
Have a nice weekend
Jpeg
Have a nice weekend
Jpeg
10 years ago
0
Level 7
Yes, will have the possiblity to create id´s use use in cron call´s, that´s mandatory for corporate websites.
10 years ago
0
Level 7