Unknown Database 'Characters' (Johved)

[Aldun]

Hi,

I just changed from Johveds repack 3.1 to 3.0.9 because its more bugfree. Everything is set up, but I still get one error.
I (obviously) dont have an acc yet, but when I go the the Accountcreator or Account management (doesn't matter which i use, i get the same error), it says "unknown database 'characters'". looking to the error, I assume he's missing the characters database.

In my Navicat (8, lite), I only have the Databases:

Information_schema / Logon / Mysql / Test / World.

As you see, im missing characters. Someone said putting Logon where I put the #####'s instead of Characters, but that didnt work either:

<LogonDatabase Hostname = "127.0.0.1"
               Username = "root"
               Password = "root"
               Name     = "Logon" <--########
               Port     = "3306"
               Type     = "1">

And

<CharacterDatabase Hostname = "127.0.0.1" Username = "root" Password = "root" Name = "logon"<--######## Port = "3306">

Any chance anyone can help me? +Rep for who can help
Thanks!
-Aldun

[Choices]

make sure char db is named characters

[Aldun]

Well, in Navicat you can't rename the databases? When you click on properties (or w/e it is), the field where you see the DB name is grayed out so you can't change it.

Information_schema / Logon / Mysql / Test / World.
are the only ones I have.

[Dynashock]

I just uploaded the charachter's structure sql from my arcemu trunk here: SQL pastebin - collaborative debugging tool
Try creating a new database (i.e. characters), make sure you have it selected and then run that sql.

[Aldun]

Ok, I created new database, but now I (still) got this at database:




Also, the characters DB (which I run in query from what you linked), is very similiar (but not 100%) as the Logon, is that supposed to be?





Thanks!

[Dynashock]

I just noticed; 'accounts' is actually missing from your character database. We'll need to get you a sql for it.

I hope this one works: SQL pastebin - collaborative debugging tool - it's a dump from my own database, I hope it's compatible, because I do have another one but that one's most likely outdated.
Again, make sure you have selected your characters database first.

[Aldun]

Maybe I'm just stupid, but how do you add the file? "Dump SQL file" tries to save something, so doesn't work. A query (seems) to be doing nothing either and "Executing Batch File" says:

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD' at line 1
[Err] /*!40100 SET CHARACTER SET latin1;*/
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


#
# Table structure for table 'accounts'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "accounts" (
  "acct" bigint(20) unsigned NOT NULL auto_increment,
  "login" varchar(255) NOT NULL default '',
  "password" varchar(28) NOT NULL default '',
  "encrypted_password" varchar(40) NOT NULL default '',
  "gm" varchar(27) NOT NULL default '',
  "banned" int(10) unsigned NOT NULL,
  "lastlogin" timestamp NOT NULL default '0000-00-00 00:00:00',
  "lastip" varchar(15) NOT NULL default '',
  "email" varchar(50) NOT NULL default '',
  "flags" int(11) unsigned NOT NULL default '0',
  "forceLanguage" varchar(5) NOT NULL default 'enUS',
  "muted" int(30) NOT NULL default '0',
  "banreason" varchar(255) default NULL,
  PRIMARY KEY  ("acct","login"),
  UNIQUE KEY "acct" ("acct")
) AUTO_INCREMENT=52 /*!40100 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci*/;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Dynashock]

I kind of failed at my dump probably, it's a HeidiSQL one. Hm, I'm not sure. Have you tried removing the first stuff until ### Table structure yet? If all fails I can give you one that's sure to work but probably outdated. If you want you can add my msn (find it in my personal info) so we can try to work this out.