Unable to create char! Error nomsg E-1

Results 1 to 5 of 5
  1. #1
    Account Upgraded | Title Enabled! Enough is offline
    MemberRank
    Oct 2012 Join Date
    301Posts

    Unable to create char! Error nomsg E-1

    Hello, I was running some queries for correct functioning of my website, and after a while I noticed that I can no longer create char on my server, always the error "nomsg E-1".

    I searched a bit about the error, and ran this query:

    PHP Code:
    CREATE TABLE [dbo].[LGCharact](
        [
    CID] [intIDENTITY(1,1NOT NULL,
        [
    AID] [intNOT NULL,
        [
    CleanName] [varchar](24NOT NULL,
        [
    Level] [smallintNOT NULL,
        [
    Sex] [tinyintNOT NULL,
        [
    CharNum] [smallintNOT NULL,
        [
    Hair] [tinyintNULL,
        [
    Face] [tinyintNULL,
        [
    XP] [intNOT NULL,
        [
    BP] [intNOT NULL,
        [
    HP] [smallintNULL,
        [
    AP] [smallintNULL,
        [
    FR] [intNULL,
        [
    CR] [intNULL,
        [
    ER] [intNULL,
        [
    WR] [intNULL,
        [
    head_slot] [intNULL,
        [
    chest_slot] [intNULL,
        [
    hands_slot] [intNULL,
        [
    legs_slot] [intNULL,
        [
    feet_slot] [intNULL,
        [
    fingerl_slot] [intNULL,
        [
    fingerr_slot] [intNULL,
        [
    melee_slot] [intNULL,
        [
    primary_slot] [intNULL,
        [
    secondary_slot] [intNULL,
        [
    custom1_slot] [intNULL,
        [
    custom2_slot] [intNULL,
        [
    RegDate] [datetimeNULL,
        [
    LastTime] [datetimeNULL,
        [
    PlayTime] [intNULL,
        [
    GameCount] [intNULL,
        [
    KillCount] [intNULL,
        [
    DeathCount] [intNULL,
        [
    DeleteFlag] [tinyintNULL,
        [
    DeleteName] [varchar](24NULL,
        [
    head_itemid] [intNULL,
        [
    chest_itemid] [intNULL,
        [
    hands_itemid] [intNULL,
        [
    legs_itemid] [intNULL,
        [
    feet_itemid] [intNULL,
        [
    fingerl_itemid] [intNULL,
        [
    fingerr_itemid] [intNULL,
        [
    melee_itemid] [intNULL,
        [
    primary_itemid] [intNULL,
        [
    secondary_itemid] [intNULL,
        [
    custom1_itemid] [intNULL,
        [
    custom2_itemid] [intNULL,
        [
    QuestItemInfo] [binary](292NULL

    But now, I can not delete the char, and sometimes also can not enter the game, I get a black screen. Another error also, is that sometimes the characters are invisible, making it impossible to check the same.

    The queries that I used to fix my website has nothing to do with characters, it was just news and requests for clan. If necessary, I'll post here for you!

    @edit
    What the fuck! I just realized that when I make a purchase in store bounty, the following message appears: "You can not make a purchase."

    Can anyone help me please?!?
    Last edited by Enough; 25-06-13 at 08:39 PM.


  2. #2
    Alpha Member Chrisss is offline
    MemberRank
    Feb 2012 Join Date
    Ask the Fox!Location
    1,660Posts

    Re: Unable to create char! Error nomsg E-1

    Quote Originally Posted by Enough View Post
    @edit
    What the fuck! I just realized that when I make a purchase in store bounty, the following message appears: "You can not make a purchase."

    Can anyone help me please?!?
    Remove the foreign keys from dbo.Item and then run this. UPDATE dbo.Item SET IsCashItem = 0
    That will fix that error.

  3. #3
    Account Upgraded | Title Enabled! Enough is offline
    MemberRank
    Oct 2012 Join Date
    301Posts

    Re: Unable to create char! Error nomsg E-1

    It worked, thanks.
    Could you help me with the characters? For he is Bugando bills, all the characters are often hidden, sometimes for the select but gets caught in a black screen before the lobby.

  4. #4
    Account Upgraded | Title Enabled! Enough is offline
    MemberRank
    Oct 2012 Join Date
    301Posts

    Re: Unable to create char! Error nomsg E-1

    Anyone help-me, please ?!?!?

  5. #5
    Alpha Member Chrisss is offline
    MemberRank
    Feb 2012 Join Date
    Ask the Fox!Location
    1,660Posts

    Re: Unable to create char! Error nomsg E-1

    Quote Originally Posted by Enough View Post
    It worked, thanks.
    Could you help me with the characters? For he is Bugando bills, all the characters are often hidden, sometimes for the select but gets caught in a black screen before the lobby.
    I honestly got no idea on this error. Sorry.



Advertisement