Mikor a mysql-t importálom akkor ezt irja. Miért?
SQL lekérdezés:
CREATE TABLE IF NOT EXISTS `accounts` (
`id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`pass` varchar(42) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`regdate` int(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Money` int(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Kills` int(11) NOT NULL DEFAULT \'0\',
`Deaths` int(11) NOT NULL DEFAULT \'0\',
`Admin` int(11) NOT NULL DEFAULT \'0\',
`colors` int(11) NOT NULL,
`Banned` int(11) NOT NULL DEFAULT \'0\',
`Baninfos` varchar(128) NOT NULL,
`sfRang` varchar(32) NOT NULL,
`keyid` int(11) NOT NULL,
`Mute` int(11) NOT NULL DEFAULT \'0\',
`Muted` int(11) NOT NULL DEFAULT \'0\',
`rang` varchar(32) NOT NULL,
`lastday` int(11) NOT NULL DEFAULT \'0\',
`score` int(11) NOT NULL,
`Time` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=la[...]
A MySQL mondta: Dokumentáció
#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 \'CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Money` int(11) CHARACTER SET u\' at line 6
Mikor a mysql-t importálom akkor ezt irja. Miért?
SQL lekérdezés:
CREATE TABLE IF NOT EXISTS `accounts` (
`id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`pass` varchar(42) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`regdate` int(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Money` int(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Kills` int(11) NOT NULL DEFAULT \'0\',
`Deaths` int(11) NOT NULL DEFAULT \'0\',
`Admin` int(11) NOT NULL DEFAULT \'0\',
`colors` int(11) NOT NULL,
`Banned` int(11) NOT NULL DEFAULT \'0\',
`Baninfos` varchar(128) NOT NULL,
`sfRang` varchar(32) NOT NULL,
`keyid` int(11) NOT NULL,
`Mute` int(11) NOT NULL DEFAULT \'0\',
`Muted` int(11) NOT NULL DEFAULT \'0\',
`rang` varchar(32) NOT NULL,
`lastday` int(11) NOT NULL DEFAULT \'0\',
`score` int(11) NOT NULL,
`Time` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=la[...]
A MySQL mondta: Dokumentáció
#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 \'CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Money` int(11) CHARACTER SET u\' at line 6
Javítva a főposztban!
Nekem ezt írja ki !!
SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team
[20:39:58]
[20:39:58] Server Plugins
[20:39:58] --------------
[20:39:58] Loading plugin: streamer
[20:39:58]
*** Streamer Plugin v2.7 by Incognito loaded ***
[20:39:58] Loaded.
[20:39:58] Loading plugin: mysql
[20:39:58]
> MySQL plugin R5 successfully loaded.
[20:39:58] Loaded.
[20:39:58] Loading plugin: gvar
[20:39:58]
*** GVar Plugin v1.3 by Incognito loaded ***
[20:39:58] Loaded.
[20:39:58] Loading plugin: sscanf
[20:39:58]
[20:39:58] ===============================
[20:39:58] sscanf plugin loaded.
[20:39:58] (c) 2009 Alex \"Y_Less\" Cole
[20:39:58] 0.3d-R2 500 Players \"dnee\"
[20:39:58] ===============================
[20:39:58] Loaded.
[20:39:58] Loaded 4 plugins.
[20:39:58]
[20:39:58] Filterscripts
[20:39:58] ---------------
[20:39:58] Loading filterscript \'objects.amx\'...
[20:39:58] Loaded 1 filterscripts.
[20:39:58] Script[gamemodes/xmas.amx]: Run time error 19: \"File or function is not found\"
[20:39:58] Number of vehicle models: 0
Semmi hiba nincs benne pedig..
És bocsi h igy másoltam ide. nemtudom hogy kell kódba rakni vagy mi az xd