New: Bebot Local Items database w/Icons!

[Links]

  Links
     Browse SVN
     SVN Commit log
     Documentation (Wiki)
  Developers
     Taskmanager

Advanced search

[Malosar]

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

[Khalem]

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

[Sammajos]

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.

[Malosar]

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.

[Sammajos]

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.

[Malosar]

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?

[pusikas]

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...

[Dabaron]

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   

[boogyman]

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???

[Xenixa]

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.

[pusikas]

Can you attach them? I think up to 5MB should work. Rename them to .txt or zip and then attaching them?

[Malosar]

Is this what your after?

[Xenixa]

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.

[shilli]

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

[Xenixa]

Looks like there is no item-id column in your Boss_Loot Table according to that error.