[AJFM/Bug] Rückrundentabelle Staffel A

[dAb]

Warning: mysqli_query(): (22003/1690): BIGINT UNSIGNED value is out of range in '(`ajuenger_fm_prod`.`p1`.`tore` - `ajuenger_fm_prod`.`p2`.`tore`)' in D:\data\apache\anstoss-juenger_de\fm\cms\db\cms.db.lib.php on line 106
#0 CMS\Datenbank\Database::StatementAbsetzenMitResultat2(SELECT p1.verein_id, v.ist_botverein, v.name_kurz, v.name_mittel, v.name_lang, v.wappen, sev.ist_meister, sev.ist_pokalsieger, sev.ist_aufsteiger, sev.ist_einsteiger, sev.ist_absteiger, sev1.ist_meister as wurde_meister, sev1.ist_aufsteiger as stieg_auf, sev1.ist_absteiger as stieg_ab, (sev1.ist_meister is null and sev.saison_id < floor(stat.wert/1000)) as stieg_aus, cast(p1.spiele as signed)-cast(p2.spiele as signed) as spiele, cast(p1.siege as signed)-cast(p2.siege as signed) as siege, cast(p1.unentschieden as signed)-cast(p2.unentschieden as signed) as unentschieden, cast(p1.niederlagen as signed)-cast(p2.niederlagen as signed) as niederlagen, cast(p1.tore as signed)-cast(p2.tore as signed) as tore, cast(p1.gegentore as signed)-cast(p2.gegentore as signed) as gegentore, cast(p1.tore-p2.tore as signed)-(cast(p1.gegentore-p2.gegentore as signed)) as diff, cast(p1.punkte as signed)-cast(p2.punkte as signed) as punkte FROM ajfm_ligaplatzierungen p1 INNER JOIN ajfm_ligaplatzierungen p2 ON p1.verein_id = p2.verein_id AND p1.saison_id = p2.saison_id AND p1.liga_id = p2.liga_id INNER JOIN ajfm_vereine v ON v.id = p1.verein_id INNER JOIN ajfm_saisoneigenschaften_vereine sev ON v.id = sev.verein_id AND sev.saison_id = p1.saison_id LEFT JOIN ajfm_saisoneigenschaften_vereine sev1 ON v.id = sev1.verein_id AND sev1.saison_id = p1.saison_id+1 INNER JOIN ajfm_status stat ON stat.einstellung = 'ajfm_datum' WHERE p1.liga_id = 8 AND p1.saison_id = 33 AND p1.spieltag = 21 AND p2.spieltag = 18 ORDER BY punkte DESC, diff DESC, tore DESC, 1) called at [D:\data\apache\anstoss-juenger_de\fm\module\AJFM\db\ligatabelle.db.php:460] #1 Modul\AJFM\Datenbank\LigaTabelleDb::TabelleZwischenZweiSpieltagenHolen2(8, 33, 19, 21, 0) called at [D:\data\apache\anstoss-juenger_de\fm\module\AJFM\db\ligatabelle.db.php:370] #2 Modul\AJFM\Datenbank\LigaTabelleDb::TabelleZwischenZweiSpieltagenHolen(8, 33, 19, 21) called at [D:\data\apache\anstoss-juenger_de\fm\module\AJFM\gui\statistiken\statistiken.gui.php:968] #3 Modul\AJFM\GUI\Statistiken::TabelleAnzeigen(8, 33, 21, 124, index.php?menu=10, , 1, , rueck) called at [D:\data\apache\anstoss-juenger_de\fm\module\AJFM\gui\statistiken\statistiken.gui.php:174] #4 Modul\AJFM\GUI\Statistiken::Anzeigen(aktuellestatistiken, tabellenspeziell, 1, 8, , 33, 21, 2, rueck, 124, , 124, 2, 30, 33, index.php?menu=10, ) called at [D:\data\apache\anstoss-juenger_de\fm\seiten\statistiken.php:170] #5 include(D:\data\apache\anstoss-juenger_de\fm\seiten\statistiken.php) called at [D:\data\apache\anstoss-juenger_de\fm\cms\cms.php:575] #6 CMS\CMS->InhaltAnzeigen() called at [D:\data\apache\anstoss-juenger_de\fm\Templates\Index.template.php:59] #7 include_once(D:\data\apache\anstoss-juenger_de\fm\Templates\Index.template.php) called at [D:\data\apache\anstoss-juenger_de\fm\cms\gui\CMS.gui.php:19] #8 CMS\GUI\CMSGUI::Anzeigen() called at [D:\data\apache\anstoss-juenger_de\fm\cms\cms.php:428] #9 CMS\CMS->SeiteAnzeigen() called at [D:\data\apache\anstoss-juenger_de\fm\index.php:9] #0 CMS\Datenbank\Database::StatementAbsetzenMitResultat2(SELECT p1.verein_id, v.ist_botverein, v.name_kurz, v.name_mittel, v.name_lang, v.wappen, sev.ist_meister, sev.ist_pokalsieger, sev.ist_aufsteiger, sev.ist_einsteiger, sev.ist_absteiger, sev1.ist_meister as wurde_meister, sev1.ist_aufsteiger as stieg_auf, sev1.ist_absteiger as stieg_ab, (sev1.ist_meister is null and sev.saison_id < floor(stat.wert/1000)) as stieg_aus, cast(p1.spiele as signed)-cast(p2.spiele as signed) as spiele, cast(p1.siege as signed)-cast(p2.siege as signed) as siege, cast(p1.unentschieden as signed)-cast(p2.unentschieden as signed) as unentschieden, cast(p1.niederlagen as signed)-cast(p2.niederlagen as signed) as niederlagen, cast(p1.tore as signed)-cast(p2.tore as signed) as tore, cast(p1.gegentore as signed)-cast(p2.gegentore as signed) as gegentore, cast(p1.tore-p2.tore as signed)-(cast(p1.gegentore-p2.gegentore as signed)) as diff, cast(p1.punkte as signed)-cast(p2.punkte as signed) as punkte FROM ajfm_ligaplatzierungen p1 INNER JOIN ajfm_ligaplatzierungen p2 ON p1.verein_id = p2.verein_id AND p1.saison_id = p2.saison_id AND p1.liga_id = p2.liga_id INNER JOIN ajfm_vereine v ON v.id = p1.verein_id INNER JOIN ajfm_saisoneigenschaften_vereine sev ON v.id = sev.verein_id AND sev.saison_id = p1.saison_id LEFT JOIN ajfm_saisoneigenschaften_vereine sev1 ON v.id = sev1.verein_id AND sev1.saison_id = p1.saison_id+1 INNER JOIN ajfm_status stat ON stat.einstellung = 'ajfm_datum' WHERE p1.liga_id = 8 AND p1.saison_id = 33 AND p1.spieltag = 21 AND p2.spieltag = 18 ORDER BY punkte DESC, diff DESC, tore DESC, 1) called at [D:\data\apache\anstoss-juenger_de\fm\module\AJFM\db\ligatabelle.db.php:460] #1 Modul\AJFM\Datenbank\LigaTabelleDb::TabelleZwischenZweiSpieltagenHolen2(8, 33, 19, 21, 0) called at [D:\data\apache\anstoss-juenger_de\fm\module\AJFM\db\ligatabelle.db.php:370] #2 Modul\AJFM\Datenbank\LigaTabelleDb::TabelleZwischenZweiSpieltagenHolen(8, 33, 19, 21) called at [D:\data\apache\anstoss-juenger_de\fm\module\AJFM\gui\statistiken\statistiken.gui.php:968] #3 Modul\AJFM\GUI\Statistiken::TabelleAnzeigen(8, 33, 21, 124, index.php?menu=10, , 1, , rueck) called at [D:\data\apache\anstoss-juenger_de\fm\module\AJFM\gui\statistiken\statistiken.gui.php:174] #4 Modul\AJFM\GUI\Statistiken::Anzeigen(aktuellestatistiken, tabellenspeziell, 1, 8, , 33, 21, 2, rueck, 124, , 124, 2, 30, 33, index.php?menu=10, ) called at [D:\data\apache\anstoss-juenger_de\fm\seiten\statistiken.php:170] #5 include(D:\data\apache\anstoss-juenger_de\fm\seiten\statistiken.php) called at [D:\data\apache\anstoss-juenger_de\fm\cms\cms.php:575] #6 CMS\CMS->InhaltAnzeigen() called at [D:\data\apache\anstoss-juenger_de\fm\Templates\Index.template.php:59] #7 include_once(D:\data\apache\anstoss-juenger_de\fm\Templates\Index.template.php) called at [D:\data\apache\anstoss-juenger_de\fm\cms\gui\CMS.gui.php:19] #8 CMS\GUI\CMSGUI::Anzeigen() called at [D:\data\apache\anstoss-juenger_de\fm\cms\cms.php:428] #9 CMS\CMS->SeiteAnzeigen() called at [D:\data\apache\anstoss-juenger_de\fm\index.php:9] Ungültige Abfrage: SELECT p1.verein_id, v.ist_botverein, v.name_kurz, v.name_mittel, v.name_lang, v.wappen, sev.ist_meister, sev.ist_pokalsieger, sev.ist_aufsteiger, sev.ist_einsteiger, sev.ist_absteiger, sev1.ist_meister as wurde_meister, sev1.ist_aufsteiger as stieg_auf, sev1.ist_absteiger as stieg_ab, (sev1.ist_meister is null and sev.saison_id < floor(stat.wert/1000)) as stieg_aus, cast(p1.spiele as signed)-cast(p2.spiele as signed) as spiele, cast(p1.siege as signed)-cast(p2.siege as signed) as siege, cast(p1.unentschieden as signed)-cast(p2.unentschieden as signed) as unentschieden, cast(p1.niederlagen as signed)-cast(p2.niederlagen as signed) as niederlagen, cast(p1.tore as signed)-cast(p2.tore as signed) as tore, cast(p1.gegentore as signed)-cast(p2.gegentore as signed) as gegentore, cast(p1.tore-p2.tore as signed)-(cast(p1.gegentore-p2.gegentore as signed)) as diff, cast(p1.punkte as signed)-cast(p2.punkte as signed) as punkte FROM ajfm_ligaplatzierungen p1 INNER JOIN ajfm_ligaplatzierungen p2 ON p1.verein_id = p2.verein_id AND p1.saison_id = p2.saison_id AND p1.liga_id = p2.liga_id INNER JOIN ajfm_vereine v ON v.id = p1.verein_id INNER JOIN ajfm_saisoneigenschaften_vereine sev ON v.id = sev.verein_id AND sev.saison_id = p1.saison_id LEFT JOIN ajfm_saisoneigenschaften_vereine sev1 ON v.id = sev1.verein_id AND sev1.saison_id = p1.saison_id+1 INNER JOIN ajfm_status stat ON stat.einstellung = 'ajfm_datum' WHERE p1.liga_id = 8 AND p1.saison_id = 33 AND p1.spieltag = 21 AND p2.spieltag = 18 ORDER BY punkte DESC, diff DESC, tore DESC
Fehler BIGINT UNSIGNED value is out of range in '(`ajuenger_fm_prod`.`p1`.`tore` - `ajuenger_fm_prod`.`p2`.`tore`)'

[Schappi]

Mit dem nächsten Update behoben