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'
)
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'
)
