[SQL] MySQL Problem bei CMS installation.

Dieses Thema im Forum "Webentwicklung" wurde erstellt von Schlotti, 4. Oktober 2011 .

Schlagworte:
  1. 4. Oktober 2011
    MySQL Problem bei CMS installation.

    Hallo Leute,

    Wie es schon im Titel steht habe ich ein Problem bei einer Installation von einen CMS.
    Das Problem ist das keine Datenbaken Tabellen erstellt werden wenn ich das CMS installiere.

    Das CMS wird auch nicht mehr richtig supportet, über google habe ich kaum etwas gefunden
    und in ein anderes Forum hatte jemand geschrieben, dass man sich etwas mit MySQL auskennen sollte wenn man es zum laufen bringen will.

    Nur ich habe leider kaum MySQL Kenntnisse und brauche etwas Hilfe...
    Mit HTML & PHP kenne ich mich aus bzw. die Grundkenntnisse, nur SQL leider null.

    Bei Google finde ich leider nichts was mir bei meinem Problem hilft.


    Hier sind die Tabellen die erstellt werden müssen:

    Code:
    CREATE TABLE IF NOT EXISTS `adodb_logsql` (created datetime NULL, sql0 varchar(250) NULL, sql1 text NULL, params text NULL, tracer text NULL, timer decimal(16,6) NULL)
