SQL Error

Results 1 to 8 of 8
  1. #1
    Account Upgraded | Title Enabled! Cancel is offline
    MemberRank
    Jan 2008 Join Date
    ItalyLocation
    337Posts

    SQL Error

    Hey Guys, if i try to "Delete all items from Equipment" on Emisand'S Admin Pannel i get this error.

    Here the image
    http://inflamegunz.in.funpic.de/Unbenannt45.JPG

    How can i fix it?


  2. #2
    mikethemak is offline
    MemberRank
    Apr 2008 Join Date
    Ragezone Spam SectionLocation
    1,019Posts

    Re: SQL Error

    "Invalid column name 'Name'".



    It's either:

    A) Scripted wrong, and it doesnt find your column right.
    Or
    B) You did something or changed your db around.

  3. #3
    Account Upgraded | Title Enabled! Cancel is offline
    MemberRank
    Jan 2008 Join Date
    ItalyLocation
    337Posts

    Re: SQL Error

    What could be changed in the DB?

    i still get this error.

    ---------- Post added at 10:07 AM ---------- Previous post was at 10:04 AM ----------

    What could be changed in the DB?

    i still get this error.

  4. #4
    Account Upgraded | Title Enabled! Cancel is offline
    MemberRank
    Jan 2008 Join Date
    ItalyLocation
    337Posts

    Re: SQL Error

    Soz for double post but my thread is gonna be inactive.

    So, does No1 knows any way to fix it?

    and btw i didnt changed anything in Characters..

    So it must be in Database?
    Last edited by Cancel; 11-11-09 at 02:54 PM.

  5. #5
    Account Upgraded | Title Enabled! Cancel is offline
    MemberRank
    Jan 2008 Join Date
    ItalyLocation
    337Posts

    Re: SQL Error

    Badly =/ No ideas?

  6. #6
    Valued Member estacoz is offline
    MemberRank
    Jul 2007 Join Date
    Earth oO?Location
    140Posts

    Re: SQL Error

    Change 'Name' in the php file to AccountItem, i think thats should solve your prob..

    thank me if i helped XD

  7. #7
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: SQL Error

    it should be deleting from Items.dbo which does not have a name column, remove it and make it search and delete by CID

  8. #8
    Account Upgraded | Title Enabled! Cancel is offline
    MemberRank
    Jan 2008 Join Date
    ItalyLocation
    337Posts

    Re: SQL Error

    Woot thx i fixed it.



Advertisement