[Help]Albetros MYSQL execute errors

12/21/2012 17:38 danyhameleh2#1
I have some errors on that source can some1 help me please?

Code:
[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 'skip,1;
	END
;


-- ----------------------------
-- Procedure structure for' at line 5
[Err] INSERT INTO spellinfo VALUES ('10359', '30010', 'IceBolt', '0036', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0008', '0020', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10351', '10500', 'Immolation', '0035', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0002', '0020', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10352', '10505', 'RevengePunch', '0041', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0005', '0005', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10353', '10502', 'BladeStorm', '0036', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0000', '0003', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10354', '10506', 'BladeVortex', '0036', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0012', '0012', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10355', '10504', 'SwordBeam', '0036', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0008', '0020', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10356', '30013', 'ArrowHail', '0044', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0012', '0020', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10357', '30012', 'Avalanche', '0035', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0003', '0008', '0015', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10358', '30011', 'IceShock', '0034', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0003', '0006', '0006', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10360', '10360', 'SurgingShake', '0042', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0008', '0008', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10361', '10361', 'BloodyBattle', '0035', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0005', '0020', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10362', '10362', 'SoaringLeap', '0043', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0005', '0015', '0020', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '0', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10363', '10363', 'LightningCrash', '0036', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0008', '0020', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10364', '10364', 'PiercingStrike', '0001', '0', '0', '0', '0004', '0000', '0000', '200', '0000', '0100', '0000', '0005', '0005', '0000', '0000', '0', '0000', '0', '0000', '0000', '0', '0000', '0', '0000', '0', '0000', '1', '0000', '0000', '0000', '0001');
INSERT INTO spellinfo VALUES ('10365', '30014', 'FrostClaw', '0001', '0', '0', '0', '0004', '0000', '0000'
[Msg] Finished - Unsuccessfully
--------------------------------------------------
12/21/2012 17:43 Silent-Death#2
the syntax you are using does not apply to your mysql version.
1. upgrade/downgrade mysql
2. change the syntax to work for the mysql version.

I suggest getting the latest mysql version and editing the syntax to work with that.
12/21/2012 17:49 danyhameleh2#3
Quote:
Originally Posted by Silent-Death View Post
the syntax you are using does not apply to your mysql version.
1. upgrade/downgrade mysql
2. change the syntax to work for the mysql version.

I suggest getting the latest mysql version and editing the syntax to work with that.
what do u mean edit it , how ?
12/21/2012 18:39 Silent-Death#4
i don`t know how your code looks like, but the basic idea is that mysql has a syntax that you need to respect in order to insert shit into it.
What i understand from your issue is that your syntax in the program you are running to insert data into the database is wrong. You need to consult the manual for your mysql version and edit the syntax in your program so that it inserts data in mysql.

I suggested updating mysql to the latest version because you can never go wrong with the latest update on mysql.
12/21/2012 18:40 danyhameleh2#5
Quote:
Originally Posted by Silent-Death View Post
i don`t know how your code looks like, but the basic idea is that mysql has a syntax that you need to respect in order to insert shit into it.
What i understand from your issue is that your syntax in the program you are running to insert data into the database is wrong. You need to consult the manual for your mysql version and edit the syntax in your program so that it inserts data in mysql.

I suggested updating mysql to the latest version because you can never go wrong with the latest update on mysql.
hmmmm im on the last one just downloaded the last one on navicat website ..
12/21/2012 18:52 Silent-Death#6
navicat? just get clean mysql and manage it with phpmyadmin. w/e
12/21/2012 21:04 danyhameleh2#7
Quote:
Originally Posted by Silent-Death View Post
navicat? just get clean mysql and manage it with phpmyadmin. w/e
I dont know how to use that phpmyadmin never used it before ..
12/21/2012 21:06 danyhameleh2#8
I executed the source of Mr.Omany and that was the result :
someone know how to fix it ?


Code:
[Err] 1071 - Specified key was too long; max key length is 767 bytes
[Err] CREATE TABLE `subclasses` (
  `unique` int(36) unsigned NOT NULL auto_increment,
  `id` int(36) unsigned NOT NULL default '0',
  `uid` int(36) unsigned NOT NULL default '1',
  `phase` int(36) unsigned NOT NULL default '1',
  `level` int(36) unsigned NOT NULL default '1',
  PRIMARY KEY  (`unique`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of subclasses
-- ----------------------------
INSERT INTO `subclasses` VALUES ('1', '1000002', '9', '1', '1');

-- ----------------------------
-- Table structure for `terrainnpcs`
-- ----------------------------
DROP TABLE IF EXISTS `terrainnpcs`;
CREATE TABLE `terrainnpcs` (
  `id` int(35) unsigned zerofill NOT NULL auto_increment,
  `Mesh` int(35) unsigned default '0',
  `cellx` int(35) default '0',
  `celly` int(35) default '0',
  `TableUID` int(35) default '0',
  `Type` int(35) default '0',
  `Map` int(3) default '1858',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of terrainnpcs
-- ----------------------------

-- ----------------------------
-- Table structure for `top1`
-- ----------------------------
DROP TABLE IF EXISTS `top1`;
CREATE TABLE `top1` (
  `UID` bigint(255) NOT NULL default '0',
  `Name` varchar(255) character set latin1 default NULL,
  `TopTrojan` bigint(255) default NULL,
  `TopMonk` bigint(255) default NULL,
  `TopWarrior` bigint(255) default NULL,
  `TopNinja` bigint(255) default NULL,
  `TopWaterTaoist` bigint(255) default NULL,
  `TopArcher` bigint(255) default NULL,
  `TopFireTaoist` bigint(255) default NULL,
  `TopPirate` bigint(225) default NULL,
  PRIMARY KEY  (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of top1
-- ----------------------------

-- ----------------------------
-- Table structure for `top2`
-- ----------------------------
DROP TABLE IF EXISTS `top2`;
CREATE TABLE `top2` (
  `UID` bigint(255) NOT NULL default '0',
  `Name` varchar(255) character set latin1 default NULL,
  `TopTrojan2` bigint(255) default NULL,
  `TopMonk2` bigint(255) default NULL,
  `TopWarrior2` bigint(255) default NULL,
  `TopNinja2` bigint(255) default NULL,
  `TopWaterTaoist2` bigint(255) default NULL,
  `TopArcher2` bigint(255) default NULL,
  `TopFireTaoist2` bigint(255) default NULL,
  `TopPirate2` bigint(225) default NULL,
  PRIMARY KEY  (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of top2
-- ----------------------------

-- ----------------------------
-- Table structure for `top3`
-- ----------------------------
DROP TABLE IF EXISTS `top3`;
CREATE TABLE `top3` (
  `UID` bigint(255) NOT NULL default '0',
  `Name` varchar(255) character set latin1 default NULL,
  `TopGuildLeader` bigint(255) default NULL,
  `TopDeputyLeader` bigint(255) default NULL,
  `WeeklyPKChampion` bigint(255) default NULL,
  `MonthlyPK` bigint(255) default NULL,
  PRIMARY KEY  (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of top3
-- ----------------------------

-- ----------------------------
-- Table structure for `topdonation`
-- ----------------------------
DROP TABLE IF EXISTS `topdonation`;
CREATE TABLE `topdonation` (
  `EntityID` bigint(255) NOT NULL default '0',
  `Name` varchar(255) NOT NULL default '0',
  `TopKing` int(255) default '0',
  `TopPrince` int(255) default '0',
  `TopDucke` int(255) default '0',
  `TopKinght` int(255) default '0',
  `TopEarl` int(255) default '0',
  `TopBaron` int(255) default '0',
  PRIMARY KEY  (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of topdonation
-- ----------------------------

-- ----------------------------
-- Table structure for `trade_log`
-- ----------------------------
DROP TABLE IF EXISTS `trade_log`;
CREATE TABLE `trade_log` (
  `user1` varchar(16) NOT NULL default '0',
  `user2` varchar(16) NOT NULL default '0',
  `cps1`
[Msg] Finished - Unsuccessfully
--------------------------------------------------
12/21/2012 22:03 pro4never#9
I would request that epvp members not provide assistance for the alebtros source outside of the main release and faq thread... Obviously just a request though but I'm completely sick of people posting new threads, then pm'ing me links or the contents of the threads and expecting me to help... I'd notice it just as fast and be far more likely to help if they just used the damn faq thread (or they could take 5 minutes to read it and their problems would be solved)
12/22/2012 01:05 Spirited#10
Quote:
Originally Posted by danyhameleh2 View Post
Yea but everytime I have another problem >.<
Bloody hell man... google them. All of these problems are unrelated to Conquer Online. How are you even getting these errors on well known sources? If you can't use MySql, use NewestCoServer. If you can't google your errors, then how do you expect to figure out a server?
12/22/2012 13:27 danyhameleh2#11
Quote:
Originally Posted by Fаng View Post
Bloody hell man... google them. All of these problems are unrelated to Conquer Online. How are you even getting these errors on well known sources? If you can't use MySql, use NewestCoServer. If you can't google your errors, then how do you expect to figure out a server?
Dude I google it but I have no idea how to fix it like that one I understood that the max is 767 and there more then that in the vars but I have no idea how to fix it ... :/
12/22/2012 19:18 JohnHeatz#12
I have merged both of your latest threads in this one, please if you have problems with something, don't make multiple threads, use the same thread for the issues (if they are regarding same situation, for example, database)

As well, taking in consideration the information you have provided, as well as the answers from other members, you have pretty much gotten answered, and as you are using this source, I'd highly recommend using the designated thread for Q/A on this source.

#Closed