No valid database connection

User avatar
chybo
.
Posts: 34
Joined: Sun Jan 27, 2008 10:55 am
Joomleague version: 0.93x
Location: Bembeltown
Contact:

No valid database connection

Postby chybo » Thu Mar 11, 2010 9:10 am

Wenn man im TopTipper Modul einen der Tipper anklickt, erscheint oberhalb der Ausgabe folgende Fehlermeldung:
No valid database connection 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 'AND project_id = 7' at line 3 SQL=SELECT id FROM jos_joomleague_rounds WHERE matchcode = AND project_id = 7
No valid database connection 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 ') AND tr.user_id = 151 GROUP BY tr.user_id ORDER BY point' at line 8 SQL=SELECT SUM(tp.point) AS points, SUM(tp.top) as top, SUM(tp.diff) as diff, SUM(tp.tend) as tend, count(tr.id) as tipps, SUM(tr.joker) as joker, tr.user_id FROM jos_joomleague_tip_results tr LEFT JOIN jos_joomleague_predictiongame_points tp ON tr.id=tp.tipp_id LEFT JOIN jos_joomleague_tip_members tm ON tm.user_id=tr.user_id and tm.project_id=tr.project_id LEFT JOIN jos_joomleague_matches m ON m.match_id = tr.match_id WHERE tr.project_id=7 AND tm.approved=1 AND m.round_id IN () AND tr.user_id = 151 GROUP BY tr.user_id ORDER BY points DESC, top DESC, diff DESC, tend DESC, tipps DESC


Der Fehler erscheint nur wenn man sich die Toptipper der Saison 2010 anschau wo noch kein Spiel ausgetragen wurde.

LINK zu TopTipper Saison 2009
LINK zu TopTipper Saison 2010

BASIC INFO
Joomla Version: 1.5.15
JoomLeague Version: 0.93
URL: www.universe-frankfurt.de

Return to “mod_joomleague_top_tipper”

Who is online

Users browsing this forum: No registered users and 1 guest

cron