Ascent 3.5 STable Question

[Rouslan]

I have used all SQL updates, downloaded the latest compiles from a sticky,Ascent 3.5 Stable and updated everyting, i mean i been doing this for few months now, so all updates been doen, and i am getting crush dumb when ascent loading gets to Creature spawn i think, basicaly after it says World Database Loaded in 566MS , done! It goes to next thread and crashes.

any help would be greatly appreciated.

+Rep

[Gastricpenguin]

We don't know whats wrong unless you tell us what Error it is.

Access Violation?
You didnt use the correct updates

Microsoft C++ Violation?
Your core is corrupt, get a new one

Memory Violation?
Your computer cant run ascent

[Sporeles]

alter table creature_spawns add column standstate int(10) not null default 0;

try and execute that it should work and solve the problem of ascent crashing after database loads

[Rouslan]

my error is access violation and i used all the updates from svn and your Compiles.

So i am prety sure i did updates,

[Rouslan]

alter table creature_spawns add column standstate int(10) not null default 0;

try and execute that it should work and solve the problem of ascent crashing after database loads

lol wierd.

but hey it fixed my problem even thou i thought ialready did this.

i gave u rep

[danis]

helps +rep but i got a lil problem lol... tells sql query failed due to table danis .mailbox_insert_queue dosent exist ... wtf select from mailbox_insert_queue where i get this..?o yea and i get a error dunno wtf tells there after asent loads up and i just need to click ok ! Tells this the procedure entry point ?senccastresult@spell@qaexf@z could not be located in the dynamic link library ascent.exe

[dann462]

Danis try this:

CREATE TABLE `mailbox_insert_queue` (
  `sender_guid` int(30) NOT NULL,
  `receiver_guid` int(30) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `body` varchar(500) NOT NULL,
  `stationary` int(30) NOT NULL,
  `money` int(30) NOT NULL,
  `item_id` int(30) NOT NULL,
  `item_stack` int(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[danis]

Ok cool thanks + rep that worked now I just get ascent.exe entry point not found THE PROCEDURE entry point ?SendCASTResult@Spell@@QAEXF@Z could not be located in the dynamic link library ascent.exee

[dann462]

It cause of your scripts, one of them make it, try to use another ones. (script_bin)

[danis]

ok lol thanks ! now other one .. Unknown column "muted" in fields list select acc login password gm.. muted FROM ACCOUNTS

[dann462]

alter table accounts add column muted int(30) not null default 0;

^.^