Hi
Hoping someone can help here.
For some reason articles are not displaying in the manager at all although they are working on the front end. Works fine on my localhost but on my producttion server I am having this issue.
I just checked the error logs and I am getting the following error which I suspect is the issue.
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table class for class: quipComment
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table name for class: quipComment
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) No foreign key definition for parentClass: quipComment using relation alias: Author
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) No foreign key definition for parentClass: quipComment using relation alias: Resource
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table class for class: quipComment
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table name for class: quipComment
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table class for class: quipComment
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Could not get table name for class: quipComment
[2015-12-04 16:06:45] (ERROR @ /assets/components/quip/connector.php) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `ct` WHERE ( `ct`.`thread` = `quipComment`.`thread` AND ( `ct`.`deleted` = ' at line 1
)
[2015-12-04 16:06:45] (ERROR @ /assets/components/articles/connector.php) Could not get table class for class: quipComment
[2015-12-04 16:06:45] (ERROR @ /assets/components/articles/connector.php) Could not get table name for class: quipComment
[2015-12-04 16:06:45] (ERROR @ /assets/components/articles/connector.php) No foreign key definition for parentClass: quipComment using relation alias: Thread
[2015-12-04 16:06:45] (ERROR @ /assets/components/articles/connector.php) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `quipComment` JOIN `cc_quip_threads` `Thread` ON WHERE Thread.resource = Art' at line 1
)
I am running revolution 2.4.2 and the latest version of articles. Completely stuck on this one - all help gratefully received.