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 = 45

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

found 78 debug messages

0.000052 - GLOBAL::include                          -> config.php
0.000274 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.dotDatabase.php
0.000326 - dotDatabase::getInstance                 -> connection: database
0.000351 - dotDatabase::__construct                 -> connection: database
0.000381 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.page.php
0.000416 - page::getInstance                        -> do
0.000461 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.dotSession.php
0.000492 - dotSession::getInstance                  -> do
0.000514 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.user.php
0.000560 - dotSession::start                        -> ---- init
0.000603 - dotSession::start                        -> start php session managment
0.000775 - dotSession::start                        -> finished php session management
0.000790 - dotSession::start                        -> save user and host information to new session_array
0.000811 - dotSession::start                        -> check for security options
0.001611 - dotSession::start                        -> lookup ip2country
0.001646 - dotDatabase::connect                     -> dotlan.app@5.75.134.22
0.016828 - dotDatabase::select                      -> database: dotlan_database
0.024533 - dotDatabase::query                       -> SELECT `code` FROM `country_ip2code` WHERE 221955853 BETWEEN ip_from AND ip_to
0.032445 - dotSession::start                        -> update current session online user infos
0.032507 - dotDatabase::query                       -> UPDATE session SET lastactivity = 1746451576, userid = 0, site = 'https://dev.switzerlan.ch/turnier/?do=teilnehmer&id=45', host = '13.58.199.13', dns = 'ec2-13-58-199-13.us-east-2.compute.amazonaws.com', countrycode = '', hits = hits + 1 WHERE hash = '9henaoot7sn3qou2hb00vq0oi0'
0.036918 - dotSession::start                        -> no session found in db == insert new db sesssion
0.036998 - dotDatabase::query                       -> INSERT INTO `session`SET hash = '9henaoot7sn3qou2hb00vq0oi0', lastactivity = 1746451576, userid = 0, site = 'https://dev.switzerlan.ch/turnier/?do=teilnehmer&id=45', referer = '', useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', host = '13.58.199.13', dns = 'ec2-13-58-199-13.us-east-2.compute.amazonaws.com', countrycode = '', hits = 1
0.042657 - dotSession::load_locales                 -> do
0.042737 - dotSession::load_locales                 -> chosing language for locales: en_US.UTF-8
0.042754 - dotSession::start                        -> ---- finished with session startup
0.042785 - dotSession::load_user                    -> id: 0
0.042798 - user::get_user                           -> id: >0<
0.042820 - dotDatabase::getInstance                 -> connection: database
0.042884 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.styles.php
0.042919 - styles::load                             -> name: ><
0.042945 - styles::load                             -> include: /var/www/html/swilan-dev/2024/www/html/templates/2024_switzerlan/styles/2024_switzerlan.php
0.043259 - styles::activate                         -> style = 2024_switzerlan
0.043472 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.admin.php
0.043513 - admin::getInstance                       -> do
0.043524 - dotSession::getInstance                  -> do
0.043536 - admin::__construct                       -> user_id=0
0.043546 - user::load_settings                      -> load current user settings to $global
0.043565 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.prvmsg.php
0.043594 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.event.php
0.043620 - EVENT::comming_event                     -> return
0.043637 - dotDatabase::query                       -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) > 1746451576 AND active=1 ORDER by begin ASC
0.048363 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.sitzplan.php
0.048425 - GLOBAL::end global.php                   -> ---------------------------------------------
0.048458 - TURNIER::main                            -> initialize 'turnier' system
0.048475 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.turnier.php
0.048529 - TURNIER::__construct                     -> init
0.048547 - TURNIER::main                            -> initialize 'turnier_teilnehmer_frontend' subsystem
0.048565 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.turniersub_teilnehmer_frontend.php
0.048598 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.turniersub_teilnehmer.php
0.048663 - TURNIER_TEILNEHMER_FRONTEND::__construct -> init
0.048673 - TURNIER_TEILNEHMER::__construct          -> init
0.048682 - TURNIER::__construct                     -> init
0.048706 - T_TEILNEHMER::teilnehmerliste            -> ID: 45
0.048718 - TURNIER::get_turnier                     -> ID: 45 (db)
0.048731 - 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='45'
0.053571 - TURNIER::load_system                     -> Turniermodus: double
0.053632 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.turniersystem_double.php
0.053696 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.turnier_tree.php
0.053820 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.html.php
0.053968 - dotDatabase::query                       -> SELECT COUNT(*) FROM t_contest WHERE tid=45
0.058762 - TURNIER::load_players_info               -> loading from db
0.058813 - dotCommon::classload                     -> require: /var/www/html/swilan-dev/2024/www/includes/class.cache.php
0.058866 - CACHE::get                               -> cache: >turnier_45::players_info< not found
0.058888 - 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=45
0.079510 - CACHE::set                               -> cache: >turnier_45::players_info< with ttl:3600
0.079900 - TURNIER::load_players_members            -> loading from db
0.079942 - CACHE::get                               -> cache: >turnier_45::players_members< not found
0.079957 - 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 = 45
0.084017 - dotDatabase::getInstance                 -> connection: Resource id #2
0.084058 - dotDatabase::__construct                 -> connection: Resource id #2
0.084079 - dotDatabase::disconnect                  -> do
0.084104 - page::getInstance                        -> do
0.084152 - PAGE::renderTemplate                     -> error_fatal
0.084169 - dotSession::getInstance                  -> do
0.084197 - PAGE::getHead                            -> return
0.084206 - dotSession::getInstance                  -> do
0.084391 - HTML::template                           -> template: >error_fatal<
0.084905 - PAGE::render_template                    -> final

PHP Includes   : 21
DB Queries     : 7
Rendering Time : 0.085566

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.turniersystem_double.php
 - /var/www/html/swilan-dev/2024/www/includes/class.turnier_tree.php
 - /var/www/html/swilan-dev/2024/www/includes/class.html.php
 - /var/www/html/swilan-dev/2024/www/includes/class.cache.php