When I create a user it is inpossible to let him work with Vaccount even if it is a super user. Anny idee
OS Linux g
PHP 5.4.29
MySQLi 5.5.37-35.1
Joomla 3.3.3
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 'group by i.id order by i.title asc' at line 1 SQL=select i.title, t.tdate as date, sum(t.amount) as amount from joom_vaccount_tran as i left join joom_vaccount_transaction as t on i.id=t.tid where i.types = "Expense" and t.gid = group by i.id order by i.title asc
Call stack
# Function Location
1 JApplicationCms->execute() /home3/bajan/public_html/portal/index.php:40
2 JApplicationSite->doExecute() /home3/bajan/public_html/portal/libraries/cms/application/cms.php:245
3 JApplicationSite->dispatch() /home3/bajan/public_html/portal/libraries/cms/application/site.php:224
4 JComponentHelper::renderComponent() /home3/bajan/public_html/portal/libraries/cms/application/site.php:178
5 JComponentHelper::executeComponent() /home3/bajan/public_html/portal/libraries/cms/component/helper.php:332
6 require_once() /home3/bajan/public_html/portal/libraries/cms/component/helper.php:352
7 JControllerLegacy->execute() /home3/bajan/public_html/portal/components/com_vaccount/vaccount.php:20
8 VaccountController->display() /home3/bajan/public_html/portal/libraries/legacy/controller/legacy.php:722
9 JControllerLegacy->display() /home3/bajan/public_html/portal/components/com_vaccount/controller.php:21
10 VaccountViewVaccount->display() /home3/bajan/public_html/portal/libraries/legacy/controller/legacy.php:685
11 JViewLegacy->get() /home3/bajan/public_html/portal/components/com_vaccount/views/vaccount/view.html.php:25
12 VaccountModelVaccount->getExpense() /home3/bajan/public_html/portal/libraries/legacy/view/legacy.php:398
13 JDatabaseDriver->loadObjectList() /home3/bajan/public_html/portal/components/com_vaccount/models/vaccount.php:73
14 JDatabaseDriverMysqli->execute() /home3/bajan/public_html/portal/libraries/joomla/database/driver.php:1281
