BETA Lock and Load || Datenbank Fehler

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=7 AND user.plz=geodata.zip AND user.countrycode=geodata.countrycode AND bezahlt>0 GROUP by user.id

------------------- found 110 debug messages 0.000107 - GLOBAL::include -> config.php 0.000354 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.dotDatabase.php 0.000488 - dotDatabase::getInstance -> connection: database 0.000518 - dotDatabase::__construct -> connection: database 0.000551 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.page.php 0.000627 - page::getInstance -> do 0.000664 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.dotSession.php 0.000930 - dotSession::getInstance -> do 0.000987 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.user.php 0.001135 - dotSession::start -> ---- init 0.001192 - dotSession::start -> start php session managment 0.001417 - dotSession::start -> finished php session management 0.001438 - dotSession::start -> save user and host information to new session_array 0.001456 - dotSession::start -> check for security options 0.156618 - dotSession::start -> lookup ip2country 0.156684 - dotDatabase::connect -> laladmin_beta@localhost 0.157210 - dotDatabase::select -> database: db_intranet_beta 0.157416 - dotDatabase::query -> SELECT `code` FROM `country_ip2code` WHERE 3628718247 BETWEEN ip_from AND ip_to 0.157603 - dotSession::start -> update current session online user infos 0.157647 - dotDatabase::query -> UPDATE session SET lastactivity = 1757261052, userid = 0, site = 'https://www.beta.lockandload.ch/party/?do=map&id=7', host = '216.73.216.167', dns = '216.73.216.167', countrycode = 'US', hits = hits + 1 WHERE hash = 'nohfl2pr2q7mnghji2pfa86gh5' 0.157959 - dotSession::start -> no session found in db == insert new db sesssion 0.158008 - dotDatabase::query -> INSERT INTO `session`SET hash = 'nohfl2pr2q7mnghji2pfa86gh5', lastactivity = 1757261052, userid = 0, site = 'https://www.beta.lockandload.ch/party/?do=map&id=7', referer = '', useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', host = '216.73.216.167', dns = '216.73.216.167', countrycode = 'US', hits = 1 0.158753 - dotSession::load_locales -> do 0.158854 - dotSession::load_locales -> chosing language for locales: de_DE.UTF-8 0.158876 - dotSession::start -> ---- finished with session startup 0.158901 - dotSession::load_user -> id: 0 0.158917 - user::get_user -> id: >0< 0.158944 - dotDatabase::getInstance -> connection: database 0.159005 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.styles.php 0.159133 - styles::load -> name: >< 0.159166 - styles::load -> include: /var/www/html/beta.lockandload.ch/lockandload.ch/www/html/styles/lal-theme.php 0.159577 - styles::activate -> style = lal-theme 0.160036 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.admin.php 0.160165 - admin::getInstance -> do 0.160185 - dotSession::getInstance -> do 0.160202 - admin::__construct -> user_id=0 0.160217 - user::load_settings -> load current user settings to $global 0.160241 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.prvmsg.php 0.160309 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.event.php 0.160358 - EVENT::comming_event -> return 0.160386 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) > 1757261052 AND active=1 ORDER by begin ASC 0.161221 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) < 1757261052 AND active=1 ORDER by begin DESC LIMIT 1 0.161648 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.sitzplan.php 0.161813 - -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www//includes/custom.styles.php 0.161901 - styles::load -> name: >lal-theme< 0.161927 - styles::load -> include: /var/www/html/beta.lockandload.ch/lockandload.ch/www/html/styles/lal-theme.php 0.162340 - dotSession::getInstance -> do 0.162362 - admin::__construct -> user_id=0 0.162400 - admin::hasRight -> check for adminright: >0:0 & 1< FALSE 0.162457 - dotSession::getInstance -> do 0.162465 - admin::__construct -> user_id=0 0.162496 - admin::hasRight -> check for adminright: >0:0 & 1< FALSE 0.162547 - -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www//includes/custom.news.php 0.162645 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.news.php 0.162749 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.cbox.php 0.162835 - CBOX::news -> generate Box 0.162853 - NEWS::load_news -> load news data 0.162880 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.cache.php 0.162957 - CACHE::get -> cache: >news::stats< found 0.163019 - CACHE::get -> cache: >news::stats< has expired 0.163038 - CACHE::delete -> cache: >news::stats< 0.163573 - dotDatabase::query -> SELECT * FROM news_section WHERE urlshort IN ('') ORDER by urlshort ASC 0.163742 - dotDatabase::query -> SELECT COUNT(*) FROM news_post WHERE active = 1 AND dateline <= NOW() ORDER by dateline ASC 0.164175 - dotDatabase::query -> SELECT UNIX_TIMESTAMP(news_post.dateline) FROM news_post WHERE active = 1 AND dateline > NOW() ORDER by dateline ASC LIMIT 1 0.164512 - CACHE::set -> cache: >news::stats< with ttl:3600 0.164676 - CACHE::get -> cache: >news::news_limit2_page0< found 0.164737 - CACHE::get -> cache: >news::news_limit2_page0< has expired 0.164893 - CACHE::delete -> cache: >news::news_limit2_page0< 0.164989 - NEWS::load_news -> ... from database 0.165009 - dotDatabase::query -> SELECT news_post.id AS id, news_post.headline, news_post.content, news_post.short, news_post.user_id, news_post.encode, UNIX_TIMESTAMP(news_post.dateline) AS date_unix, news_post.comments, news_post.section_id, news_section.name AS section_name, news_section.short AS section_short, news_section.urlshort AS section_url, news_section.template, user.nick, user.vorname, user.nachname, user.countrycode FROM news_post LEFT JOIN news_section ON news_post.section_id = news_section.id LEFT JOIN user ON user.id = news_post.user_id WHERE news_post.active = 1 AND news_post.dateline <= NOW() ORDER by news_post.dateline DESC LIMIT 0,2 0.165698 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.html.php 0.165885 - HTML::encodeCms -> 0.166027 - HTML::encode -> BETA SEITE Nach der LAN ist vor der LAN: LOCK AND LOAD 12! ... 0.166063 - dotDatabase::query -> SELECT `code`, `smily` FROM html_smilies ORDER by LENGTH(code) DESC 0.166804 - dotDatabase::query -> SELECT codetag, codereplacement, twoparams FROM html_code 0.166998 - HTML::encode -> replace run 1 0.167084 - CACHE::set -> cache: >news::news_limit2_page0< with ttl:3600 0.167369 - HTML::template -> template: >box_news_bit< 0.167522 - HTML::template -> template: >box_news< 0.167625 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.user_frontend.php 0.167739 - USER_FUNCTIONS::login -> return 0.167761 - HTML::template -> template: >user_login_shortbar< 0.167931 - HTML::template -> template: >user_login< 0.168028 - HTML::template -> template: >user/user_registration< 0.168298 - USER_FUNCTIONS::password_reminder -> return 0.168335 - HTML::template -> template: >user_login_shortbar< 0.168404 - HTML::message -> generate Message: Hinweis 0.168422 - HTML::template -> template: >html_message< 0.168514 - GLOBAL::end global.php -> --------------------------------------------- 0.168551 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.event_frontend.php 0.168616 - EVENT::comming_event -> return 0.168634 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) > 1757261052 AND active=1 ORDER by begin ASC 0.168781 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) < 1757261052 AND active=1 ORDER by begin DESC LIMIT 1 0.168947 - EVENT_FRONTEND::map -> id >7< 0.168969 - EVENT::getevent -> id >7< 0.168984 - 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=7 AND active=1 0.169229 - GLOBAL::include -> custom.geomap.php 0.169363 - dotCommon::classload -> require: /var/www/html/beta.lockandload.ch/lockandload.ch/www/includes/class.geomap.php 0.169489 - dotDatabase::query -> SELECT COUNT(*) FROM geodata 0.170057 - CACHE::get -> cache: >event_7::map_lal-theme.de_DE< not found 0.170091 - 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=7 AND user.plz=geodata.zip AND user.countrycode=geodata.countrycode AND bezahlt>0 GROUP by user.id 0.170434 - dotDatabase::getInstance -> connection: Resource id #6 0.170503 - dotDatabase::__construct -> connection: Resource id #6 0.170567 - dotDatabase::disconnect -> do 0.170610 - page::getInstance -> do 0.170639 - PAGE::renderTemplate -> error_fatal 0.170658 - PAGE::getHead -> return 0.170669 - dotSession::getInstance -> do 0.170833 - HTML::template -> template: >error_fatal< 0.170990 - PAGE::render_template -> final PHP Includes : 26 DB Queries : 15 Rendering Time : 0.171883 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