SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `live3_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC [1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `live3_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'memberquery' AND `Connection`.`published` = '1')"> Is there any tutorials on building a CCv5 to read a database? - Forums

Forums

Is there any tutorials on building a CCv5 to read a database?

RLaurel 17 Feb, 2014
I am looking for a tutorial on how to make a CCv5 connection to list items in a database I already have in place.

I have it working in CCv4, But in CCv5 I get Error: 0 with a list of the model.column_name together as SQL SELECT form in AS statements. That didn't change until I found the front permissions for myself, which I am a member of Super Users in Joomla! Groups.

I am missing some very basic stuff here. But the lack of documentation is not helping me either.

Also, in the front & admin permissions, "Not Set", "Allowed", "Inherited" & "Denied" are retrieved from where? Joomla! Groups? As a Super User, I thought I could not be blocked. Or is this the group permissions to the GRANT table in MySQLi?

Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `live3_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `live3_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'memberquery' AND `Connection`.`published` = '1'
)
GreyHead 19 Feb, 2014
Hi Rlaurel,

Do the CCv5 FAQs here help?

Bob
RLaurel 19 Feb, 2014
It did help me make my first Model. But adding more models so I can make multi-table joins, was completely absent.
This topic is locked and no more replies can be posted.