New version of jAwards: v 0.5

When I click on "Information about the Awards" I get the error:
[code:1]DB function failed with error number 1064
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 'SELECT award, COUNT(*) AS count FROM jos_jawards_awards GROUP SQL=SELECT * FROM jos_jawards_medals AS a LEFT JOIN (SELECT award, COUNT(*) AS count FROM jos_jawards_awards GROUP BY award) AS c ON a.id=c.award ORDER BY a.name[/code:1]

Is that what you're looking for?

EDIT: I'm on 4.4.1, not 4.0.x :dry:

Post edited by: Sageth, at: 2006/04/13 01:19

Yes, that looks like the error.

But are you sure 4.4 is your MySQL version, and not PHP?
Because there seems to be no MySQL-version like that:

downloads.mysql.com/archives.php

Right i now get a probvlem i have a community of 3000 memebers and its going to be a hastle waiting for the drop down menu to appear everytime.

So i was wondering if the user selection could be streamlined?

maybe a text box to enter the user id .. or even username in please?

Good idea, I haven't thought of that

Can you submit this to the"Wishlist"-tracker at the Joomla-Forge? Else it's hard to keep track of all the wanted features...

hypnotoad wrote:

But are you sure 4.4 is your MySQL version, and not PHP?
Because there seems to be no MySQL-version like that.

Yeah, you're correct. I'm a dumbass who read the wrong line.

Sageth wrote:

When I click on "Information about the Awards" I get the error:
[code:1]DB function failed with error number 1064
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 'SELECT award, COUNT(*) AS count FROM jos_jawards_awards GROUP SQL=SELECT * FROM jos_jawards_medals AS a LEFT JOIN (SELECT award, COUNT(*) AS count FROM jos_jawards_awards GROUP BY award) AS c ON a.id=c.award ORDER BY a.name[/code:1]

Is that what you're looking for?

Yes, the error is now fixed!


I am glad to anounce that jAwards is now fully compatible to MySQL 4.0. There was a query with subquery in v 0.5, which is now replaced in v0.51 .

To have your jAwards-frontend working in MySQL 4.0, just re-install the fixed version of jAwards, or replace at .../
components/com_jawards/jawards.php lines 43-47 with:


[code:1]$query = "SELECT a.*, COUNT(b.award) AS count FROM #__jawards_medals AS a"
. " \n LEFT OUTER JOIN #__jawards_awards AS b"
. " \n ON a.id=b.award"
. " \n GROUP BY a.id"
. " \n ORDER BY a.name";[/code:1]