No database selected and #.items not found
I am trying to add my own weapons to my WoW private server, and I'm using Heidisql.
But I get an error when I'm trying to execute it to a database.
I don't know which database, I am going to execute the batch file to.
Can you help me?
When I start SQL and import the batch file, and press execute, it says:
SQL Error: No database selected
and when i chose mysql in the left and press execute it says:
---------------------------
Error
---------------------------
SQL Error: Table 'mysql.items' doesn't exist
What is the problem here?
Thank you
- Anders
"mysql" is a system database which contains privilege stuff and it's surely not the correct one for your intented action.
It should help you if you see the databases like folders and the tables like files just like in your windows explorer.
Uhm, I tried to use HeidiSQL, and I chose items in the folder Ascent, and I execute the SQL-file to the table "Items".
It works fine, but when I log into my server and add the weapon by the ID, it says:
6343891 is not a valid weapon or ID (Don't remember)
Ehm, so I tried to make the ID shorter, but the same problem.
Then I tried to execute it again, and it says:
Duplicate entry for 6343891 key 1.
??
6343891 is not a valid weapon or ID (Don't remember)
Does not sound like a familiar errormessage... Please post the exact errormessage here so we can help you.
Duplicate entry for 6343891 key 1.
is a quite good and descriptive message for the error you got: There is a unique key on a column which has already a row with that value.
Hallo,
bei mir wird ebenso ständig beim Uplaod gesagt: SQL Fehler (1046: No Database collected. Ich verstehe das gar nicht. Ich habe als Benutzer den Namen meiner neuen Datenbank in der korrekten Schreibweise angegegeben, auch das Passwort stimmt. Die ausgewählte Datenbank, die ich in dem Feld Datenbanken angegeben habe, ist die von dem Backup. Hier habe ich auch die gewünscht Schreibweise angegeben. Wo liegt denn nur der Fehler?
Grüße
Please login to leave a reply, or register at first.