Mysql Key column 'id' doesn't exist in table

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Mysql befehl:
    -- Tabellenstruktur für Tabelle `accounts`
    --
    CREATE TABLE IF NOT EXISTS `accounts` (

    `paydayhad` INT( 11 ) DEFAULT NULL ,
    `cdplayer` INT( 11 ) DEFAULT NULL ,
    `wins` INT( 11 ) DEFAULT NULL ,
    `loses` INT( 11 ) DEFAULT NULL ,
    `newsskill` INT( 6 ) NOT NULL DEFAULT '0',
    `drugsskill` INT( 6 ) NOT NULL DEFAULT '0',
    `cockskill` INT( 6 ) NOT NULL DEFAULT '0',
    `fishskill` INT( 6 ) NOT NULL DEFAULT '0',
    `farmerskill` INT( 6 ) NOT NULL DEFAULT '0',
    `tut` INT( 11 ) DEFAULT NULL ,
    `warns` INT( 11 ) DEFAULT NULL ,
    `online` INT( 11 ) DEFAULT NULL ,
    `pA` FLOAT NOT NULL ,
    `pFarbe1` INT( 11 ) NOT NULL ,
    `pFarbe2` INT( 11 ) NOT NULL ,
    `pModel` INT( 11 ) NOT NULL ,
    `pPreis1` INT( 11 ) NOT NULL ,
    PRIMARY KEY ( `id` )) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =38897;




    Error:
    Key column 'id' doesn't exist in table

    "Imagine if the government went after corruption as hard as it goes after guys who run filesharing sites. Priorities. " - @Snowden
    "More worrying than FBI temporarily running a server that contained child porn, is hacking computers anywhere in the world with one warrant" - @josephfcox

  • Danke und jetzt bekomm ich



    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 ') ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =38897' at line 21http://undefined

    "Imagine if the government went after corruption as hard as it goes after guys who run filesharing sites. Priorities. " - @Snowden
    "More worrying than FBI temporarily running a server that contained child porn, is hacking computers anywhere in the world with one warrant" - @josephfcox

  • Bei mir gehts.
    http://pokit.org/get/img/8ced8…fd65365f63d59b8493ff4.jpg


    So gehts auch:
    CREATE TABLE IF NOT EXISTS `accounts` (
    `paydayhad` INT( 11 ) DEFAULT NULL ,
    `cdplayer` INT( 11 ) DEFAULT NULL ,
    `wins` INT( 11 ) DEFAULT NULL ,
    `loses` INT( 11 ) DEFAULT NULL ,
    `newsskill` INT( 6 ) NOT NULL DEFAULT '0',
    `drugsskill` INT( 6 ) NOT NULL DEFAULT '0',
    `cockskill` INT( 6 ) NOT NULL DEFAULT '0',
    `fishskill` INT( 6 ) NOT NULL DEFAULT '0',
    `farmerskill` INT( 6 ) NOT NULL DEFAULT '0',
    `tut` INT( 11 ) DEFAULT NULL ,
    `warns` INT( 11 ) DEFAULT NULL ,
    `online` INT( 11 ) DEFAULT NULL ,
    `pA` FLOAT NOT NULL ,
    `pFarbe1` INT( 11 ) NOT NULL ,
    `pFarbe2` INT( 11 ) NOT NULL ,
    `pModel` INT( 11 ) NOT NULL ,
    `pPreis1` INT( 11 ) NOT NULL ,
    PRIMARY KEY ( `id` )) AUTO_INCREMENT =38897;


    Wenn du noch immer Fehler bekommst, zeig nochmal deinen Code und die Fehler.

  • Oke ich tests morgen. Sonst liegt es an samp4you

    "Imagine if the government went after corruption as hard as it goes after guys who run filesharing sites. Priorities. " - @Snowden
    "More worrying than FBI temporarily running a server that contained child porn, is hacking computers anywhere in the world with one warrant" - @josephfcox