Deprecated Darkstar fourms

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

blue spell list has nothing to do with spell_list

are you using that dsp updater tool?

I have in the past but now I use sqlyog

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

ok, Ill just quickly redo my db and see O.O odd though

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

delete the blue spell list sql file and do svn revert

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

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

This is becoming quite a problem

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