Jump to content

database error


Recommended Posts


  • Group:  Members
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  162
  • Reputation:   3
  • Joined:  01/23/12
  • Last Seen:  

pagkatapos kong di maayos ng husto ang 3ceam server dahil sa sobrang dami ng problema at halos wala support sa site nagpalita ako ng rathena. ang problema ko ngayon nacompile ko na at inayos ko na lahat sa mysql ko pero nagkaroon ako ng error. tama naman lahat ng ginawa ko. sana may makatulong

post-1761-0-82910000-1327587724_thumb.jpg

Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

conf/inter_athena.conf

// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  162
  • Reputation:   3
  • Joined:  01/23/12
  • Last Seen:  

i have done that already sir, i have input my password in mysql there at inter_athena.conf already. do i need to create a schema for logs like log schema like athena or just execute it inside ragnarok schema? i dont think the rathena will have any issues about putting it in a log schema nor ragnarok right? hmm ill go check my build again, clen and recompile my server. thanks for the reply

Edited by myrmiddon
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  47
  • Topics Per Day:  0.01
  • Content Count:  633
  • Reputation:   78
  • Joined:  11/14/11
  • Last Seen:  

siguraduhin mong ang database na iniligay mo sa inter_athena.conf ay existing at lahat ng tables na nasa sql-files folder ng iyong svn ay nakaimport.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  162
  • Reputation:   3
  • Joined:  01/23/12
  • Last Seen:  

hello sir napagana ko na pero nga bay bago ako nanaman hehe sensya na bago lang ha at sana mapag tiisan nyo ako kung humingi ako ng tulong. pinipilit kong mapagana pero may mga minimal errors sa database ko ngayon. ito po error ko ngayon

post-1761-0-50823900-1327680348_thumb.jpg

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  35
  • Topics Per Day:  0.01
  • Content Count:  103
  • Reputation:   0
  • Joined:  11/13/11
  • Last Seen:  

anong rev gamit mo??.. and kung nka setup na yan yung line na error erase mo nalang.. kasi gngamit lang nmn ung mob_db sa flux interg or sa ibang web na ksama ang mob and item database

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  162
  • Reputation:   3
  • Joined:  01/23/12
  • Last Seen:  

late reply.. ayun naayos ko na po ito. sana conf folder lang pala and iset mo yung enable logs sa sql. naka disable kasi kaya kahit meron na sa sql di parin nya binabasa logs ko. thanks sa mga reply. medyo busy sa pagaayos ng server.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...