collapse collapse
Menu
  • Home
  • Archives
    • * User Info
     
     
    Welcome, Guest. Please login or register.
    * Search

    * Board Stats
    • stats Total Members: 989
    • stats Total Posts: 18365
    • stats Total Topics: 2500
    • stats Total Categories: 7
    • stats Total Boards: 35
    • stats Most Online: 1144
    « previous next »
    Pages: 1 ... 3 4 [5] 6 7 8   Go Down

    Author Topic: New: Bebot Local Items database w/Icons!  (Read 78582 times)

    0 Members and 5 Guests are viewing this topic.

    Offline Malosar

    • BeBot Expert
    • ****
    • Posts: 259
    • Karma: +0/-0
      • http://www.lowerdimension.com
    Re: New: Bebot Local Items database w/Icons!
    « Reply #60 on: December 19, 2006, 02:23:33 pm »
    Quote from: buff on December 19, 2006, 09:52:34 am
    downloaded jj's sql file but when tried to run it to mysql, it will give me error msg
    not sure if it was just me or someone else got same problem?

    As always, when you are having a problem and it gives an error message.... post the error message! We're not psychic :)
    Logged
    Eternalist
    General of The Syndicate

    Offline Khalem

    • BeBot Founder
    • Administrator
    • ********
    • Posts: 1169
    • Karma: +0/-0
      • http://www.ancarim.com
    Re: New: Bebot Local Items database w/Icons!
    « Reply #61 on: December 19, 2006, 08:41:49 pm »
    Quote from: buff on December 19, 2006, 09:52:34 am
    downloaded jj's sql file but when tried to run it to mysql, it will give me error msg
    not sure if it was just me or someone else got same problem?

    I'll bite, just cause i haven't had dinner yet :)

    Sorry, i cannot find error msg "error msg" anywhere, are you sure the error msg you saw said "error msg"? :)

    Anyways, as Malosar said, help us help you :)
    Logged
    BeBot Founder and Fixer Kingpin

    Offline Sammajos

    • BeBot Rookie
    • *
    • Posts: 9
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #62 on: December 19, 2006, 10:08:12 pm »
    so many Items on this SQL File are double inside.

    #1062 - Duplicate entry '202920' for key 1



    Edit: ok, i erase the Primary key for lowid and now is ok.
    « Last Edit: December 19, 2006, 10:23:09 pm by Sammajos »
    Logged

    Offline Malosar

    • BeBot Expert
    • ****
    • Posts: 259
    • Karma: +0/-0
      • http://www.lowerdimension.com
    Re: New: Bebot Local Items database w/Icons!
    « Reply #63 on: December 19, 2006, 10:41:02 pm »
    Your supposed to drop the table before you import. It's a full dump, not a new items dump. Erasing the primary key will only slow down queries and cause problems with possible duplictes in future.
    Logged
    Eternalist
    General of The Syndicate

    Offline Sammajos

    • BeBot Rookie
    • *
    • Posts: 9
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #64 on: December 20, 2006, 09:20:19 pm »
    Look at the SQL File pls and you will see, is not a Primary Key on it. I clear my Items Table and try, to put the SQL inside (without the First Line CREATE TABLE IF NOT EXISTS items (lowid INT, highid INT, lowql INT, highql INT, name VARCHAR(50), icon INT) and become so many Error Message.

    And you have some items double inside. Example: In Line 84 is this:

    INSERT INTO items VALUES (166277, 166274, 1, 200, "% Add.Rad. Dam. Jobe Cluster - Shiny (Right-Hand)", 36018);

    in Line 94 is this:

    INSERT INTO items VALUES (166277, 166278, 1, 200, "% Add.Rad. Dam. Jobe Cluster - Shiny (Right-Hand)", 36018);

    Primary Key on low id make the Error Message.

    Thats the Problem on some other Items.

    Sorry for my bad English. I hope, someone can understand me.
    « Last Edit: December 20, 2006, 09:23:15 pm by Sammajos »
    Logged

    Offline Malosar

    • BeBot Expert
    • ****
    • Posts: 259
    • Karma: +0/-0
      • http://www.lowerdimension.com
    Re: New: Bebot Local Items database w/Icons!
    « Reply #65 on: December 20, 2006, 09:50:49 pm »
    How are you clearing your items db? Are you doing a truncate or drop? If it's just a truncate then it's probably keeping a primary key which you might have had on your old table. It probably should have a primary key anyway so it's best to drop the table and edit the sql file to set the id as primary key and let it do it's thing?
    Logged
    Eternalist
    General of The Syndicate

    Offline pusikas

    • BeBot Apprentice
    • ***
    • Posts: 161
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #66 on: December 21, 2006, 02:50:29 am »
    I can't seem to download the Items.php file from the first post. Is the URL outdated? Takes ages for me, then get a timeout. Or maybe it's just my ISP again...
    Logged
    Luuv  Bot-Keeper of Vengeance ^^*

    Offline Dabaron

    • BeBot Apprentice
    • ***
    • Posts: 163
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #67 on: December 27, 2006, 09:40:59 am »
    One other issue I was seeing is that some of the entries are unable to be added due to name field being too short (no clue how its hitting over 50 characters) per the message I was getting when importing it.  No clue why, but even if I increase the length I still get an error (even went as far as varchar(100))

    Edit:
    Looked back at old one and it was at 250 so modified this to that and seems to have fixed problem   ;)
    « Last Edit: December 27, 2006, 10:11:53 am by Dabaron »
    Logged

    Offline boogyman

    • BeBot Rookie
    • *
    • Posts: 10
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #68 on: December 27, 2006, 10:52:07 pm »
    Quote from: pusikas on December 21, 2006, 02:50:29 am
    I can't seem to download the Items.php file from the first post. Is the URL outdated? Takes ages for me, then get a timeout. Or maybe it's just my ISP again...


    I too am having troubles getting this file.

    any ideas as to what or where we could get it???
    Logged

    Offline Xenixa

    • Contributor
    • *******
    • Posts: 307
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #69 on: December 29, 2006, 11:36:21 am »
    Quote from: boogyman on December 27, 2006, 10:52:07 pm
    Quote from: pusikas on December 21, 2006, 02:50:29 am
    I can't seem to download the Items.php file from the first post. Is the URL outdated? Takes ages for me, then get a timeout. Or maybe it's just my ISP again...


    I too am having troubles getting this file.

    any ideas as to what or where we could get it???

    Sorry, my PC I ran my FTP server on got a bad case of the "lets blow up the Memory sticks-itus". Working on getting it back up and running. I'll see if I can find some free hosting space else were for the files I served.
    Logged
    <<< Hack's in Zend Studio

    All my Custom Bebot files may be Found Here <-clicky

    Offline pusikas

    • BeBot Apprentice
    • ***
    • Posts: 161
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #70 on: December 29, 2006, 01:18:30 pm »
    Can you attach them? I think up to 5MB should work. Rename them to .txt or zip and then attaching them?
    Logged
    Luuv  Bot-Keeper of Vengeance ^^*

    Offline Malosar

    • BeBot Expert
    • ****
    • Posts: 259
    • Karma: +0/-0
      • http://www.lowerdimension.com
    Re: New: Bebot Local Items database w/Icons!
    « Reply #71 on: December 29, 2006, 03:11:17 pm »
    Is this what your after?
    Logged
    Eternalist
    General of The Syndicate

    Offline Xenixa

    • Contributor
    • *******
    • Posts: 307
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #72 on: December 31, 2006, 10:33:20 am »
    My FTP server should be up and running again. May take a bit for the URL to reprop across DNS servers since it went inactive.

    BTW, wanted to say thanks to those that kept up with updating the items.sql and also give a friendly pointer. Replace INSERT INTO statements with REPLACE INTO and you won't have to drop tables. :)
    Logged
    <<< Hack's in Zend Studio

    All my Custom Bebot files may be Found Here <-clicky

    Offline shilli

    • BeBot Rookie
    • *
    • Posts: 5
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #73 on: January 13, 2007, 09:04:21 am »
    hey i have some prob  with boss_loot /boss_name wen i post in chat bossname   Afreet Ellis   i get the bossname up and loc but loot is empty  i have the items db local and i get this error msg

    this is from my db(boss-id 1      item-id 1
                             Afreet Ellis    245738)
    MySQL error (# 0) on query: SELECT itemid FROM boss_loot WHERE bossid = '1'
    Unknown column 'itemid' in 'field list'

    Warning: Invalid argument supplied for foreach() in C:\Documents and Settings\ma
    rius\Skrivebord\BeBot_0.2.10\modules\boss.php on line 69


    « Last Edit: January 13, 2007, 03:23:58 pm by shilli »
    Logged

    Offline Xenixa

    • Contributor
    • *******
    • Posts: 307
    • Karma: +0/-0
    Re: New: Bebot Local Items database w/Icons!
    « Reply #74 on: January 13, 2007, 01:34:28 pm »
    Looks like there is no item-id column in your Boss_Loot Table according to that error.
    Logged
    <<< Hack's in Zend Studio

    All my Custom Bebot files may be Found Here <-clicky
    Pages: 1 ... 3 4 [5] 6 7 8   Go Up
    « previous next »
     
    * Recent Posts
    0.8.x updates for AO by bitnykk
    [June 23, 2024, 03:19:47 pm ]
    0.8.x updates for AoC by bitnykk
    [June 23, 2024, 03:19:44 pm ]
    [AoC] special char for items module by bitnykk
    [February 09, 2024, 09:41:18 pm ]
    BeBot still alive & kicking ! by bitnykk
    [December 17, 2023, 12:58:44 am ]
    Bebot and Rasberry by bitnykk
    [November 29, 2023, 11:04:14 pm ]
    * Who's Online
    • Dot Guests: 92
    • Dot Hidden: 0
    • Dot Users: 0

    There aren't any users online.
    * Forum Staff
    bitnykk admin bitnykk
    Administrator
    Khalem admin Khalem
    Administrator
    WeZoN gmod WeZoN
    Global Moderator
    SimplePortal 2.3.7 © 2008-2024, SimplePortal