thanhlan94
Dragonot.zapto.org Owner
- Joined
- Jun 11, 2011
- Messages
- 192
- Reaction score
- 14
First of all, plz dont ban me idk if this is the right section but i need help to fix this problem
The first problem is, when i make accs the account name is correct but password is incorrect, it says this is my password 5cdab5152124d919a0c7f2bb18162a551236699c but it is not it at all
Secondly, Everything loads right when the server is about to open it says
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 8 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 432000
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 1000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 1728000
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 5000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 2592000
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 10000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 5184000
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 150000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 7776000
And also it still works but how do I get rid of this error?
Lastly, Is this an error? or do I have to download something new?
It says this in the beginning
[06/09/2014 22:17:52] >> Checking software version... failed checking - malformed file.
And this is my config code for the sqlite
sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "theforgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
And in advance thank you for helping
The first problem is, when i make accs the account name is correct but password is incorrect, it says this is my password 5cdab5152124d919a0c7f2bb18162a551236699c but it is not it at all
Secondly, Everything loads right when the server is about to open it says
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 8 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 432000
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 1000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 1728000
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 5000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 2592000
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 10000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 5184000
[06/09/2014 22:17:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 150000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 7776000
And also it still works but how do I get rid of this error?
Lastly, Is this an error? or do I have to download something new?
It says this in the beginning
[06/09/2014 22:17:52] >> Checking software version... failed checking - malformed file.
And this is my config code for the sqlite
sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "theforgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
And in advance thank you for helping