[Help]Albetros MYSQL execute errors

danyhameleh2 · 12/21/2012, 17:38

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
--------------------------------------------------

Silent-Death · 12/21/2012, 17:43

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.

danyhameleh2 · 12/21/2012, 17:49

Quote:

Originally Posted by Silent-Death

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 ?

Silent-Death · 12/21/2012, 18:39

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 **** 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.

danyhameleh2 · 12/21/2012, 18:40

Quote:

Originally Posted by Silent-Death

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 **** 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 ..

Silent-Death · 12/21/2012, 18:52

navicat? just get clean mysql and manage it with phpmyadmin. w/e

danyhameleh2 · 12/21/2012, 21:04

Quote:

Originally Posted by Silent-Death

navicat? just get clean mysql and manage it with phpmyadmin. w/e

I dont know how to use that phpmyadmin never used it before ..

danyhameleh2 · 12/21/2012, 21:06

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
--------------------------------------------------

~~pro4never~~ · 12/21/2012, 22:03

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 **** faq thread (or they could take 5 minutes to read it and their problems would be solved)

Spirited · 12/22/2012, 01:05

Quote:

Originally Posted by danyhameleh2

Yea but everytime I have another problem >.<

****** 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?

danyhameleh2 · 12/22/2012, 13:27

Quote:

Originally Posted by Fаng

****** 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 ... :/

JohnHeatz · 12/22/2012, 19:18

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