View Single Post
  #4  
Old 05-25-2008, 05:33 PM
Bishop4351
Sarnak
 
Join Date: Sep 2006
Location: Texas
Posts: 49
Default Fixed

I updated to 1108 and I figured out what my problem was. I was using a strict copy paste from the changelog which says:

Code:
Required SQL:
alter table `zone` add column `canlevitate` tinyint (4) DEFAULT '1' NOT NULL  after `cancombat`
alter table `zone` add column `castoutdoor` tinyint (4) DEFAULT '1' NOT NULL  after `canlevitate`;
It's missing a ";" so I missed the change. I restored to a backup then remade the change adding in the line to look like this:

Code:
Required SQL:
alter table `zone` add column `canlevitate` tinyint (4) DEFAULT '1' NOT NULL  after `cancombat`;
alter table `zone` add column `castoutdoor` tinyint (4) DEFAULT '1' NOT NULL  after `canlevitate`;
and all was good. With the update in place I can unclick buffs without any problem or zone crashes.

Not alot of folks put in their fixes to things so I figured I'd add it here for the sake of future searches.
Reply With Quote