CREATE TABLE IF NOT EXISTS {prefix}_article ( id_article INTEGER(11) NULL AUTO_INCREMENT, id_user INTEGER(11) NULL, league INTEGER(11) NULL, id_season INTEGER(11) NULL, added DATETIME NULL, visible CHAR(1) NULL, comments CHAR(1) NULL, title VARCHAR(30) NULL, content TEXT NULL, PRIMARY KEY(id_article))
CREATE TABLE IF NOT EXISTS {prefix}_award ( id_award INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, award_name CHAR(25) NULL, award_extension CHAR(5) NULL, grade SMALLINT(6) NULL, PRIMARY KEY(id_award))
CREATE TABLE IF NOT EXISTS {prefix}_ban ( id_ban INTEGER UNSIGNED NULL AUTO_INCREMENT, ip CHAR(50) NULL, ban_type CHAR(1) NULL, ban_limit DATE NULL, PRIMARY KEY(id_ban))
CREATE TABLE IF NOT EXISTS {prefix}_category ( id_category INTEGER(11) NULL AUTO_INCREMENT, category_main INTEGER(11) NULL, category_alias CHAR(20) NULL, category_name CHAR(50) NULL, category_extension CHAR(5) NULL, category_type CHAR(20) NULL, category_template CHAR(5) NULL, category_limit SMALLINT UNSIGNED NULL, category_season CHAR(1) NULL, PRIMARY KEY(id_category))
CREATE TABLE IF NOT EXISTS {prefix}_category_item ( id_category INTEGER(11) NULL, item_id INTEGER UNSIGNED NULL)
CREATE TABLE IF NOT EXISTS {prefix}_comment ( id_comment INTEGER(11) NULL AUTO_INCREMENT, id_user INTEGER(11) NULL, added DATETIME NULL, content TEXT NULL, ip VARCHAR(15) NULL, modified DATETIME NULL, item CHAR(20) NULL, league INTEGER(11) NULL, item_id INTEGER(11) NULL, PRIMARY KEY(id_comment), INDEX iduser(id_user))
CREATE TABLE IF NOT EXISTS {prefix}_config ( league INTEGER(11) NULL AUTO_INCREMENT, league_type CHAR(1) NULL, league_visible CHAR(1) NULL, league_name CHAR(50) NULL, league_address CHAR(100) NULL, league_irc CHAR(50) NULL, league_skin CHAR(50) NULL, league_language CHAR(20) NULL, league_show_flag CHAR(1) NULL, score_type CHAR(1) NULL, score_details CHAR(1) NULL, match_limit_group SMALLINT(6) NULL, team_limit SMALLINT UNSIGNED NULL, player_transfer CHAR(1) NULL, player_limit SMALLINT(6) NULL, player_type CHAR(1) NULL, signup_status CHAR(1) NULL, signup_limit_time DATETIME NULL, signup_limit_team SMALLINT(6) NULL, penalty_standard CHAR(1) NULL, poll_live_time SMALLINT(1) NULL, roster_dispute_after SMALLINT(6) NULL, roster_dispute_before SMALLINT(6) NULL, logo_small CHAR(5) NULL, logo_big CHAR(5) NULL, forum_type CHAR(20) NULL, forum_prefix CHAR(20) NULL, block_ident CHAR(1) NULL, PRIMARY KEY(league))
CREATE TABLE IF NOT EXISTS {prefix}_config_mod ( mod_name CHAR(30) NOT NULL, var_name CHAR(15) NOT NULL, var_value CHAR(30) NULL, PRIMARY KEY(mod_name, var_name))
INSERT INTO {prefix}_config_mod (mod_name, var_name, var_value) VALUES("kml", "version", "2.1.2")
CREATE TABLE IF NOT EXISTS {prefix}_demo_sa ( idd INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, idm INTEGER(11) NULL, link CHAR(100) NULL, map CHAR(30) NULL, pov CHAR(15) NULL, dtime INTEGER(11) NULL, extension CHAR(5) NULL, PRIMARY KEY(idd))
CREATE TABLE IF NOT EXISTS {prefix}_field ( id_field INTEGER(11) NULL AUTO_INCREMENT, db_table CHAR(20) NULL, field_name CHAR(20) NULL, field_type CHAR(15) NULL, visible CHAR(1) NULL, header CHAR(50) NULL, header_lang CHAR(50) NULL, order_row SMALLINT(6) NULL, order_section SMALLINT(6) NULL, answer TEXT NULL, answer_lang TEXT NULL, value_unique CHAR(1) NULL, value_required CHAR(1) NULL, value_change CHAR(1) NULL, value_log CHAR(1) NULL, value_default CHAR(50) NULL, value_create CHAR(1) NULL, field_search CHAR(1) NULL, field_list CHAR(1) NULL, field_important CHAR(1) NULL, field_auto_display CHAR(1) NULL, field_display CHAR(5) NULL, extra1 CHAR(200) NULL, extra2 CHAR(200) NULL, PRIMARY KEY(id_field))
CREATE TABLE IF NOT EXISTS {prefix}_field_league ( id_field INTEGER(11) NULL, league INTEGER(11) NULL, PRIMARY KEY(id_field, league))
CREATE TABLE IF NOT EXISTS {prefix}_field_log ( id_field INTEGER(11) NULL, field_value CHAR(250) NULL, field_key INTEGER(11) NULL, added DATETIME NULL, added_by INTEGER(11) NULL, ip CHAR(15) NULL)
CREATE TABLE IF NOT EXISTS {prefix}_game_server ( id_server INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, game_server_name CHAR(50) NULL, address CHAR(50) NULL, PRIMARY KEY(id_server))
CREATE TABLE IF NOT EXISTS {prefix}_group (id_group INTEGER(11) NOT NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, group_type CHAR(5) NULL, group_name CHAR(20) NULL, group_phase SMALLINT(6) NULL, teams SMALLINT(6) UNSIGNED NULL, best_place SMALLINT(6) UNSIGNED NULL, PRIMARY KEY(id_group))
CREATE TABLE IF NOT EXISTS {prefix}_group_round ( id_gr_ro INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, id_group INTEGER(11) NULL, rnd SMALLINT(6) NULL, descr CHAR(50) NULL, PRIMARY KEY(id_gr_ro))
CREATE TABLE IF NOT EXISTS {prefix}_map ( id_map INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, name_short CHAR(20) NULL, name_full CHAR(50) NULL, screen CHAR(40) NULL, screen_descr CHAR(200) NULL, PRIMARY KEY(id_map))
CREATE TABLE IF NOT EXISTS {prefix}_match ( id_match INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, judge INTEGER(11) NULL, match_date DATETIME NULL, roster_from DATETIME NULL, roster_to DATETIME NULL, roster CHAR(1) NULL, id_group INTEGER(11) NULL, pos SMALLINT(6) NULL, rnd TINYINT(3) UNSIGNED NULL, id_team1 INTEGER(11) NULL, id_team2 INTEGER(11) NULL, match_type CHAR(20) NULL, points1 SMALLINT(6) NULL, points2 SMALLINT(6) NULL, frags1 SMALLINT(5) NULL, frags2 SMALLINT(5) NULL, win1 SMALLINT(6) NULL, draw SMALLINT(6) NULL, win2 SMALLINT(6) NULL, descr TEXT NULL, game_server CHAR(50) NULL, PRIMARY KEY(id_match))
CREATE TABLE IF NOT EXISTS {prefix}_match_map ( id_ma_ma INTEGER(11) NULL AUTO_INCREMENT, id_match INTEGER(11) NULL, match_map CHAR(20) NULL, frags1 SMALLINT(6) NULL, frags2 SMALLINT(6) NULL, wo INTEGER(11) NULL, played CHAR(1) NULL, PRIMARY KEY(id_ma_ma))
CREATE TABLE IF NOT EXISTS {prefix}_match_score_details ( id_ma_ma INTEGER(11) NULL, period CHAR(1) NULL, frags1 SMALLINT(6) NULL, frags2 SMALLINT(6) NULL)
CREATE TABLE IF NOT EXISTS {prefix}_menu ( id_menu INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, visible CHAR(1) NULL, permission_global SMALLINT(6) NULL, permission_local SMALLINT(6) NULL, head_text CHAR(30) NULL, head_lang CHAR(30) NULL, link CHAR(80) NULL, link_target CHAR(1) NULL, link_local CHAR(1) NULL, sort_column SMALLINT(6) NULL, sort_row SMALLINT(6) NULL, PRIMARY KEY(id_menu))
CREATE TABLE IF NOT EXISTS {prefix}_penalty_standard ( id_penalty INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, grade SMALLINT(6) NULL, frags SMALLINT(6) NULL, points SMALLINT(6) NULL, PRIMARY KEY(id_penalty))
CREATE TABLE IF NOT EXISTS {prefix}_player ( id_player INTEGER(11) NULL AUTO_INCREMENT, id_team INTEGER(11) NULL, id_user INTEGER(11) NULL, approve_user CHAR(1) NULL, invite_by INTEGER(11) NULL, player_name CHAR(20) NULL, contact CHAR(60) NULL, ident CHAR(30) NULL, grade CHAR(1) NULL, other CHAR(20) NULL, added DATETIME NULL, added_by INTEGER UNSIGNED NULL, PRIMARY KEY(id_player))
CREATE TABLE IF NOT EXISTS {prefix}_player_league ( id_player INTEGER(11) NULL, league INTEGER(11) NULL, PRIMARY KEY(id_player, league))
CREATE TABLE IF NOT EXISTS {prefix}_player_stats ( id_pl_st INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, id_player INTEGER(11) NULL, id_match INTEGER(11) NULL, id_ma_ma INTEGER(11) NULL, frags INTEGER(11) NULL, deaths INTEGER(11) NULL, map_number SMALLINT(6) NULL, PRIMARY KEY(id_pl_st))
CREATE TABLE IF NOT EXISTS {prefix}_pm ( id_pm INTEGER(11) NULL AUTO_INCREMENT, id_author INTEGER(11) NULL, id_receiver INTEGER(11) NULL, added DATETIME NULL, title CHAR(50) NULL, content TEXT NULL, ip VARCHAR(15) NULL, receiver_status CHAR(1) NULL, author_status CHAR(1) NULL, PRIMARY KEY(id_pm))
CREATE TABLE IF NOT EXISTS {prefix}_points_standard ( id_po_st INTEGER(11) NOT NULL AUTO_INCREMENT, league INTEGER(11) NULL, score1 CHAR(5) NULL, draw CHAR(5) NULL, score2 CHAR(5) NULL, points1 SMALLINT(6) NULL, points2 SMALLINT(6) NULL, PRIMARY KEY(id_po_st))
CREATE TABLE IF NOT EXISTS {prefix}_poll ( id_poll INTEGER(11) NULL AUTO_INCREMENT, question CHAR(100) NULL, active CHAR(1) NULL, active_to DATETIME NULL, active_from DATETIME NULL, league INTEGER(11) NULL, PRIMARY KEY(id_poll))
CREATE TABLE IF NOT EXISTS {prefix}_poll_answer ( id_po_an INTEGER(11) NULL AUTO_INCREMENT, id_poll INTEGER(11) NULL, answer CHAR(50) NULL, PRIMARY KEY(id_po_an))
CREATE TABLE IF NOT EXISTS {prefix}_poll_choice ( id_user INTEGER(11) NULL, id_po_an INTEGER(11) NULL)
CREATE TABLE IF NOT EXISTS {prefix}_screen ( idn INTEGER(11) UNSIGNED NULL AUTO_INCREMENT, league INTEGER(11) NULL, idm INTEGER(11) UNSIGNED NULL, idmm INTEGER(11) NULL, map CHAR(20) NULL, screen_name INTEGER(15) NULL, screen_hash CHAR(3) NULL, PRIMARY KEY(idn))
CREATE TABLE IF NOT EXISTS {prefix}_season ( id_season INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, season_name CHAR(50) NULL, descr CHAR(50) NULL, PRIMARY KEY(id_season))
CREATE TABLE IF NOT EXISTS {prefix}_table ( id_table INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_team INTEGER(11) NULL, id_group INTEGER(11) NULL, points SMALLINT(6) NULL, frags SMALLINT(5) NULL, deaths SMALLINT(5) NULL, wins SMALLINT(6) NULL, draw SMALLINT(6) NULL, lost SMALLINT(6) NULL, map_win SMALLINT(6) NULL, map_draw SMALLINT(6) NULL, map_lost SMALLINT(6) NULL, PRIMARY KEY(id_table))
CREATE TABLE IF NOT EXISTS {prefix}_table_penalty ( id_ta_pe INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_table INTEGER(11) NULL, frags SMALLINT(6) NULL, points SMALLINT(6) NULL, PRIMARY KEY(id_ta_pe))
CREATE TABLE IF NOT EXISTS {prefix}_team ( id_team INTEGER(11) NULL AUTO_INCREMENT, id_main_team INTEGER(11) NULL, team_name CHAR(30) NULL, tag VARCHAR(15) NULL, www CHAR(50) NULL, registered DATETIME NULL, info CHAR(250) NULL, active CHAR(1) NULL, team_country CHAR(10) NULL, irc_channel CHAR(50) NULL, logo CHAR(5) NULL, id_user INTEGER(11) NULL, team_pass CHAR(32) NULL, team_type CHAR(1) NULL, PRIMARY KEY(id_team))
CREATE TABLE IF NOT EXISTS {prefix}_team_award ( id_te_aw INTEGER(11) NULL AUTO_INCREMENT, id_award INTEGER(11) NULL, league INTEGER(11) NULL, id_team INTEGER(11) NULL, id_season INTEGER(11) NULL, PRIMARY KEY(id_te_aw))
CREATE TABLE IF NOT EXISTS {prefix}_team_league ( league INTEGER(11) NULL, id_team INTEGER(11) NULL, PRIMARY KEY(league, id_team))
CREATE TABLE IF NOT EXISTS {prefix}_team_signup ( id_season INTEGER(11) NULL, league INTEGER(11) NULL, id_user INTEGER(11) NULL, id_team INTEGER(11) NULL)
CREATE TABLE IF NOT EXISTS {prefix}_team_wildcard ( id_te_wi INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, id_team INTEGER(11) NULL, PRIMARY KEY(id_te_wi))
CREATE TABLE IF NOT EXISTS {prefix}_user ( id_user INTEGER(11) NULL AUTO_INCREMENT, login VARCHAR(15) NULL, pass VARCHAR(32) NULL, mail VARCHAR(60) NULL, permission SMALLINT(6) NULL, added DATETIME NULL, lastlog DATETIME NULL, user_name CHAR(50) NULL, birth DATE NULL, team CHAR(30) NULL, team_www CHAR(50) NULL, home_www CHAR(50) NULL, city VARCHAR(40) NULL, info TINYTEXT NULL, mail_show CHAR(1) NULL, user_country CHAR(10) NULL, comm_icq CHAR(30) NULL, comm_msn CHAR(30) NULL, timezone SMALLINT(6) NULL, send_pm_mail CHAR(1) NULL, ip CHAR(15) NULL, avatar CHAR(5) NULL, auth CHAR(32) NULL, PRIMARY KEY(id_user), INDEX login(login))
CREATE TABLE IF NOT EXISTS {prefix}_user_invitation ( id_user INTEGER(11) NULL, id_team INTEGER(11) NULL, PRIMARY KEY(id_user, id_team))
CREATE TABLE IF NOT EXISTS {prefix}_user_online ( added DATETIME NULL, ip CHAR(15) NULL, id_user INTEGER(11) NULL, league INTEGER(11) NULL)
CREATE TABLE IF NOT EXISTS {prefix}_user_pass ( id_user INTEGER(11) NULL, pass VARCHAR(32) NULL, added INTEGER(15) NULL, auth VARCHAR(32) NULL, ip CHAR(15) NULL)
CREATE TABLE IF NOT EXISTS {prefix}_user_permission ( id_user INTEGER(11) NULL, permission SMALLINT(6) NULL, descr CHAR(50) NULL, league INTEGER(11) NULL)
    P.S.: Das ist eine Art Liga/League/Cup Script, ein paar Freunde & ich möchten gerne ein private Liga erstellen wo nur reale Freunde spielen, es soll also kein ESL Clone o.a. werden.
     
    + Multi-Zitat Zitieren
  3. 4. Oktober 2011
    AW: MySQL Problem bei CMS installation.

    Hey,

    hat der Benutzer mit dem du die Tabellen erstellen willst ausreichend Rechte? Ansonsten füge den unten geposteten Teil man manuell ein. Allerdings musst du vorher "{prefix}" durch das von die bei der Installation gewählte Tabellen-Prefix ersetzen, sonst gibt das keinen


    Gruß Blackb!rd
     
    + Multi-Zitat Zitieren
  4. 4. Oktober 2011
    AW: MySQL Problem bei CMS installation.

    Hallo,
    Ja ausreichend Rechte hat MySQL, die CHMOD Rechte stimmen auch (0777).
    Manuell habe ich es auch schon versucht, so wie du gesgat hast, aber habe es nochmal probiert:

    Code:
    CREATE TABLE IF NOT EXISTS `adodb_logsql` (created datetime NULL, sql0 varchar(250) NULL, sql1 text NULL, params text NULL, tracer text NULL, timer decimal(16,6) NULL)
