Hi all,
latest Fabrik and Joomla
I get
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 'lines LEFT JOIN `products` AS `products` ON `products`.`id` = `lines`.`p_id` LE' at line 2</pre>
watch the part syntax to use near 'lines LEFT JOIN
there is no ` on both sides of listname lines, as there are on products...
Call stack
# Function Location
1 () JROOT/components/com_fabrik/models/list.php:930
2 FabrikFEModelList->getData() JROOT/components/com_fabrik/models/list.php:700
3 FabrikFEModelList->render() JROOT/components/com_fabrik/views/list/view.base.php:405
4 FabrikViewListBase->display() JROOT/components/com_fabrik/views/list/view.html.php:41
5 FabrikViewList->display() JROOT/libraries/joomla/cache/controller/view.php:98
6 JCacheControllerView->get() JROOT/components/com_fabrik/controllers/list.php:93
7 FabrikControllerList->display() JROOT/libraries/legacy/controller/legacy.php:709
8 JControllerLegacy->execute() JROOT/components/com_fabrik/fabrik.php:181
9 require_once() JROOT/libraries/cms/component/helper.php:389
10 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364
11 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191
12 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230
13 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265
14 JApplicationCms->execute() JROOT/index.php:49
latest Fabrik and Joomla
I get
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 'lines LEFT JOIN `products` AS `products` ON `products`.`id` = `lines`.`p_id` LE' at line 2</pre>
watch the part syntax to use near 'lines LEFT JOIN
there is no ` on both sides of listname lines, as there are on products...
Call stack
# Function Location
1 () JROOT/components/com_fabrik/models/list.php:930
2 FabrikFEModelList->getData() JROOT/components/com_fabrik/models/list.php:700
3 FabrikFEModelList->render() JROOT/components/com_fabrik/views/list/view.base.php:405
4 FabrikViewListBase->display() JROOT/components/com_fabrik/views/list/view.html.php:41
5 FabrikViewList->display() JROOT/libraries/joomla/cache/controller/view.php:98
6 JCacheControllerView->get() JROOT/components/com_fabrik/controllers/list.php:93
7 FabrikControllerList->display() JROOT/libraries/legacy/controller/legacy.php:709
8 JControllerLegacy->execute() JROOT/components/com_fabrik/fabrik.php:181
9 require_once() JROOT/libraries/cms/component/helper.php:389
10 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364
11 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191
12 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230
13 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265
14 JApplicationCms->execute() JROOT/index.php:49
Last edited: