SwitzerLAN 2023 :: Database error

Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON t_teilnehmer_part.user_id = event_teilnehmer.user_id AND event_teilnehmer....' at line 1

SELECT t_teilnehmer.tnid, t_teilnehmer_part.user_id, user.nick, user.clan, user.vorname AS realname, user.vorname, user.nachname, event_teilnehmer.anwesend AS anwesend, user.homepage, user.countrycode, country_code2name.name AS countryname, IF( t_teilnehmer_part.user_id = t_teilnehmer.tnleader, 1, 0 ) AS is_leader, user.geb, user.avatar, NULL AS sitz_block, NULL AS sitz_id, NULL AS sitz_nr FROM t_teilnehmer RIGHT JOIN t_teilnehmer_part ON t_teilnehmer.tnid = t_teilnehmer_part.tnid LEFT JOIN user ON t_teilnehmer_part.user_id = user.id LEFT JOIN country_code2name ON country_code2name.code=user.countrycode LEFT JOIN event_teilnehmer ON ON t_teilnehmer_part.user_id = event_teilnehmer.user_id AND event_teilnehmer.event_id = 0 WHERE t_teilnehmer.tid = 195

 ------------------- 

found 75 debug messages

0.000039 - GLOBAL::include                          -> config.php
0.000210 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.dotDatabase.php
0.000249 - dotDatabase::getInstance                 -> connection: database
0.000268 - dotDatabase::__construct                 -> connection: database
0.000295 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.page.php
0.000322 - page::getInstance                        -> do
0.000347 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.dotSession.php
0.000370 - dotSession::getInstance                  -> do
0.000388 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.user.php
0.000422 - dotSession::start                        -> ---- init
0.000456 - dotSession::start                        -> start php session managment
0.000587 - dotSession::start                        -> finished php session management
0.000602 - dotSession::start                        -> check for security options
0.000619 - dotSession::start                        -> lookup ip2country
0.000633 - dotDatabase::connect                     -> dotlan.app@5.75.134.22
0.015856 - dotDatabase::select                      -> database: dotlan_database
0.023517 - dotDatabase::query                       -> SELECT `code` FROM `country_ip2code` WHERE 221955853 BETWEEN ip_from AND ip_to
0.031704 - dotSession::start                        -> update current session online user infos
0.031759 - dotDatabase::query                       -> UPDATE session SET lastactivity = 1746451576, userid = 0, site = 'https://dev.switzerlan.ch/turnier/?do=teilnehmer&id=195', host = '13.58.199.13', dns = '13.58.199.13', countrycode = '', hits = hits + 1 WHERE hash = 't6a18tp2hn6kpot9v1babb35g2'
0.037199 - dotSession::start                        -> session found in DB
0.037237 - dotSession::load_locales                 -> do
0.037280 - dotSession::load_locales                 -> chosing language for locales: en_US.UTF-8
0.037293 - dotSession::start                        -> ---- finished with session startup
0.037326 - dotSession::load_user                    -> id: 0
0.037340 - user::get_user                           -> id: >0<
0.037366 - dotDatabase::getInstance                 -> connection: database
0.037433 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.styles.php
0.037469 - styles::load                             -> name: ><
0.037494 - styles::load                             -> include: /var/www/html/swilan-dev/2024/www/html/templates/2024_switzerlan/styles/2024_switzerlan.php
0.037752 - styles::activate                         -> style = 2024_switzerlan
0.037983 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.admin.php
0.038015 - admin::getInstance                       -> do
0.038029 - dotSession::getInstance                  -> do
0.038048 - admin::__construct                       -> user_id=0
0.038062 - user::load_settings                      -> load current user settings to $global
0.038088 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.prvmsg.php
0.038129 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.event.php
0.038165 - EVENT::comming_event                     -> return
0.038186 - dotDatabase::query                       -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) > 1746451576 AND active=1 ORDER by begin ASC
0.042812 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.sitzplan.php
0.042886 - GLOBAL::end global.php                   -> ---------------------------------------------
0.042925 - TURNIER::main                            -> initialize 'turnier' system
0.042950 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.turnier.php
0.043005 - TURNIER::__construct                     -> init
0.043028 - TURNIER::main                            -> initialize 'turnier_teilnehmer_frontend' subsystem
0.043046 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.turniersub_teilnehmer_frontend.php
0.043078 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.turniersub_teilnehmer.php
0.043142 - TURNIER_TEILNEHMER_FRONTEND::__construct -> init
0.043150 - TURNIER_TEILNEHMER::__construct          -> init
0.043158 - TURNIER::__construct                     -> init
0.043187 - T_TEILNEHMER::teilnehmerliste            -> ID: 195
0.043215 - TURNIER::get_turnier                     -> ID: 195 (db)
0.043274 - dotDatabase::query                       -> SELECT *, tg.name AS group_name, tg.options AS group_options, UNIX_TIMESTAMP(tstart) AS unix_start, tadmins FROM t_turnier LEFT JOIN t_groups AS tg ON tg.id=t_turnier.tgroupid WHERE tid='195'
0.049742 - TURNIER::load_system                     -> Turniermodus:
0.049781 - TURNIER::load_system                     -> Modus not found
0.049801 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.html.php
0.049869 - dotDatabase::query                       -> SELECT COUNT(*) FROM t_contest WHERE tid=195
0.053941 - TURNIER::load_players_info               -> loading from db
0.053992 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.cache.php
0.054046 - CACHE::get                               -> cache: >turnier_195::players_info< not found
0.054066 - dotDatabase::query                       -> SELECT tnid, tnname AS name, user.id AS leader_id, user.nick AS leader_nick, user.clan AS leader_clan, user.vorname AS leader_realname, tnanz, tcheckedin, tnlogo, t_teilnehmer.homepage, t_teilnehmer.irc, t_teilnehmer.loser, t_teilnehmer.description, NULL AS sitz_block, NULL AS sitz_id, NULL AS sitz_nr, IF(t_teilnehmer.countrycode!='',t_teilnehmer.countrycode,user.countrycode) AS countrycode, IF(t_teilnehmer.countrycode!='',c2.name,c1.name) AS countryname FROM t_teilnehmer LEFT JOIN user ON t_teilnehmer.tnleader=user.id LEFT JOIN country_code2name AS c1 ON c1.code=user.countrycode LEFT JOIN country_code2name AS c2 ON c2.code=t_teilnehmer.countrycode WHERE t_teilnehmer.tid=195
0.059245 - CACHE::set                               -> cache: >turnier_195::players_info< with ttl:3600
0.059386 - TURNIER::load_players_members            -> loading from db
0.059535 - CACHE::get                               -> cache: >turnier_195::players_members< not found
0.059560 - dotDatabase::query                       -> SELECT t_teilnehmer.tnid, t_teilnehmer_part.user_id, user.nick, user.clan, user.vorname AS realname, user.vorname, user.nachname, event_teilnehmer.anwesend AS anwesend, user.homepage, user.countrycode, country_code2name.name AS countryname, IF( t_teilnehmer_part.user_id = t_teilnehmer.tnleader, 1, 0 ) AS is_leader, user.geb, user.avatar, NULL AS sitz_block, NULL AS sitz_id, NULL AS sitz_nr FROM t_teilnehmer RIGHT JOIN t_teilnehmer_part ON t_teilnehmer.tnid = t_teilnehmer_part.tnid LEFT JOIN user ON t_teilnehmer_part.user_id = user.id LEFT JOIN country_code2name ON country_code2name.code=user.countrycode LEFT JOIN event_teilnehmer ON ON t_teilnehmer_part.user_id = event_teilnehmer.user_id AND event_teilnehmer.event_id = 0 WHERE t_teilnehmer.tid = 195
0.063702 - dotDatabase::getInstance                 -> connection: Resource id #2
0.063743 - dotDatabase::__construct                 -> connection: Resource id #2
0.063769 - dotDatabase::disconnect                  -> do
0.063794 - page::getInstance                        -> do
0.063829 - PAGE::renderTemplate                     -> error_fatal
0.063842 - dotSession::getInstance                  -> do
0.063864 - PAGE::getHead                            -> return
0.063872 - dotSession::getInstance                  -> do
0.064042 - HTML::template                           -> template: >error_fatal<
0.064199 - PAGE::render_template                    -> final

