[Ascent] Server Crash Access Violation Error [Help]

[jklei18]

Hi this has happened about 6 times now i got the server running with my 2 realms local and online and once i login it does not matter what character i get this happen straight away



Any help would be great

[Stabatha]

Your missing the playerscooldown table from your char database. run thisin phpmyadmin..

DROP TABLE IF EXISTS playercooldownsecurity;
DROP TABLE IF EXISTS playercooldownitems;
DROP TABLE IF EXISTS playercooldowns;

CREATE TABLE `playercooldowns` (
  `player_guid` int(30) NOT NULL,
  `cooldown_type` int(30) NOT NULL COMMENT '0 is spell, 1 is item, 2 is spell category',
  `cooldown_misc` int(30) NOT NULL COMMENT 'spellid/itemid/category',
  `cooldown_expire_time` int(30) NOT NULL COMMENT 'expiring time in unix epoch format',
  `cooldown_spellid` int(30) NOT NULL COMMENT 'spell that cast it',
  `cooldown_itemid` int(30) NOT NULL COMMENT 'item that cast it'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[Chrispee]

just use navicat right click on the database then console paste

DROP TABLE IF EXISTS playercooldownsecurity;
DROP TABLE IF EXISTS playercooldownitems;
DROP TABLE IF EXISTS playercooldowns;

CREATE TABLE `playercooldowns` (
`player_guid` int(30) NOT NULL,
`cooldown_type` int(30) NOT NULL COMMENT '0 is spell, 1 is item, 2 is spell category',
`cooldown_misc` int(30) NOT NULL COMMENT 'spellid/itemid/category',
`cooldown_expire_time` int(30) NOT NULL COMMENT 'expiring time in unix epoch format',
`cooldown_spellid` int(30) NOT NULL COMMENT 'spell that cast it',
`cooldown_itemid` int(30) NOT NULL COMMENT 'item that cast it'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

and hit enter

[Stabatha]

just use navicat right click on the database then console paste

Same as I said above.. But I prefur phpMyAdmin