Flux CP item Database and Mob Database not showing

[Limestone]

Please help me on this problem! Thank you!

[ffman22]

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

[Ehcloprom]

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

[Asura]

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.

[Limestone]

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..

[Ehcloprom]

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

[Asura]

Hi Rage,

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

Edited February 10, 2012 by Asura

[Limestone]

no.. i make another database for CP..

[pandaplaygames]

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

[a1252962]

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 November 30, 2012 by a1252962

[pandaplaygames]

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.