CREATE TABLE IF NOT EXISTS league_article ( id_article INTEGER(11) NULL AUTO_INCREMENT, id_user INTEGER(11) NULL, league INTEGER(11) NULL, id_season INTEGER(11) NULL, added DATETIME NULL, visible CHAR(1) NULL, comments CHAR(1) NULL, title VARCHAR(30) NULL, content TEXT NULL, PRIMARY KEY(id_article))
CREATE TABLE IF NOT EXISTS league_award ( id_award INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, award_name CHAR(25) NULL, award_extension CHAR(5) NULL, grade SMALLINT(6) NULL, PRIMARY KEY(id_award))
CREATE TABLE IF NOT EXISTS league_ban ( id_ban INTEGER UNSIGNED NULL AUTO_INCREMENT, ip CHAR(50) NULL, ban_type CHAR(1) NULL, ban_limit DATE NULL, PRIMARY KEY(id_ban))
CREATE TABLE IF NOT EXISTS league_category ( id_category INTEGER(11) NULL AUTO_INCREMENT, category_main INTEGER(11) NULL, category_alias CHAR(20) NULL, category_name CHAR(50) NULL, category_extension CHAR(5) NULL, category_type CHAR(20) NULL, category_template CHAR(5) NULL, category_limit SMALLINT UNSIGNED NULL, category_season CHAR(1) NULL, PRIMARY KEY(id_category))
CREATE TABLE IF NOT EXISTS league_category_item ( id_category INTEGER(11) NULL, item_id INTEGER UNSIGNED NULL)
CREATE TABLE IF NOT EXISTS league_comment ( id_comment INTEGER(11) NULL AUTO_INCREMENT, id_user INTEGER(11) NULL, added DATETIME NULL, content TEXT NULL, ip VARCHAR(15) NULL, modified DATETIME NULL, item CHAR(20) NULL, league INTEGER(11) NULL, item_id INTEGER(11) NULL, PRIMARY KEY(id_comment), INDEX iduser(id_user))
CREATE TABLE IF NOT EXISTS league_config ( league INTEGER(11) NULL AUTO_INCREMENT, league_type CHAR(1) NULL, league_visible CHAR(1) NULL, league_name CHAR(50) NULL, league_address CHAR(100) NULL, league_irc CHAR(50) NULL, league_skin CHAR(50) NULL, league_language CHAR(20) NULL, league_show_flag CHAR(1) NULL, score_type CHAR(1) NULL, score_details CHAR(1) NULL, match_limit_group SMALLINT(6) NULL, team_limit SMALLINT UNSIGNED NULL, player_transfer CHAR(1) NULL, player_limit SMALLINT(6) NULL, player_type CHAR(1) NULL, signup_status CHAR(1) NULL, signup_limit_time DATETIME NULL, signup_limit_team SMALLINT(6) NULL, penalty_standard CHAR(1) NULL, poll_live_time SMALLINT(1) NULL, roster_dispute_after SMALLINT(6) NULL, roster_dispute_before SMALLINT(6) NULL, logo_small CHAR(5) NULL, logo_big CHAR(5) NULL, forum_type CHAR(20) NULL, forum_prefix CHAR(20) NULL, block_ident CHAR(1) NULL, PRIMARY KEY(league))
CREATE TABLE IF NOT EXISTS league_config_mod ( mod_name CHAR(30) NOT NULL, var_name CHAR(15) NOT NULL, var_value CHAR(30) NULL, PRIMARY KEY(mod_name, var_name))
INSERT INTO league_config_mod (mod_name, var_name, var_value) VALUES("kml", "version", "2.1.2")
CREATE TABLE IF NOT EXISTS league_demo_sa ( idd INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, idm INTEGER(11) NULL, link CHAR(100) NULL, map CHAR(30) NULL, pov CHAR(15) NULL, dtime INTEGER(11) NULL, extension CHAR(5) NULL, PRIMARY KEY(idd))
CREATE TABLE IF NOT EXISTS league_field ( id_field INTEGER(11) NULL AUTO_INCREMENT, db_table CHAR(20) NULL, field_name CHAR(20) NULL, field_type CHAR(15) NULL, visible CHAR(1) NULL, header CHAR(50) NULL, header_lang CHAR(50) NULL, order_row SMALLINT(6) NULL, order_section SMALLINT(6) NULL, answer TEXT NULL, answer_lang TEXT NULL, value_unique CHAR(1) NULL, value_required CHAR(1) NULL, value_change CHAR(1) NULL, value_log CHAR(1) NULL, value_default CHAR(50) NULL, value_create CHAR(1) NULL, field_search CHAR(1) NULL, field_list CHAR(1) NULL, field_important CHAR(1) NULL, field_auto_display CHAR(1) NULL, field_display CHAR(5) NULL, extra1 CHAR(200) NULL, extra2 CHAR(200) NULL, PRIMARY KEY(id_field))
CREATE TABLE IF NOT EXISTS league_field_league ( id_field INTEGER(11) NULL, league INTEGER(11) NULL, PRIMARY KEY(id_field, league))
CREATE TABLE IF NOT EXISTS league_field_log ( id_field INTEGER(11) NULL, field_value CHAR(250) NULL, field_key INTEGER(11) NULL, added DATETIME NULL, added_by INTEGER(11) NULL, ip CHAR(15) NULL)
CREATE TABLE IF NOT EXISTS league_game_server ( id_server INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, game_server_name CHAR(50) NULL, address CHAR(50) NULL, PRIMARY KEY(id_server))
CREATE TABLE IF NOT EXISTS league_group (id_group INTEGER(11) NOT NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, group_type CHAR(5) NULL, group_name CHAR(20) NULL, group_phase SMALLINT(6) NULL, teams SMALLINT(6) UNSIGNED NULL, best_place SMALLINT(6) UNSIGNED NULL, PRIMARY KEY(id_group))
CREATE TABLE IF NOT EXISTS league_group_round ( id_gr_ro INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, id_group INTEGER(11) NULL, rnd SMALLINT(6) NULL, descr CHAR(50) NULL, PRIMARY KEY(id_gr_ro))
CREATE TABLE IF NOT EXISTS league_map ( id_map INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, name_short CHAR(20) NULL, name_full CHAR(50) NULL, screen CHAR(40) NULL, screen_descr CHAR(200) NULL, PRIMARY KEY(id_map))
CREATE TABLE IF NOT EXISTS league_match ( id_match INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, judge INTEGER(11) NULL, match_date DATETIME NULL, roster_from DATETIME NULL, roster_to DATETIME NULL, roster CHAR(1) NULL, id_group INTEGER(11) NULL, pos SMALLINT(6) NULL, rnd TINYINT(3) UNSIGNED NULL, id_team1 INTEGER(11) NULL, id_team2 INTEGER(11) NULL, match_type CHAR(20) NULL, points1 SMALLINT(6) NULL, points2 SMALLINT(6) NULL, frags1 SMALLINT(5) NULL, frags2 SMALLINT(5) NULL, win1 SMALLINT(6) NULL, draw SMALLINT(6) NULL, win2 SMALLINT(6) NULL, descr TEXT NULL, game_server CHAR(50) NULL, PRIMARY KEY(id_match))
CREATE TABLE IF NOT EXISTS league_match_map ( id_ma_ma INTEGER(11) NULL AUTO_INCREMENT, id_match INTEGER(11) NULL, match_map CHAR(20) NULL, frags1 SMALLINT(6) NULL, frags2 SMALLINT(6) NULL, wo INTEGER(11) NULL, played CHAR(1) NULL, PRIMARY KEY(id_ma_ma))
CREATE TABLE IF NOT EXISTS league_match_score_details ( id_ma_ma INTEGER(11) NULL, period CHAR(1) NULL, frags1 SMALLINT(6) NULL, frags2 SMALLINT(6) NULL)
CREATE TABLE IF NOT EXISTS league_menu ( id_menu INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, visible CHAR(1) NULL, permission_global SMALLINT(6) NULL, permission_local SMALLINT(6) NULL, head_text CHAR(30) NULL, head_lang CHAR(30) NULL, link CHAR(80) NULL, link_target CHAR(1) NULL, link_local CHAR(1) NULL, sort_column SMALLINT(6) NULL, sort_row SMALLINT(6) NULL, PRIMARY KEY(id_menu))
CREATE TABLE IF NOT EXISTS league_penalty_standard ( id_penalty INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, grade SMALLINT(6) NULL, frags SMALLINT(6) NULL, points SMALLINT(6) NULL, PRIMARY KEY(id_penalty))
CREATE TABLE IF NOT EXISTS league_player ( id_player INTEGER(11) NULL AUTO_INCREMENT, id_team INTEGER(11) NULL, id_user INTEGER(11) NULL, approve_user CHAR(1) NULL, invite_by INTEGER(11) NULL, player_name CHAR(20) NULL, contact CHAR(60) NULL, ident CHAR(30) NULL, grade CHAR(1) NULL, other CHAR(20) NULL, added DATETIME NULL, added_by INTEGER UNSIGNED NULL, PRIMARY KEY(id_player))
CREATE TABLE IF NOT EXISTS league_player_league ( id_player INTEGER(11) NULL, league INTEGER(11) NULL, PRIMARY KEY(id_player, league))
CREATE TABLE IF NOT EXISTS league_player_stats ( id_pl_st INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, id_player INTEGER(11) NULL, id_match INTEGER(11) NULL, id_ma_ma INTEGER(11) NULL, frags INTEGER(11) NULL, deaths INTEGER(11) NULL, map_number SMALLINT(6) NULL, PRIMARY KEY(id_pl_st))
CREATE TABLE IF NOT EXISTS league_pm ( id_pm INTEGER(11) NULL AUTO_INCREMENT, id_author INTEGER(11) NULL, id_receiver INTEGER(11) NULL, added DATETIME NULL, title CHAR(50) NULL, content TEXT NULL, ip VARCHAR(15) NULL, receiver_status CHAR(1) NULL, author_status CHAR(1) NULL, PRIMARY KEY(id_pm))
CREATE TABLE IF NOT EXISTS league_points_standard ( id_po_st INTEGER(11) NOT NULL AUTO_INCREMENT, league INTEGER(11) NULL, score1 CHAR(5) NULL, draw CHAR(5) NULL, score2 CHAR(5) NULL, points1 SMALLINT(6) NULL, points2 SMALLINT(6) NULL, PRIMARY KEY(id_po_st))
CREATE TABLE IF NOT EXISTS league_poll ( id_poll INTEGER(11) NULL AUTO_INCREMENT, question CHAR(100) NULL, active CHAR(1) NULL, active_to DATETIME NULL, active_from DATETIME NULL, league INTEGER(11) NULL, PRIMARY KEY(id_poll))
CREATE TABLE IF NOT EXISTS league_poll_answer ( id_po_an INTEGER(11) NULL AUTO_INCREMENT, id_poll INTEGER(11) NULL, answer CHAR(50) NULL, PRIMARY KEY(id_po_an))
CREATE TABLE IF NOT EXISTS league_poll_choice ( id_user INTEGER(11) NULL, id_po_an INTEGER(11) NULL)
CREATE TABLE IF NOT EXISTS league_screen ( idn INTEGER(11) UNSIGNED NULL AUTO_INCREMENT, league INTEGER(11) NULL, idm INTEGER(11) UNSIGNED NULL, idmm INTEGER(11) NULL, map CHAR(20) NULL, screen_name INTEGER(15) NULL, screen_hash CHAR(3) NULL, PRIMARY KEY(idn))
CREATE TABLE IF NOT EXISTS league_season ( id_season INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, season_name CHAR(50) NULL, descr CHAR(50) NULL, PRIMARY KEY(id_season))
CREATE TABLE IF NOT EXISTS league_table ( id_table INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_team INTEGER(11) NULL, id_group INTEGER(11) NULL, points SMALLINT(6) NULL, frags SMALLINT(5) NULL, deaths SMALLINT(5) NULL, wins SMALLINT(6) NULL, draw SMALLINT(6) NULL, lost SMALLINT(6) NULL, map_win SMALLINT(6) NULL, map_draw SMALLINT(6) NULL, map_lost SMALLINT(6) NULL, PRIMARY KEY(id_table))
CREATE TABLE IF NOT EXISTS league_table_penalty ( id_ta_pe INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_table INTEGER(11) NULL, frags SMALLINT(6) NULL, points SMALLINT(6) NULL, PRIMARY KEY(id_ta_pe))
CREATE TABLE IF NOT EXISTS league_team ( id_team INTEGER(11) NULL AUTO_INCREMENT, id_main_team INTEGER(11) NULL, team_name CHAR(30) NULL, tag VARCHAR(15) NULL, www CHAR(50) NULL, registered DATETIME NULL, info CHAR(250) NULL, active CHAR(1) NULL, team_country CHAR(10) NULL, irc_channel CHAR(50) NULL, logo CHAR(5) NULL, id_user INTEGER(11) NULL, team_pass CHAR(32) NULL, team_type CHAR(1) NULL, PRIMARY KEY(id_team))
CREATE TABLE IF NOT EXISTS league_team_award ( id_te_aw INTEGER(11) NULL AUTO_INCREMENT, id_award INTEGER(11) NULL, league INTEGER(11) NULL, id_team INTEGER(11) NULL, id_season INTEGER(11) NULL, PRIMARY KEY(id_te_aw))
CREATE TABLE IF NOT EXISTS league_team_league ( league INTEGER(11) NULL, id_team INTEGER(11) NULL, PRIMARY KEY(league, id_team))
CREATE TABLE IF NOT EXISTS league_team_signup ( id_season INTEGER(11) NULL, league INTEGER(11) NULL, id_user INTEGER(11) NULL, id_team INTEGER(11) NULL)
CREATE TABLE IF NOT EXISTS league_team_wildcard ( id_te_wi INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, id_season INTEGER(11) NULL, id_team INTEGER(11) NULL, PRIMARY KEY(id_te_wi))
CREATE TABLE IF NOT EXISTS league_user ( id_user INTEGER(11) NULL AUTO_INCREMENT, login VARCHAR(15) NULL, pass VARCHAR(32) NULL, mail VARCHAR(60) NULL, permission SMALLINT(6) NULL, added DATETIME NULL, lastlog DATETIME NULL, user_name CHAR(50) NULL, birth DATE NULL, team CHAR(30) NULL, team_www CHAR(50) NULL, home_www CHAR(50) NULL, city VARCHAR(40) NULL, info TINYTEXT NULL, mail_show CHAR(1) NULL, user_country CHAR(10) NULL, comm_icq CHAR(30) NULL, comm_msn CHAR(30) NULL, timezone SMALLINT(6) NULL, send_pm_mail CHAR(1) NULL, ip CHAR(15) NULL, avatar CHAR(5) NULL, auth CHAR(32) NULL, PRIMARY KEY(id_user), INDEX login(login))
CREATE TABLE IF NOT EXISTS league_user_invitation ( id_user INTEGER(11) NULL, id_team INTEGER(11) NULL, PRIMARY KEY(id_user, id_team))
CREATE TABLE IF NOT EXISTS league_user_online ( added DATETIME NULL, ip CHAR(15) NULL, id_user INTEGER(11) NULL, league INTEGER(11) NULL)
CREATE TABLE IF NOT EXISTS league_user_pass ( id_user INTEGER(11) NULL, pass VARCHAR(32) NULL, added INTEGER(15) NULL, auth VARCHAR(32) NULL, ip CHAR(15) NULL)
CREATE TABLE IF NOT EXISTS league_user_permission ( id_user INTEGER(11) NULL, permission SMALLINT(6) NULL, descr CHAR(50) NULL, league INTEGER(11) NULL)
    Es kommt folgender Fehler, wie es aussieht kommt er von der Tabelle `adodb_logsql`

    Code:
    Fehler

