MySQL Database Error, Please Help!

[Synergy]

Hello guys..

I'm almost going insane.. been trying to solve this for 5-6 hours now..

I had many errors with my database so in the long run I ended up getting it to start and work with changing "localhost" to "127.0.0.1"

But now when I open my server
Try to login to 1/1
To make an account (admin account)

It says wrong acc/pw?!!?!?

I get this:

[24/07/2012 02:49:38] mysql_real_query(): SELECT `id`, `name`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `name` = '1' LIMIT 1;: MYSQL ERROR: Unknown column 'name' in 'field list'
[24/07/2012 02:49:38] mysql_store_result(): SELECT `id`, `name`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `name` = '1' LIMIT 1;: MYSQL ERROR: Unknown column 'name' in 'field list'

Please help me, rep++

 

[Cronox]

You get created account 1/1 in SQL?

 

[Synergy]

What do you mean?

 

[Cronox]

You have sqlite or sql?
error don't say any error scripts? only see query error?

 

[Synergy]

Look,

I use SQL
My server starts up, connects to database through "127.0.0.1" not "localhost"
but when I try to login it says "wrong acc/pass"

And I get this:

[24/07/2012 02:43:56] mysql_real_query(): SELECT `id`, `name`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `name` = '1' LIMIT 1;: MYSQL ERROR: Unknown column 'name' in 'field list'
[24/07/2012 02:43:56] mysql_store_result(): SELECT `id`, `name`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `name` = '1' LIMIT 1;: MYSQL ERROR: Unknown column 'name' in 'field list'

 

[Cronox]

try this query in phpmyadmin SQL

ALTER TABLE `accounts` ADD `name` VARCHAR(255);

 

[Synergy]

ok but should I put in the query then try to log in? or restart anything before I log in?

 

[Cronox]

shutdown your ot.. add query and start again

 

[Synergy]

Nop, still wrong acc/pw

BUT!! I dont get the errors now...

Now it says NOTHING in console..

 

[Cronox]

ahhh! i know why
in your config.lua you have
encryption = "sha1"
for fixed need go to
SQL and execute query:

UPDATE accounts SET password=SHA1(password);

 

[Synergy]

No actually not..

This is what I got:
-- SQL
sqlType = "mysql"
passwordType = "plain"

 

[Cronox]

You use TFS 0.4_DEV?
try changed passwordtype ="sha1"
and execute query i say

 

[Loney]

http://otland.net/f16/no-support-private-svn-forgotten-server-0-4-here-132978/

 

[Synergy]

nop still not working..
Thanks for your time Cronox..

Gotta go sleep so I'll just uninstall and try again tomorrow