Character Creation fails & Login Failed

[Pawaox-Z]

SOLVED - PLEASE READ MY LAST REPLY IF YOU HAVE SAME ISSUE


(Using latest ARCEMU, rev 3819)
(Using latest WhyDB, rev 148 )

Greetings!

After a long downtime, I have decided to return to the emu community!!!!! Cheers!

This time, I decided to bend over horrible repacks, and actually do it the real way.
Yesterday, I followed these two guides;

http://mmotop.org/arcemu-guides/2925-compiling-3-3-5-arcemu-core-database-not-so-advanced-user.html
&
http://www.mmowned.com/forums/world-of-warcraft/emulator-servers/guides-tutorials/224985-epic-guide-setting-up-running-arcemu-server-scratch.html

I figured out everything rather quickly, and everything worked just fine. I was reliefed, realising that it wasn't as difficult as I expected, untill I tried to create a character...

I click "Create New Character" > Pick what I want with a random name, press "Accept", and it returns me to the character screen with no changes... Tried to make some premade chars from HeidiSQL, and when I try to login on those, all I get is "Login Failed"

I've read alot of helpful threads, and done everything told in them in an attempt to solve the issue. Nothing has worked

This is one of them (Most say the same, so just linking this)

Character Creation!

Do anyone know what to do? I've used all SQLs in \sql\character_updates
Also ran the \sql\3800_character_structure.sql several times :<

Any help would be appreciated - If you need any information to help me fix this, just ask!

Regards
Pawaox

[Pawaox-Z]

Hey! Stoneharry told me to download SQLyog, and re-attempt to execute the queries -
I've tried to make it all easier to read, unlike the main post, which is a horribly boring read - If the colours are annoying, let me know

Here is the results.

3759_playerbugreports.sql
Query : CREATE TABLE 'playerbugreports' ( 'UID' int(10) unsigned NOT NULL, 'AccountID' int(10) unsigned NOT NULL, 'TimeStamp' i...

Error Code : 1050
Table 'playerbugreports' already exists

3770_playerspells.sql
Query : -- Dropping the old field ALTER TABLE 'characters' DROP COLUMN 'spells'

Error Code : 1091
Can't DROP 'spells'; check that column/key exists

3771_playerdeletedspells.sql
Query : -- Dropping the old field ALTER TABLe 'characters' DROP COLUMN 'deleted_spells'

Error Code : 1091
Can't DROP 'deleted_spells'; check that column/key exists

3774_playerskills.sql
Query : -- Dropping the old field ALTER TABLE 'characters' DROP COLUMN 'skills'

Error Code : 1091
Can't DROP 'skills'; check that column/key exists

3800_db_version.sql
Took me a few different ways to actually execute this script. It would just say nothing, untill like sixth time i tried

Query : CREATE TABLE 'arcemu_db_version' ( 'LastUpdate' int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY ('LastUpdate') ) ENGIN...

Error Code : 1050
Table 'arcemu_db_version' already exists


---------------------------------------------------------------

This leaves out two error Codes;

1050: Table "X" Already exists <I checked the tables, and they did exists
1091: Can't Drop "TableY" - Check if exists <- I checked the tables, read below



ERROR CODES 1091

SQL 3770
Attempts to drop column "spells" - There is nothing named "spells" in neither "character" or "world" --- [There is "playerspells" in character]


SQL 3771
Attempts to drop column "deleted_spells" - There is no such thing

SQL 3774
Attempts to drop column "skills" - There is no such thing


I tried to give out as much information as possible, but again, I'm still a newbie with the whole idea of compiling your own server.

From my newbie eyes, it looks like my WhyDB is corrupt? Perhaps?

EDIT!
After posting this message, I closed down my;
MySQL;
Arcemu-logonserver
&
Arcemu-World

Then when I tried to re-start them, World gives me an error - A picture say a thousand words, so will pop one up (: [It looks kinda streched, since it apparently took a screenshot from both my screens and made it into one. ye, I have 2 screens to my computer xD)

Character database is missing the table 'arcemu_db_version' OR the table doesn't contain any rows. Can't validate database version. Exiting.

[Pawaox-Z]

Bumpzzzzz
Can't continue my epic adventure without assistance :<

[stoneharry]

Execute 3800_db_version.sql into the character database. Should work.

[Pawaox-Z]

I have already done that :<!

Yet, I did it again, and nothing has changed - Still can't create chars :<

Is it possible that you can upload your database? Without your own stuff ofcourse?
Or do you have anything else I can try :< I'm completely lost

[stoneharry]

Your stuck with a DB that basically is failing, my opinion is that you/ArcEmu have made a small mistake along the lines that has screwed everything else up.

Delete your database (drop), update to the latest revision, try again.

[Pawaox-Z]

EDIT;

I decided to screw over user guides (SORRY <3) And went to ArcEmus Wiki, and followed their tut completelty! (Deleted all previous programs, just to re-install to be safe) - And it worked out
For anyone reading this thread, having the same issue, you should do the same!

Windows
Linux

DoubleEdit; Thanks for all your help stoneharry, a CupcakeRepCookie will appear shortly :P

"You must spread some Reputation around before giving it to stoneharry again."
Aw damn :<