[RELEASE]UltimatePvp Source

Page 4 of 4 « First 23 4
12/04/2009 22:45 Adziunia#46
umm donno why it wont work for me o.O i just have error when i am executing sql file here look and tell me whats wrong :)
[Err] 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 'USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1' at line 15
[Err] CREATE TABLE `accounts` (
`AccountID` varchar(16) NOT NULL DEFAULT '',
`Password` varchar(64) NOT NULL DEFAULT '',
`LogonType` int(8) unsigned NOT NULL DEFAULT '0',
`LogonCount` int(10) unsigned NOT NULL DEFAULT '0',
`Status` int(8) unsigned NOT NULL DEFAULT '0',
`Charr` varchar(16) NOT NULL DEFAULT '',
`AccNr` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Online` int(8) unsigned NOT NULL DEFAULT '0',
`Email` varchar(255) NOT NULL,
`SecretQuestion` varchar(255) NOT NULL,
`Answer` varchar(255) NOT NULL,
`Identification` varchar(8) NOT NULL,
`WebPassword` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`AccNr`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

i made database:
name: coproj
character set: utf8 -- UTF-8 Unicode
collation: utf8_general_ci
12/04/2009 23:15 ØnëwïngëÐ#47
Quote:
Originally Posted by Adziunia View Post
umm donno why it wont work for me o.O i just have error when i am executing sql file here look and tell me whats wrong :)
[Err] 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 'USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1' at line 15
[Err] CREATE TABLE `accounts` (
`AccountID` varchar(16) NOT NULL DEFAULT '',
`Password` varchar(64) NOT NULL DEFAULT '',
`LogonType` int(8) unsigned NOT NULL DEFAULT '0',
`LogonCount` int(10) unsigned NOT NULL DEFAULT '0',
`Status` int(8) unsigned NOT NULL DEFAULT '0',
`Charr` varchar(16) NOT NULL DEFAULT '',
`AccNr` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Online` int(8) unsigned NOT NULL DEFAULT '0',
`Email` varchar(255) NOT NULL,
`SecretQuestion` varchar(255) NOT NULL,
`Answer` varchar(255) NOT NULL,
`Identification` varchar(8) NOT NULL,
`WebPassword` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`AccNr`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

i made database:
name: coproj
character set: utf8 -- UTF-8 Unicode
collation: utf8_general_ci
Bumping old threads LOL i dont have the source =\
12/05/2009 01:13 Huseby#48
Dont bump.

#Closed
Page 4 of 4 « First 23 4