kickazz08 Posted September 23, 2012 Group: Members Topic Count: 29 Topics Per Day: 0.01 Content Count: 61 Reputation: 0 Joined: 03/25/12 Last Seen: January 12, 2014 Share Posted September 23, 2012 need help on this one.. : DB error - Table 'ragnarok.loginlog' doesn't exist[Debug]: at ..\src\login\loginlog_sql.c:75 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '0.0.0.0', 'login server', '100', 'login server started')[info]: Connection request of the char-server 'rAthena' @ 127.0.0.1:6121 (account: 's1', pass: 'p1', ip: '127.0.0.1')[sql]: DB error - Table 'ragnarok.loginlog' doesn't exist Quote Link to comment Share on other sites More sharing options...
Heero Yuy Posted September 23, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 68 Reputation: 12 Joined: 09/05/12 Last Seen: December 22, 2012 Share Posted September 23, 2012 Upload the log.sql (you can find that file inside the sql-files folder) then restart your server. Quote Link to comment Share on other sites More sharing options...
Emistry Posted September 23, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: 17 hours ago Share Posted September 23, 2012 make sure your setting inside this file is correct trunk/conf/inter_athena.conf // 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 and make sure you did import the SQL Table here... trunk/sql-files/logs.sql Quote Link to comment Share on other sites More sharing options...
KaitoKid Posted October 31, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 268 Reputation: 27 Joined: 12/06/11 Last Seen: March 13, 2015 Share Posted October 31, 2012 (edited) Noticed this error also. I think there is a typo with the sql script. But you can execute this code anyway make sure you select ragnarok as your default schema CREATE TABLE IF NOT EXISTS `loginlog` ( `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip` varchar(15) NOT NULL DEFAULT '', `user` varchar(23) NOT NULL DEFAULT '', `rcode` tinyint(4) NOT NULL DEFAULT '0', `log` varchar(255) NOT NULL DEFAULT '', KEY `ip` (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1$$ Edited October 31, 2012 by Kaito_Kid Quote Link to comment Share on other sites More sharing options...
Jazz Posted October 31, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 90 Reputation: 0 Joined: 09/29/12 Last Seen: July 10, 2020 Share Posted October 31, 2012 check mo ung log.sql kung nalagay mo sa SQL mo Quote Link to comment Share on other sites More sharing options...
chatterboy Posted January 20, 2013 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 308 Reputation: 24 Joined: 11/26/12 Last Seen: Friday at 02:57 PM Share Posted January 20, 2013 naka lagay naman sya. d kaya d pede sa mysql 5.5.2.4 ? 3ceam nga pede e... nakuh bug yata ene! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.