• 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!

Help me with my errors and stuffs PLEASE

luddeaerful

New Member
Joined
Mar 22, 2009
Messages
20
Reaction score
0
Location
Sweden, Ljungby
First of all: Sorry if i'm kinda stupid, and not online that often. I'm also very sorry if i posted this thread in the wrong part of the forum, admin, please change it then

Facts to know:
I'm kinda new with everything with OTs to do, i mean: XAMPP, SQL, Scripting in other languages than AutoIT, and everything else that a noob wouldn't understand.

I got TFS Distro
I got this datapackage (8.6 datapackage)
I got TFS database
I got 8.54 RL map (both unedited and edited)


And if anyone want to take a look at all my files you can download it HERE


Now get to bussiness.

[10/05/2011 18:57:13] The Forgotten Server, version 0.3.6 (Crying Damson)
[10/05/2011 18:57:13] Compiled with GNU C++ version 3.4.5 (mingw special) at Aug 12 2010, 03:23:23.
[10/05/2011 18:57:13] A server developed by Elf, slawkens, Talaturen, KaczooH, Lithium, Kiper, Kornholijo.
[10/05/2011 18:57:13] Visit our forum for updates, support and resources: http://otland.net.

[10/05/2011 18:57:13] >> Loading config (config.lua)
[10/05/2011 18:57:13] > Using plaintext encryption
[10/05/2011 18:57:13] >> Checking software version... up to date!
[10/05/2011 18:57:14] >> Fetching blacklist
[10/05/2011 18:57:14] >> Loading RSA key
[10/05/2011 18:57:14] >> Starting SQL connection
[10/05/2011 18:57:14] >> Running Database Manager
[10/05/2011 18:57:14] > Trigger: oninsert_account_viplist does not exist, creating it...
[10/05/2011 18:57:14] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: main.account_viplist (CREATE TRIGGER "oninsert_account_viplist" BEFORE INSERT ON "account_viplist" FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'INSERT on table `account_viplist` violates foreign: `account_id`') WHERE NEW."account_id" IS NULL OR (SELECT "id" FROM "accounts" WHERE "id" = NEW."account_id") IS NULL; SELECT RAISE(ROLLBACK, 'INSERT on table `account_viplist` violates foreign: `player_id`') WHERE NEW."player_id" IS NULL OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL; END;)
[10/05/2011 18:57:14] > Trigger: onupdate_account_viplist does not exist, creating it...
[10/05/2011 18:57:14] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: main.account_viplist (CREATE TRIGGER "onupdate_account_viplist" BEFORE UPDATE ON "account_viplist" FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'UPDATE on table `account_viplist` violates foreign: `player_id`') WHERE NEW."player_id" IS NULL OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL; END;)
[10/05/2011 18:57:14] > WARNING: You cannot switch from hashed passwords to plain text, change back the passwordType in config.lua to the passwordType you were previously using.
[10/05/2011 18:57:14] > Optimized database.
[10/05/2011 18:57:14] >> Loading items
[10/05/2011 18:57:14] [Error - Items::loadFromOtb] Another (client) version of items.otb is required.

[10/05/2011 18:57:14] > ERROR: Unable to load items (OTB)!



As you probably can see i get some errors, and not only the unable to load items...

Now my question is: Where do i download the right items.otb file for me?
And also, help me doing the other errors too.


And one extra thing before i quit:

when i go to: http://127.0.0.1/xampp/
and then PHPMyAdmin
It says:

#1130 - Host 'localhost' is not allowed to connect to this MySQL server

And now in swedish one extra thing: phpMyAdmin försökte skapa en förbindelse till MySQL-servern, men servern nekade uppkopplingen. Kontrollera värd, användarnamn och lösenord i config.inc.php och förvissa dig om att de stämmer överens med informationen från administratören av MySQL-servern.

Translated to english: phpMyAdmin tried to make a connection to the MySQL server, but the server rejected the connection. Check the host, username and password in config.inc.php and make sure that they are consistent with information from the administrator of the MySQL server.


BIG TY TO ALL OF YOU THAT HELP ME WITH THIS:cool:
 
First of all: I dont get the "phpmyadmin - #1130 - Host 'localhost' is not allowed to connect to this MySQL server - Server Fault"
That's something i need help with. I don't know what a "terminal" is...

I changed the sql type to mysql
And i changed the items.otb file

This is the error i get now:

Failed connecting to database - MYSQL ERROR: Host 'localhost' is not allowed to connect to this MySQL server (1130)

> ERROR: Couldn't estabilish connection to SQL database!



This is the whole server load:

[11/05/2011 09:02:45] The Forgotten Server, version 0.3.6 (Crying Damson)
[11/05/2011 09:02:45] Compiled with GNU C++ version 3.4.5 (mingw special) at Aug 12 2010, 03:23:23.
[11/05/2011 09:02:45] A server developed by Elf, slawkens, Talaturen, KaczooH, Lithium, Kiper, Kornholijo.
[11/05/2011 09:02:45] Visit our forum for updates, support and resources: http://otland.net.

[11/05/2011 09:02:45] >> Loading config (config.lua)
[11/05/2011 09:02:45] > Using plaintext encryption
[11/05/2011 09:02:45] >> Checking software version... up to date!
[11/05/2011 09:02:45] >> Fetching blacklist
[11/05/2011 09:02:45] >> Loading RSA key
[11/05/2011 09:02:45] >> Starting SQL connection
[11/05/2011 09:02:45] Failed connecting to database - MYSQL ERROR: Host 'localhost' is not allowed to connect to this MySQL server (1130)

[11/05/2011 09:02:45] > ERROR: Couldn't estabilish connection to SQL database!
 
Last edited:
As you, Bogart, says is that i should follow this tutorial or what? Cause my friend in school is a real nerd, and i think he know: He said that i totally screwed up my XAMPP. So should i uninstall XAMPP and go with the "uniform server"? or is that hell of a much more to do than just edit a few things with this?
 
Last edited:
Lol, you don't need to re install your xampp just yet, there may be a easier solution

Just check if your MYSQL service is running on xampp.

If it is, make sure it is 3306 port, get then, mysql tools, and try logging into your mysql server. If you still cannot post what it says.
 
It still says the same thing... "#1130 - Host 'localhost' is not allowed to connect to this MySQL server ", exactly as my first post, but i dont get what you mean with mysql tools? I can reach to the XAMPP 'site' (127.0.0.1 / localhost) but not to PHPMyAdmin and it says exactly the same on the distro when i run it...

Thanx
 
Call me stupid, but i just don't get it...


I run mysql.exe in the direction Cykotitan says it. Nothing happends, just a "cmd-window" that pop up and dissapears really fast without any text...

And i still don't get what i should do with the link? It says open up a terminal? lol wtf? what's a terminal? and what should i do next? explain to me, cause i'm really new at this.
 
Last edited:
terminal. on windows they call it 'cmd' (Command Prompt)

Start -> Run -> cmd -> cd C:\xampp\mysql\bin -> mysql -u root --host=127.0.0.1 -p<yourpassword>
 
Thank you very much! Reputation ++ ;)



edit: hmm.. when i write in cmd what u writed, it says: "Det går inte att hitta sökvägen" which in english means 'Can not find the path' Help please!
 
Last edited:
Send teamviewer access details to [email protected], when you have done that like my post so I know. Then I can connect to your computer and get things set up for you.
 
Okey, i liked this for an hour and u still haven't seen it? i send you e-mail too.. hurry up i need to study :<



Edit: You was too late... Log onto skype tomorrow, and we'll talk.

Edit 2: now it was 24 hour ago...
 
Last edited:
Back
Top