blue spell list primary key

Forum rules
NO LONGER BEING MAINTAINED!
Post Reply
Tom_Neverwinter
Posts: 61
Joined: Mon Dec 24, 2012 3:47 pm

blue spell list primary key

Post by Tom_Neverwinter » Mon Jul 15, 2013 8:40 pm

[spoiler]


Query:
INSERT INTO spell_list VALUES (1, 'cure', x'0000010003000500000000000000000000000005', 6, 7, 95, 33, 8, 2000, 5000, 0, 1, 2000, 0, 0, 1.00, 0, 0)

Error occured at:2012-01-18 13:04:03
Line no.:54
Error Code: 1062 - Duplicate entry '1' for key 'PRIMARY'
Query:
INSERT INTO spell_list VALUES (1, 'cure', x'0000010003000500000000000000000000000005', 6, 7, 95, 33, 8, 2000, 5000, 0, 1, 2000, 0, 0, 1.00, 0, 0)

Error occured at:2012-01-18 13:04:24
Line no.:54
Error Code: 1062 - Duplicate entry '1' for key 'PRIMARY'
Query:
DROP TABLE IF EXISTS `abilities`

Error occured at:2013-06-19 22:54:34
Line no.:14
Error Code: 1046 - No database selected
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-10 04:46:27
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-10 04:46:41
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-10 04:53:18
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-11 18:31:34
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-14 13:12:37
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-14 13:21:28
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-14 13:24:29
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-14 13:26:05
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1
Query:
`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
`set_points` smallint(2) NOT NULL,
`trait_category` smallint(2) NOT NULL,
`trait_category_weight` smallint(2) NOT NULL,
PRIMARY KEY (`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2013-07-15 20:36:32
Line no.:21
Error Code: 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 '`spellid` smallint(3) NOT NULL,
`mob_skill_id` smallint(4) unsigned NOT NULL,
' at line 1

//prays spoiler tag works
//apparently not :(
[/spoiler]
Top
User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: blue spell list primary key

Post by kjLotus » Mon Jul 15, 2013 8:48 pm

blue spell list has nothing to do with spell_list

are you using that dsp updater tool?
Top
Tom_Neverwinter
Posts: 61
Joined: Mon Dec 24, 2012 3:47 pm

Re: blue spell list primary key

Post by Tom_Neverwinter » Mon Jul 15, 2013 8:54 pm

I have in the past but now I use sqlyog
Top
User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: blue spell list primary key

Post by kjLotus » Mon Jul 15, 2013 8:59 pm

well, i reran all my tables today and it went fine - there's no line trying to insert cure into spell_list in blue_spell_list, so maybe one of your files got corrupto'd
Top
Tom_Neverwinter
Posts: 61
Joined: Mon Dec 24, 2012 3:47 pm

Re: blue spell list primary key

Post by Tom_Neverwinter » Mon Jul 15, 2013 9:01 pm

ok, Ill just quickly redo my db and see O.O odd though
Top
Tom_Neverwinter
Posts: 61
Joined: Mon Dec 24, 2012 3:47 pm

Re: blue spell list primary key

Post by Tom_Neverwinter » Mon Jul 15, 2013 9:07 pm

nope it gets to it and just says no. same error
primary keys (ugh I hated that class)
says theres a conflict somewhere and there can only be one
Top
User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: blue spell list primary key

Post by kjLotus » Mon Jul 15, 2013 10:23 pm

delete the blue spell list sql file and do svn revert
Top
Tom_Neverwinter
Posts: 61
Joined: Mon Dec 24, 2012 3:47 pm

Re: blue spell list primary key

Post by Tom_Neverwinter » Mon Jul 15, 2013 11:03 pm

Still gives the same error, reverted;
Execute: Revert
Revert: c:/dsp/conf/search_server.conf
Revert: c:/dsp/conf/login_darkstar.conf
Revert: c:/dsp/conf/map_darkstar.conf
Revert: c:/dsp/scripts/globals/settings.lua
Revert: c:/dsp/sql/blue_spell_list.sql
Revert: c:/dsp/win32/DSSearch-server/DSSearch-server.sln
Revert: c:/dsp/win32/DSScripts-converter/DSScripts-converter.sln
Revert: c:/dsp/win32/DSGame-server/DSGame-server.sln
Revert: c:/dsp/win32/TheDesertWorld_Client/THEDESERTWORLD.sln
Updating...
Ready
Top
Tom_Neverwinter
Posts: 61
Joined: Mon Dec 24, 2012 3:47 pm

Re: blue spell list primary key

Post by Tom_Neverwinter » Thu Jul 18, 2013 3:32 pm

I am now also experiencing this problem, with the latest version of sqlyog, and with mob change skin.

This is becoming quite a problem
Top
User avatar
tagban
Posts: 352
Joined: Fri Dec 28, 2012 11:31 am
Location: Pennsylvania, USA

Re: blue spell list primary key

Post by tagban » Thu Jul 18, 2013 9:19 pm

Having the same issue also. Latest revision. Things seem to load okay for now, but haven't fully tested the server.
Top
Post Reply

Return to “Bugs”