Home News Contact Us Forum About Us Joomla 1.0.x Demo Joomla 1.5 Demo Products
ARI Soft









Register   Lost Password?
Featured Demos

ARI Windows demo

ARI Quiz demo

ARI Tabs demo







e-mail: info@ari-soft.com
2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Shopping Cart
You currently have 0 items in your cart.
Show Cart


Recent Events
  • 25/08/2008 ARI Process Content module

    ARI Process Content module is available. Download it for free.

    Sometimes it is necessary to process content with plugins (formely mambots). Unfortunately Joomla! is limited to process plugin tags only for com_content component. What if you need, for example, to process the content of your own component or add some plugin tags to your module? ARI Process Content module will help with this. Read the full story .

    more...

  • 25/08/2008 ARI Smile component is available

    We are glad to inform about ARI Smile component availability. ARI Smile is a component that created to gather number of nice image slideshows. Slideshows are presented as modules. 5 slideshow types for now:

    * Cycling Images - creates image slideshow with cycling effect
    * Image menu - creates image slideshow with menu effect
    * Noob slide
    * Phafusion
    * Barack slidehow We plan to increase the number of available slideshows.

     

    Please see demo and review the component on Joomla! extensions directory.

    more...





FireBoard
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Joomla components ARI Quiz
Error message on Top User Section (1 viewing) (1) Guest
component
Go to bottom Post Reply Favoured: 0
TOPIC: Error message on Top User Section
#47
pgorrell (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Error message on Top User Section 2 Months ago Karma: 0  
We are getting the following message from the top users results module. Everything else seem to be working great. Any thoughts on why? This does not appear to be using any of the groups tables from Joomla core which would point to a JACL issue.

Invalid use of group function SQL=SELECT Q.QuizName, QSI.UserScore, (MAX(QSI.UserScore / QSI.MaxScore) * 100) AS PercentScore FROM jos_ariquizstatisticsinfo QSI INNER JOIN jos_ariquiz Q ON QSI.QuizId = Q.QuizId WHERE UserId = 83 AND QSI.Status = "Finished" AND Q.Status = 1 GROUP BY QSI.QuizId ORDER BY MAX(QSI.UserScore / QSI.MaxScore) DESC LIMIT 0,5No Pending Actions
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#48
admin (Admin)
Admin
Posts: 105
graph
User Online Now Click here to see the profile of this user
Re:Error message on Top User Section 2 Months ago Karma: 2  
What MySQL version are you using?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#49
pgorrell (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:Error message on Top User Section 2 Months ago Karma: 0  
We're using MySQL 4.1.22
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#50
admin (Admin)
Admin
Posts: 105
graph
User Online Now Click here to see the profile of this user
Re:Error message on Top User Section 2 Months ago Karma: 2  
Could you please try using MySQL 4.2 and above since it looks like MySQL 4.1.22 does not support this type of GROUP operator.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 
Useful Links
Products
Top Products
ARI Quiz
Work Unit
ARI Zoho presentation
ARI Thumbnail
ARI Windows
ARI Magnifier
ARI Smile
ARI Tabs
ARI Zoom
ARI Process Content
Help
Forum
Home | News | Contact Us | Forum | About Us | Joomla 1.0.x Demo | Joomla 1.5 Demo | Products
ARI Soft
License | Terms and Conditions | Copyright Info | Privacy Policy
 
ARI Soft
Copyright © 2008