Ein Datenbankfehler ist aufgetreten
DEBUG:Database Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
SELECT user.id, user.nick, user.clantag, user.plz, user.wohnort, lon, lat FROM event_teilnehmer, user, geodata WHERE event_teilnehmer.user_id=user.id AND event_teilnehmer.event_id=18 AND user.plz=geodata.zip AND user.countrycode=geodata.countrycode AND bezahlt>0 GROUP by user.id
------------------- found 95 debug messages 0.000108 - GLOBAL::include -> config.php 0.000378 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.dotDatabase.php 0.000492 - dotDatabase::getInstance -> connection: database 0.000519 - dotDatabase::__construct -> connection: database 0.000550 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.page.php 0.000651 - page::getInstance -> do 0.000684 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.dotSession.php 0.000745 - dotSession::getInstance -> do 0.000769 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.user.php 0.000887 - dotSession::start -> ---- init 0.000947 - dotSession::start -> start php session managment 0.001149 - dotSession::start -> finished php session management 0.001164 - dotSession::start -> save user and host information to new session_array 0.001180 - dotSession::start -> check for security options 0.217522 - dotSession::start -> lookup ip2country 0.217573 - dotDatabase::connect -> laladmin_beta@localhost 0.218081 - dotDatabase::select -> database: db_intranet_beta 0.218261 - dotDatabase::query -> SELECT `code` FROM `country_ip2code` WHERE 3628718202 BETWEEN ip_from AND ip_to 0.218402 - dotSession::start -> update current session online user infos 0.218449 - dotDatabase::query -> UPDATE session SET lastactivity = 1753654583, userid = 0, site = 'http://beta.lockandload.ch/party/?do=map&id=18', host = '216.73.216.122', dns = '216.73.216.122', countrycode = 'US', hits = hits + 1 WHERE hash = 'knka7ua3qqrmlvcvkhh60ik8a7' 0.218726 - dotSession::start -> no session found in db == insert new db sesssion 0.218783 - dotDatabase::query -> INSERT INTO `session`SET hash = 'knka7ua3qqrmlvcvkhh60ik8a7', lastactivity = 1753654583, userid = 0, site = 'http://beta.lockandload.ch/party/?do=map&id=18', referer = '', useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', host = '216.73.216.122', dns = '216.73.216.122', countrycode = 'US', hits = 1 0.219070 - dotSession::load_locales -> do 0.219146 - dotSession::load_locales -> chosing language for locales: de_DE.UTF-8 0.219162 - dotSession::start -> ---- finished with session startup 0.219189 - dotSession::load_user -> id: 0 0.219202 - user::get_user -> id: >0< 0.219225 - dotDatabase::getInstance -> connection: database 0.219276 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.styles.php 0.219382 - styles::load -> name: >< 0.219406 - styles::load -> include: /var/www/html/beta.lockandload.ch/lockandload.ch/www/html/styles/lal-theme.php 0.219766 - styles::activate -> style = lal-theme 0.220145 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.admin.php 0.220248 - admin::getInstance -> do 0.220262 - dotSession::getInstance -> do 0.220278 - admin::__construct -> user_id=0 0.220291 - user::load_settings -> load current user settings to $global 0.220314 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.prvmsg.php 0.220376 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.event.php 0.220437 - EVENT::comming_event -> return 0.220454 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) > 1753654583 AND active=1 ORDER by begin ASC 0.221010 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) < 1753654583 AND active=1 ORDER by begin DESC LIMIT 1 0.221415 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.sitzplan.php 0.221524 - -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www//includes/custom.styles.php 0.221598 - styles::load -> name: >lal-theme< 0.221620 - styles::load -> include: /var/www/html/beta.lockandload.ch/lockandload.ch/www/html/styles/lal-theme.php 0.222102 - dotSession::getInstance -> do 0.222123 - admin::__construct -> user_id=0 0.222160 - admin::hasRight -> check for adminright: >0:0 & 1< FALSE 0.222210 - dotSession::getInstance -> do 0.222221 - admin::__construct -> user_id=0 0.222236 - admin::hasRight -> check for adminright: >0:0 & 1< FALSE 0.222275 - -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www//includes/custom.news.php 0.222359 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.news.php 0.222429 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.cbox.php 0.222481 - CBOX::news -> generate Box 0.222491 - NEWS::load_news -> load news data 0.222507 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.cache.php 0.222552 - CACHE::get -> cache: >news::stats< found 0.222602 - CACHE::get -> cache: >news::news_limit2_page0< found 0.222636 - NEWS::load_news -> ... from cache 0.222649 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.html.php 0.222785 - HTML::template -> template: >box_news_bit< 0.222889 - HTML::template -> template: >box_news< 0.222949 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.user_frontend.php 0.223051 - USER_FUNCTIONS::login -> return 0.223064 - HTML::template -> template: >user_login_shortbar< 0.223130 - HTML::template -> template: >user_login< 0.223187 - HTML::template -> template: >user/user_registration< 0.223380 - USER_FUNCTIONS::password_reminder -> return 0.223405 - HTML::template -> template: >user_login_shortbar< 0.223458 - HTML::message -> generate Message: Hinweis 0.223471 - HTML::template -> template: >html_message< 0.223542 - GLOBAL::end global.php -> --------------------------------------------- 0.223588 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.event_frontend.php 0.223707 - EVENT::comming_event -> return 0.223726 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) > 1753654583 AND active=1 ORDER by begin ASC 0.223851 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) < 1753654583 AND active=1 ORDER by begin DESC LIMIT 1 0.223980 - EVENT_FRONTEND::map -> id >18< 0.223996 - EVENT::getevent -> id >18< 0.224010 - dotDatabase::query -> SELECT events.id, active, invite, password, events.name, anzahl, preis, konto, kontocheck, UNIX_TIMESTAMP(kontocheck) AS kontocheck_unix, event_location.name AS location, event_location.zip AS plz, event_location.city AS ort, event_location.street AS strasse, event_location.countrycode, location_id, map_template, allow_signoff, voraussetzung, minalter, turnier, netzwerk, weiteres, banner, UNIX_TIMESTAMP(begin) AS begin, UNIX_TIMESTAMP(end) AS end, UNIX_TIMESTAMP(signupbegin) AS sgbegin, UNIX_TIMESTAMP(signupend) AS sgend, UNIX_TIMESTAMP(seatreservebegin) AS seatbegin, UNIX_TIMESTAMP(seatreserveend) AS seatend, seatimage, UNIX_TIMESTAMP(canceled) AS canceled, archiv_gallery, archiv_media FROM events LEFT JOIN event_location ON event_location.id=location_id WHERE events.id=18 AND active=1 0.224246 - GLOBAL::include -> custom.geomap.php 0.226045 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.geomap.php 0.230858 - dotDatabase::query -> SELECT COUNT(*) FROM geodata 0.231594 - CACHE::get -> cache: >event_18::map_lal-theme.de_DE< not found 0.231634 - dotDatabase::query -> SELECT user.id, user.nick, user.clantag, user.plz, user.wohnort, lon, lat FROM event_teilnehmer, user, geodata WHERE event_teilnehmer.user_id=user.id AND event_teilnehmer.event_id=18 AND user.plz=geodata.zip AND user.countrycode=geodata.countrycode AND bezahlt>0 GROUP by user.id 0.232549 - dotDatabase::getInstance -> connection: Resource id #6 0.232658 - dotDatabase::__construct -> connection: Resource id #6 0.232712 - dotDatabase::disconnect -> do 0.232757 - page::getInstance -> do 0.232786 - PAGE::renderTemplate -> error_fatal 0.232804 - PAGE::getHead -> return 0.232811 - dotSession::getInstance -> do 0.233004 - HTML::template -> template: >error_fatal< 0.233658 - PAGE::render_template -> final PHP Includes : 26 DB Queries : 9 Rendering Time : 0.234137 Includes PHP Files: - /var/www/html/beta.lockandload.ch/lockandload.ch/www/party/index.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/global.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.dotCommon.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/config.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.dotDatabase.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.page.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.dotSession.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.user.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/tournament_v2/class.tv2_db.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.styles.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/html/styles/lal-theme.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/html/styles/default.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.admin.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.prvmsg.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.event.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.sitzplan.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/custom.styles.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/custom.news.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.news.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.cbox.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.cache.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.html.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.user_frontend.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.event_frontend.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/custom.geomap.php - /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.geomap.php