Database 0.3 to 0.2

[Pietia]

fixxxxeeddd

 

[Mikuch]

i dont think there is any script to make it

 

[Pietia]

i dont think there is any script to make it

i think that there should be the sql scripts somtghing like migraging from tfs 0.3 to clean otserv on otfans.

 

[Colandus]

what u mean downgrade database??

 

[Pietia]

what u mean downgrade database??

the 0.3 database doesn't work on 0.2 TFS mystic spirit ;s

 

[Zonet]

Losing connection or crashes? if crashes..

man just restart your server every 24 hours.. It's simple.

Why having it 40+ hours? as i see in yours.

 

[Pietia]

Losing connection or crashes? if crashes..

man just restart your server every 24 hours.. It's simple.

Why having it 40+ hours? as i see in yours.

it's the first time such uptime because there is no more then 200 + or more ppl
yeah crash now ...

 

[TriamerA]

Ye changing it back to 0.2 is verry difficult, how many scripts you would have to change lol?? I was thinking about that also but I've resigned ;/
Lost like 100 players because of the crashes

 

[Pietia]

Ye changing it back to 0.2 is verry difficult, how many scripts you would have to change lol?? I was thinking about that also but I've resigned ;/
Lost like 100 players because of the crashes

0 scripts change lol.

 

[Colandus]

yes need change all database scripts BUT solution is in my signature (click "my scripts" and then db functions )

 

[Pietia]

yes need change all database scripts BUT solution is in my signature (click "my scripts" and then db functions )

it's my errors already posted in ur topic there

SQL ERROR DBResult::GetDataInt() action_id
SQL ERROR DBResult::GetDataInt() banned_by
SQL ERROR DBResult::GetDataInt() time
SQL ERROR DBResult::GetDataInt() account
SQL ERROR DBResult::GetDataInt() reason_id
SQL ERROR DBResult::GetDataInt() action_id
SQL ERROR DBResult::GetDataInt() banned_by
SQL ERROR DBResult::GetDataInt() time
SQL ERROR DBResult::GetDataInt() account
SQL ERROR DBResult::GetDataInt() reason_id
SQL ERROR DBResult::GetDataInt() action_id
SQL ERROR DBResult::GetDataInt() banned_by
SQL ERROR DBResult::GetDataInt() time
SQL ERROR DBResult::GetDataInt() account

at start spam of this
and then when i'm trying to login

> MySQL ERROR mysql_real_query: SELECT `id`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 123 Unknown column 'type' in 'field list'

after some time i think that this is not that what i'm trying to do ;s.
i want database convert from 0.3 to 0.2 .
it should look something like that http://otfans.net/wiki/index.php/Migrating_from_TFS_to_clean_OTServ

 

[Colandus]

ehh you mean like you want to use TFS 0.3 but with 0.2 database? :S

 

[Mikuch]

ehh you mean like you want to use TFS 0.3 but with 0.2 database? :S

nope he mean to convert 0.3 database to 0.2
Now he is runing 0.3 server but he got a lot crashes cuz of mysql and he want to downgrade 0.3 database to work with 0.2 tfs

 

[Colandus]

Oki well...

It tell you there is no column name 'type', you need to add it to database...

Same with ban... Either it's a 'string' but should be 'int' or it don't exist.

 

[Pietia]

Oki well...

It tell you there is no column name 'type', you need to add it to database...

Same with ban... Either it's a 'string' but should be 'int' or it don't exist.

done what about houses if i have binary saving ?

 

[Colandus]

No clue about that part :/

 

[Pietia]

No clue about that part :/

I have a big problem right now with "account name " and with account id ...
on 0.2 the "account name" don't exist ,so much ppl cannot login into game is there any way to fix it out ?

 

[Colandus]

well maybe u can make like (in PHPMyAdmin)

UPDATE accounts SET account_id = account_name

?? or maybe players have account_id ??

 

[Pietia]

well maybe u can make like (in PHPMyAdmin)

UPDATE accounts SET account_id = account_name

?? or maybe players have account_id ??

no ;s
#1062 - Duplicate entry '0' for key 1

 

[Colandus]

hmmm what about....

UPDATE accounts AS a SET a.account_id = a.account_name