Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Vaccount SQL error

More
3 years 2 weeks ago #387

Hello Sir,
Thanks for contacting us. We will provide you another vaccount package.

Thanks,
Support Team

Please Log in or Create an account to join the conversation.

  • bart janssen
  • bart janssen's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 2 weeks ago #386

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

Please Log in or Create an account to join the conversation.