• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

I need help with some errors

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
 
1. See the rules if you dont want an infraction: http://otland.net/threads/rules-and-regulations-for-the-support-board.217087/
2. You problem with account manager and that password: That password is encrypted in sha1, You can change to "356a192b7913b04c54574d18c28d46e6395428ab" so that you can use password "1". Either this or I dont understand what you are trying to say.
3. For the other errors A. post them in [ CODE ] tags an B. This problem is probably caused by an outdated sqlite system. I suggest you use MySQL
 
K than you and i will try to use mysql and for number 2 i ment like if my password for expample is 39xkek9 and it says something other than that i can't log in
 
Back
Top