Tera Up to date EMU Server Files

[Andy Troschke]

TieLay, seems like Your MySQL server got some corrupted tables.

You could try the following things:

Uninstall any previous MySQL version.
Run a mysql_upgrade MySQL :: MySQL 5.1 Reference Manual :: 4.4.8 mysql_upgrade — Check and Upgrade MySQL Tables
Install a MySQL Server from MySQL :: MySQL Downloads
Use another WebServer (Xampp as P5yl0 said, for example) and start this Server instead of server2go
Try a fresh Install of Windows 7

This Error means that some Data is corrupted, or can't be read. Since you got 20 of 22 Tables as a response I'd say some data is corrupt. I don't know really much about MySQL so far but it could also be some configurations from another mysql installation.

Anyway your problem should definately be gone with a fresh OS Installation.

[P5yl0]

you can test something...
run server2go

goto http://127.0.0.1/phpmyadmin
login with user:root pass: PASSWORD

delete database TERA
create database TERA
import tera-database.sql from Tera_Launcher_Source to the database
so you have a new clean one..

goto http://127.0.0.1/register
create new account

go back to phpmyadmin
make yourself GM: edit the new user add 1 to isGM in table...

test..

else i dont know @moment

Edit:
downloadezt github as zip
unzipped..
startet my webserver
startet gameserver
everything works nice...
sry but the problem must be on your system or configs...
not on server side..

[Andy Troschke]

Alright Managed to re-create the Error :P

all i had to do was a mysql_upgrade. a mysql_fix_privilege_tables may also work....

That's a bug happening when your MySQL server version isnt compatible with a table.

By the way, got no Idea why the Error happened for you. Did you play with the MySQL settings? With some databases? Is some other process affecting the MySQL server?

[famasown64]

here you go =)
http://forum.ragezone.com/f797/packetviewer-928888/

Yeah this still not tells me how to do it right. I have no idea on how to use wiresharks packet thingy

[TieLay]

P5yl0, big thanks for yours hard work, but after last update (rev 20 in github) compiled versions of GameServer & TeraLauncher still works only under x64 OS
About MySQL errors in Server2Go:
- errors still present in original builds of TeraTestServer publishing in this discussion
- I was try another web combine - it works correctly...

P.S. Maby you can give settings for Server2Go ingredients and I’ll try transfer it into Xammp and retest...
P.P.S. What the version of Windows you use for testing compilations?

[catchra]

Hi TieLay have u try ed using navicat for the MySQL?

I use it and have no errors.

im using Windows 7 Ultimate 32 (Laptop) & 64(Desktop) bit

[P5yl0]

P.S. Maby you can give settings for Server2Go ingredients and I’ll try transfer it into Xammp and retest..
you dont need any settings...
copy the ww folder to your xammp www folder and ready..
everything else has stardrd ports...
if you change them change in build/configs.. database ports etc..
and edit the files in www dir for launcher authorisation register etc to new ports..
but if you use standard port you dont have to edit anything
maybe the MYSQL user and pass
its set to
user: root
pass: PASSWORD
you find all setting in the config folder and the www/config.php


i use... Visual Studio 2012 with Win8 (64bit)
maybe github dindt do the uüpdate right cause its only a config setting ...from the source..
properties.. build.. and select x86
do this on all items...
rebuild and it should work on 32bit systems...
on my rebuild after change.. on task manager you see its marked as "32 bit"
so it should work.. so far

TeraTestServer.rar is old..
please use the GITHUB files
you can use Server2Go from the TeraTestServer package but source and build are old so far..

Yeah this still not tells me how to do it right. I have no idea on how to use wiresharks packet thingy

so far i found ...
updated first opcodes..^^ but i stuck in the warpgate..to the lobby server^^

you have read packets.. and filter out the port and ip...
after that menu> analyze follow tcp or udp stream..
after that you can select view as hex...

save it as xyz.hex and open with packet viewer and tada you see packets and encrpted ones maybe ^^
i uploaded a compiled packet viewer version some posts back ..

[TieLay]

So I was try run .\build\gameserver.exe on Windows 2003 Server STD x64 RUS SP2 it's says like an elder - it's not valid win32 application

So perhaps it's happens because yours compilation and settings supports only Latin Codepages and in other language systems can't be use, if it have exists i'll recomend use UTF8 and multilingual support.

So, i'll try recompile sources for my systems & try execute again

[P5yl0]

why latin.. i am from germany .. i have normal standards every OS uses .. US/DE (Unicode UTF8)
what else shoudl i use.. german language with kyrilic ?!?

#sorry
but when the source works on other pcs i have had requests who told me it works..
so the error should be on your system not our!

you are between at this time the first with this error!

and valid 32 bit iss x86!!!!

i compiled the new build in x86.. after start in taskmanager it shows running as 32 bit...!!!
if you dont get the compiled version to run compile it for yourself...
the source iss free...
set your properties of build and compile.!!!
wheres the problem?!?

[TieLay]

problem in unworkable compilations, but i search how to compile C# sources without Microsoft Visual Studio 2012 of any editions, i can't broke copyright law and use pirated version, but i programming in JAVA use InteliJ IDEA Community edition.
I'll try ask help from friend with Microsoft Visual Studio 2012 for compile and test.
Sorry for my convictions...

[P5yl0]

hmm if i remeber right..
you can download a free 30day trial edition of VS
or an student version...

google an you ll find

[famasown64]

I tried your way but the packetviewer crashes when I try to open the .hex file

[TieLay]

So my friend can't compile sources, because you use project format Microsoft Visual Studio 2012, but this IDE not support Windows XP & Windows Server 2003.
And i use and have access this system class to(unsupportable by Microsoft Visual Studio 2012)
So i think about use VirtualBox to install Trial Windows 7 & Microsoft Visual Studio 2012 for compile sources.
Nice Joke...
And wait results of yours hard work to get more perspective...

[P5yl0]

wtf what do you want..
if you want a dinner for breakfast
go bake it yourself..

sorry but this work is not my source..
this source is from this thread i only done some changes..
and its from beginning VS C# !!!
i dont know with what you work..


i havent changed anything ide or else..

if you not want to work with my changes..
look in the first post download the source form there..
else get a trial version of VS 2012

[famasown64]

TieLay: You should be happy that atleast somebody continued to work with this source. And already has fixed a lot of issues and is even updating it.
And as I said before: Remember this is still in ALPHA there will be many bugs.
If you can't compile this source its your problem. I have tested it with xp 32bit & 64bit, windows 7 32 & 64bit. No problems. You just have to download visual studio 2012. There is always a free trial.
Please stop annoying this awesome programmer.