PHP Includes   : 19
DB Queries     : 6
Rendering Time : 0.064658

Includes PHP Files: 
 - /var/www/html/swilan-dev/2024/www/turnier/index.php
 - /var/www/html/swilan-dev/2024/www/global.php
 - /var/www/html/swilan-dev/2024/www/includes/class.dotCommon.php
 - /var/www/html/swilan-dev/2024/www/config.php
 - /var/www/html/swilan-dev/2024/www/includes/class.dotDatabase.php
 - /var/www/html/swilan-dev/2024/www/includes/class.page.php
 - /var/www/html/swilan-dev/2024/www/includes/class.dotSession.php
 - /var/www/html/swilan-dev/2024/www/includes/class.user.php
 - /var/www/html/swilan-dev/2024/www/includes/class.styles.php
 - /var/www/html/swilan-dev/2024/www/html/templates/2024_switzerlan/styles/2024_switzerlan.php
 - /var/www/html/swilan-dev/2024/www/includes/class.admin.php
 - /var/www/html/swilan-dev/2024/www/includes/class.prvmsg.php
 - /var/www/html/swilan-dev/2024/www/includes/class.event.php
 - /var/www/html/swilan-dev/2024/www/includes/class.sitzplan.php
 - /var/www/html/swilan-dev/2024/www/includes/class.turnier.php
 - /var/www/html/swilan-dev/2024/www/includes/class.turniersub_teilnehmer_frontend.php
 - /var/www/html/swilan-dev/2024/www/includes/class.turniersub_teilnehmer.php
 - /var/www/html/swilan-dev/2024/www/includes/class.html.php
 - /var/www/html/swilan-dev/2024/www/includes/class.cache.php