[SQL] DB error - Table 'ragnarok.loginlog' doesn't exists

[Matrixfox]

I've been running into some problems I can't solve on my own. There's gotta be something I'm missing...

The first picture shows my computer running "rathena Rev 15429" with database log issue... I end up getting frustrated and downloaded my old server (rathena Rev 15162) from my cloud. She worked with out a problem, even after a connect and disconnect. I'm using the newer SQL database files while running the older server might I add. May I ask how to fix this, and what also changed from the older to the new?

---

Uploaded with ImageShack.us

Source links

---

http://bytes.com/top...ut-im-sure-does

http://www.eathena.w...howtopic=234481

google search

[Xantara]

Your sql log settings are enabled but your database names is still using txt settings. To fix this, open your log_athena.conf and read the contents below the "Logging tables/files" title. Notice that there are two "names" for every log database; the first is the txt (defaulted), and the second one is the SQL (which is commented out).

Edit: QQ, sorry, I misread. Lol

Try checking your conf/inter_athena.conf and conf/import/inter_conf.txt file for the log_db_db setting. Make sure it says 'log' instead of 'ragnarok'?

Edited January 12, 2012 by Xantara

[Matrixfox]

Oh wow thanks!!! That was simple, you just taught me a whole lot right now...

PS: Thanks for not removing your last message.

Also I have absolutely nothing in conf/import/inter_conf.txt

Edited January 12, 2012 by matrixfox

[Critica]

I have the same problem here.. does anyone here know how to fix this?? everthing seems fine..

i tried eathena SVN and everything is working..

and yea.. there's nothing in conf/import/inter_conf.txt

[ngek202]

post your inter_athena.conf

[Critica]

sir ngek202, i have the same Problem.. eto ung skin

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: ragnarok

sql.db_password: ragnarok

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: ragnarok

char_server_pw: ragnarok

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: ragnarok

map_server_pw: ragnarok

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog ( i tried changing loginlog to "log" but stil the same)

tnx for the help btw

[Matrixfox]

Edit your inter_athena.conf to your database. In this case it would look like this.

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: log

log_codepage:

log_login_db: loginlog

Edited February 24, 2012 by matrixfox

[DDR31416]

gracias

[Reinz]

I have the same problem but now solved ! thx

 

log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: log <<<<<<<<<<
log_codepage:
log_login_db: loginlog