SQL-Befehl:

CREATE TABLE IF NOT EXISTS `adodb_logsql` (created datetime NULL, sql0 varchar(250) NULL, sql1 text NULL, params text NULL, tracer text NULL, timer decimal(16,6) NULL) CREATE TABLE IF NOT EXISTS league_article ( id_article INTEGER(11) NULL AUTO_INCREMENT, id_user INTEGER(11) NULL, league INTEGER(11) NULL, id_season INTEGER(11) NULL, added DATETIME NULL, visible CHAR(1) NULL, comments CHAR(1) NULL, title VARCHAR(30) NULL, content TEXT NULL, PRIMARY KEY(id_article)) CREATE TABLE IF NOT EXISTS league_award ( id_award INTEGER(11) NULL AUTO_INCREMENT, league INTEGER(11) NULL, award_name CHAR(25) NULL, award_extension CHAR(5) NULL, grade SMALLINT(6) NULL, PRIMARY KEY(id_award)) CREATE TABLE IF NOT EXISTS league_ban ( id_ban INTEGER UNSIGNED NULL AUTO_INCREMENT, ip CHAR(50) NULL, ban_type CHAR(1) NULL, ban_limit DATE NULL, PRIMARY KEY(id_ban)) CREATE TABLE IF NOT EXISTS league_category ( id_category INTEGER(11) NULL AUTO_INCREMENT, category_main INTEGER(11) NULL, c[...]

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS league_article ( id_article INTEGER(11) NULL AUTO_IN' at line 2
    Bei der zweiten tabelle klappt es allerdings:

    Code:
    CREATE TABLE IF NOT EXISTS league_article ( id_article INTEGER(11) NULL AUTO_INCREMENT, id_user INTEGER(11) NULL, league INTEGER(11) NULL, id_season INTEGER(11) NULL, added DATETIME NULL, visible CHAR(1) NULL, comments CHAR(1) NULL, title VARCHAR(30) NULL, content TEXT NULL, PRIMARY KEY(id_article))
    Code:
    Ihr SQL-Befehl wurde erfolgreich ausgeführt. (die Abfrage dauerte 0.0067 sek.)
    Noch ein Fehler:

    Code:
    Fehler

SQL-Befehl:

CREATE TABLE IF NOT EXISTS league_category(
id_category INTEGER( 11 ) NULL AUTO_INCREMENT ,
category_main INTEGER( 11 ) NULL ,
category_aliasCHAR( 20 ) NULL ,
category_nameCHAR( 50 ) NULL ,
category_extensionCHAR( 5 ) NULL ,
category_typeCHAR( 20 ) NULL ,
category_templateCHAR( 5 ) NULL ,
category_limit SMALLINT UNSIGNED NULL ,
category_seasonCHAR( 1 ) NULL ,
PRIMARY KEY ( id_category )
) CREATE TABLE IF NOT EXISTS league_category_item(
id_category INTEGER( 11 ) NULL ,
item_id INTEGER UNSIGNED NULL
)

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS league_category_item ( id_category INTEGER(11) NULL,' at line 2

    Wie schon oben geschrieben sind alle Rechte vorhanden die benötigt werden,
    es geht um folgenden Script/CMS: kmleague.net

    Mfg Sky
     
    + Multi-Zitat Zitieren
  5. 4. Oktober 2011
    AW: MySQL Problem bei CMS installation.

    Normalerweise gehört hinter jeden Insert-Befehl ein ";" - Probier das mal aus, weil das der Syntax an sich nicht simmt glaube ich nicht, dafür sieht das ganze System zu professionell aus, das wäre aufgefallen!


    Gruß Blackb!rd
     
    + Multi-Zitat Zitieren
  6. 4. Oktober 2011
    AW: MySQL Problem bei CMS installation.

    büdde

    http://pastebin.com/1k4XFjUW

    engine und encoding angepasst in phpmyadmin eingepflegt und dann nen dump erstellt.
     
    + Multi-Zitat Zitieren
  7. Video Script

    Videos zum Themenbereich

    * gefundene Videos auf YouTube, anhand der Überschrift.

Auf dieses Thema antworten