[Help] A few errors when trying to update to rev 4337

[MisterEMU]

I am updating from rev 3850 to rev 4337 (using http://www.mmowned.com/forums/emulat...blizzlike.html)

by referring to thread: http://www.mmowned.com/forums/emulat...ev-4329-a.html I think I got the required SQL files - but if not can someone give to me.

These are the errors I am getting:

When I try to execute 4156_logon_accounts

When I try to execute 4300_character_social

When I try to execute 4300_world_dbcchanges

When I try to execute 3084_logon_accounts.sql


and when I tried running ascent-logonserver.exe


Cannot log in game says information invalid.

Can someone please help me

[latruwski]

I am updating from rev 3850 to rev 4337 (using http://www.mmowned.com/forums/emulat...blizzlike.html)

by referring to thread: http://www.mmowned.com/forums/emulat...ev-4329-a.html I think I got the required SQL files - but if not can someone give to me.

These are the errors I am getting:

When I try to execute 4156_logon_accounts

When I try to execute 4300_character_social

When I try to execute 4300_world_dbcchanges

When I try to execute 3084_logon_accounts.sql


and when I tried running ascent-logonserver.exe


Cannot log in game says information invalid.

Can someone please help me

All these updates seem to be applied already....

[MisterEMU]

All these updates seem to be applied already....

then what is the problem? it doesn't seem to load the character or account database...

[MisterEMU]

can someone please help?

[Lich King]

Here one second, it's because of your accounts table. Put this into a notepad and save as an sql.

CREATE TABLE `accounts` (
  `acct` bigint(20) unsigned NOT NULL auto_increment,
  `login` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(28) collate utf8_unicode_ci NOT NULL default '',
  `encrypted_password` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  `gm` varchar(27) collate utf8_unicode_ci NOT NULL default '',
  `banned` int(1) unsigned NOT NULL default '0',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `lastip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `flags` int(11) unsigned NOT NULL default '0',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  `muted` int(30) NOT NULL default '0',
  PRIMARY KEY  (`acct`,`login`),
  UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Get rid of your old accounts table and put this one in. It should fix it

[MisterEMU]

Here one second, it's because of your accounts table. Put this into a notepad and save as an sql.

CREATE TABLE `accounts` (
  `acct` bigint(20) unsigned NOT NULL auto_increment,
  `login` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(28) collate utf8_unicode_ci NOT NULL default '',
  `encrypted_password` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  `gm` varchar(27) collate utf8_unicode_ci NOT NULL default '',
  `banned` int(1) unsigned NOT NULL default '0',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `lastip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `flags` int(11) unsigned NOT NULL default '0',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  `muted` int(30) NOT NULL default '0',
  PRIMARY KEY  (`acct`,`login`),
  UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Get rid of your old accounts table and put this one in. It should fix it

Nope doesn't work says account already exists

[Lich King]

Delete your old accounts table, and use that to make a new one

[MisterEMU]

Delete your old accounts table, and use that to make a new one

did that and put in the code and still same error...

[Lich King]

If you deleted the table, how can it still exist?

[MisterEMU]

If you deleted the table, how can it still exist?

sorry that part works but the error in the last picture... SQL Query failed due to unknown column encrypted passwrd

[MisterEMU]

sigh no one can solve this problem?...

[Lich King]

update accounts set encrypted_password = SHA(CONCAT(UPPER(login),":",UPPER(password)));

Try that

[MisterEMU]

update accounts set encrypted_password = SHA(CONCAT(UPPER(login),":",UPPER(password)));

Try that

tried still same error = / - I think I found the problem - when I replaced all the files in C:\AC Web Ultimate Repack\Server\mysql\data\logon whose name starts with "accounts" I don't get that error anymore - but I lose all my player's accounts... is there anyway to do it so I can save the accounts? I tried to do the code you gave me but it still doesn't work.

[Lich King]

Backup accounts, and then re-enter them in after you run that

[MisterEMU]

Backup accounts, and then re-enter them in after you run that

doesn't work. But latruwski helped me fixed the problem. +Rep to both of you