ascent-logonserver.exe sql query error ... plz help

[BillyBob31]

After my ascent-logonserver.exe loads in it i get this error that keeps repeating ... plz help. Below is the error

Sql query failed due to [Unknow column ,encrypted_password' in 'field list'], Query: [SELECT acct, login, password, encryted_password, gm, flags, banned, forceLanguage, muted FROM accounts]


Fixed ........ i redid my own compiles made them work =) all good now ..... figured it out myself

[SectorSeven]

Your accounts database is outdated.

[BillyBob31]

Your accounts database is outdated.

i just ran the new compile .. and implamented it and this is what happened ... =/ doh ..... hmmm

Yeah well ok i went back to my ascent rev core 4111 cause the newest core 4157 is the 1 that i compiled and has that problem and that 1 guy that made 4157 compile like over 50 all day alone and kept messing up .. so ill wait till tomorrow and compile a new 1 that comes out past 4157 ... so ill make a new compile when i see a newer 1 from someone else other then that 1 guy that made 4157 =) so ill compile more tomorrow =)

[Lich King]

What DB are you using?

[SectorSeven]

^^^^^ clueless...
NCDB doesnt do accounts db

[latruwski]

you forgot to run the latest logon updates:

alter table accounts add column encrypted_password VARCHAR(42) NOT NULL DEFAULT '' AFTER Password;

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

always check ascentsvn:
http://mmoforge.org/svn/ascent/trunk/sql/
login: anonymous
no password
for the latest updates if you compile latest core revs

grtz

[BillyBob31]

you forgot to run the latest logon updates:

alter table accounts add column encrypted_password VARCHAR(42) NOT NULL DEFAULT '' AFTER Password;

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

always check ascentsvn:
http://mmoforge.org/svn/ascent/trunk/sql/
login: anonymous
no password
for the latest updates if you compile latest core revs

grtz

Is the svn at this

http://mmoforge.org/svn/ascent/trunk/sql/

ascent rev cores also for compiling?
cause they have the same number just not as many as the ascent rev cores i get at .... are they the same if not why can i get the same at both but the sql 1 is not as many ....?

http://mmoforge.org/svn/ascent

[latruwski]

Is the svn at this

http://mmoforge.org/svn/ascent/trunk/sql/

ascent rev cores also for compiling?
cause they have the same number just not as many as the ascent rev cores i get at .... are they the same if not why can i get the same at both but the sql 1 is not as many ....?

http://mmoforge.org/svn/ascent

to fix your error just run the updates i posted above... in the ascent SVN ofcourse there are more updates (sql) then core revs...you have to run all updates till you reach the rev number you use or till you reach the rev number that is closest to it but smaller number If the updates give an error, dont mind... just continue... if it gives an error it probably means your DB has the update already applied...grtz

[leptoon]

Update your SQL database or update your Ascent compile.

It is wise to compile your own Ascent and use the latest NCDB. If you need help still, you can add me to MSN.

[email protected]

I'll be glad to help.

[BillyBob31]

You guys say to update me stuff when i run the newest ascent rev core and ncdb when i see them in svn i compile and run them so what else should i update .... i also think its that kids ascent rev core ... cause i went back to my 4111 and it works great the new 1 by him 4157 is the 1 that gave that error

[latruwski]

You guys say to update me stuff when i run the newest ascent rev core and ncdb when i see them in svn i compile and run them so what else should i update .... i also think its that kids ascent rev core ... cause i went back to my 4111 and it works great the new 1 by him 4157 is the 1 that gave that error

again for this error:

Sql query failed due to [Unknow column ,encrypted_password' in 'field list'], Query: [SELECT acct, login, password, encryted_password, gm, flags, banned, forceLanguage, muted FROM accounts]

run these queries on your logonDB:

alter table accounts add column encrypted_password VARCHAR(42) NOT NULL DEFAULT '' AFTER Password;

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

why you still need updates if you have latest stuff? simply becuz NCDB does NOT make the structure... and they do NOT make the logonDB...i told you where you can find the updates... you need to run the updates from all the revs below the one you use.... (the 2 i posted between code tags will fix the error you posted!)

grtz