Jump to content
  • 0

Flux CP item Database and Mob Database not showing


Limestone

Question


  • Group:  Members
  • Topic Count:  155
  • Topics Per Day:  0.03
  • Content Count:  647
  • Reputation:   16
  • Joined:  11/21/11
  • Last Seen:  

Please help me on this problem! Thank you! /no1

Link to comment
Share on other sites

10 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   2
  • Joined:  08/11/12
  • Last Seen:  

On 2/9/2012 at 9:09 PM, Ehcloprom said:

Put the modsql db and itemdbsql files into your mysql ragnarok database.

hello a noob question, where can I get the itemdbsql and the modsql to import then into my database

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  82
  • Reputation:   11
  • Joined:  01/01/12
  • Last Seen:  

Put the modsql db and itemdbsql files into your mysql ragnarok database.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi Rage,

In addition to Obliterate's post; make sure the item_db.sql and mob_db.sql is properly imported in the same database as your cp_ tables.

  • Upvote 1
  • MVP 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  155
  • Topics Per Day:  0.03
  • Content Count:  647
  • Reputation:   16
  • Joined:  11/21/11
  • Last Seen:  

Hi Asura and Obliterate, Thanks for replying.. its working.. but my another problem is in the Castle Navigation, i already remove the "//", but the Castles not showing the guilds that conquered the agits..

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  82
  • Reputation:   11
  • Joined:  01/01/12
  • Last Seen:  

I'm not sure I'll try to get it working on my flux.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi Rage,

Are your cp_* tables located in the same database as your rAthena tables?

Edited by Asura
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  155
  • Topics Per Day:  0.03
  • Content Count:  647
  • Reputation:   16
  • Joined:  11/21/11
  • Last Seen:  

no.. i make another database for CP..

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  12
  • Topics Per Day:  0.00
  • Content Count:  113
  • Reputation:   2
  • Joined:  10/29/12
  • Last Seen:  

same problem. Run sql script got the tables ready. item_db.sql CP just ends up with internal server error

I used the item module to add items but.. Iget an error.. cant add. I dont even know what identifier is on the fields

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  13
  • Reputation:   1
  • Joined:  11/29/12
  • Last Seen:  

same problem. Run sql script got the tables ready. item_db.sql CP just ends up with internal server error

I used the item module to add items but.. Iget an error.. cant add. I dont even know what identifier is on the fields

I just had this issue..

solution was found by uncommenting on servers.php the lines that are as follows

// 'Database'   => 'ragnarok', 

of course, where it says ragnarok you should put you database name.

Even though it says that if it's not specified it will default to DbConfig.Database, looks like it's not working right.

Update: I reinstalled the CP and the problem was persistant.. checking the database i noticed the following schemas were missing:

cp_charprefs

cp_itemshop

cp_redeemlog

cp_xferlog

So i just installed them "by hand" importing the sqls from data/schemas/charmapdb and now it's working again

Edited by a1252962
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  12
  • Topics Per Day:  0.00
  • Content Count:  113
  • Reputation:   2
  • Joined:  10/29/12
  • Last Seen:  

same problem. Run sql script got the tables ready. item_db.sql CP just ends up with internal server error

I used the item module to add items but.. Iget an error.. cant add. I dont even know what identifier is on the fields

I just had this issue..

solution was found by uncommenting on servers.php the lines that are as follows

// 'Database'   => 'ragnarok', 

of course, where it says ragnarok you should put you database name.

Even though it says that if it's not specified it will default to DbConfig.Database, looks like it's not working right.

Update: I reinstalled the CP and the problem was persistant.. checking the database i noticed the following schemas were missing:

cp_charprefs

cp_itemshop

cp_redeemlog

cp_xferlog

So i just installed them "by hand" importing the sqls from data/schemas/charmapdb and now it's working again

sorry hadn't updated this. Fixed this a loooong time ago. but thanks though ;)

Closed.

Link to comment
Share on other sites

×
×
  • Create New...