Fluxcp not showing "Mob database" only.

[Chief]

Hi,

Im having problem with fluxcp. When i click the link (Mob Database) It display the list of the mobs. But once I click the MOB ID for it to show the mob information it keep saying No such monster was found. Go back. I have the mob_db and mob_db2.sql in ragnarok database. This is the first time it happened to me. Any reply will be greatly appreciated thank you.

[Lilith]

Bump!

I have same problem...

[Mystery]

What's your error log spitting out?

[Asura]

Hi Chief,

Try turning on debug mode in application.php and also error reporting in error.php. Then see what errors it gives you when you try to search for the mob.

[Aleos]

It's because ExpPer was removed from the mob_db/mob_db2 tables. You'll need to remove that column from Flux so that it reads it correctly.

Edited March 14, 2012 by Aleos

[Rabbit]

It's because ExpPer was removed from the mob_db/mob_db2 tables. You'll need to remove that column from Flux so that it reads it correctly.

How can i do that? Remove it on database? thankss

[Gerome]

go to your phpmyadmin.. then click you <You Ragnarok Database/Schema> --> mob_db2 table --> then delete will appear.

[Rabbit]

go to your phpmyadmin.. then click you <You Ragnarok Database/Schema> --> mob_db2 table --> then delete will appear.

Ah, thank you for the clarifications. There is an error when i drop mob_db2 table. It become worse than i expected.

Error
An error occurred while trying to process your request.
Please try contacting an administrator: admin@localhost

Thanks for your helps. Other user might deal with the same problem with me, so im glad if this matter can be solved.

[Asura]

Hi Rabbit,

You are not suppose to drop the mob_db nor mob_db2; you are suppose to modify the FluxCP to read without the `ExpPer`; you'd need to actually edit the php files, I'm not sure where though.

[Rabbit]

Hey! Thanks for replied, i really appreciate it! I just found something related to `ExpPer`; as you said just now in my sql folder. The name is "upgrade_svn15531_db"and the code inside that sql is :

-- `ExpPer` column removed from `mob_db` and `mob_db2` tables
ALTER TABLE `mob_db` DROP COLUMN `ExpPer`;
ALTER TABLE `mob_db2` DROP COLUMN `ExpPer`;

Do i really need to execute it on my database?

Edited May 29, 2012 by Rabbit

[Asura]

Hi Rabbit,

It is necessary for you to run the latest versions of rAthena. And then you must edit the php files of FluxCP to make the mob search without the `ExpPer` field in order for it to run correctly. I am not sure of the specifics, that's what I know you should do though.

[Meister]

Can I bump in?

Error

An error occurred while trying to process your request.

Please try contacting an administrator: admin@localhost

I have uploaded mob_db item_db of rAthena sql-files for my flux cp renewal how to fix it?

[Lelouch vi Britannia]

Same problem here also . im currently using r16182 , i added the item_db.sql and mob_db.sql in my sql db after that i click the Item Database in flux renewal this error comes out

An error occurred while trying to process your request.
Please try contacting an administrator: admin@localhost

[LCDTheOG]

same here, i'll search the flux cp files and see if i can fix this for u guys

Update: so yeah, can't seem to find the problem here, but i can't get itemdb or the mobdb to show up, really think someone good in php should take a look at this because this isnt the first time ive seen this in fluxcp

Update2: Thanx to brian~ he showed me which file it was, fluxcp/modules/monster/view.php,

$col .= 'MEXP AS mvp_exp, ExpPer, ';

delete ExpPer and the mob database should work again

Once again thanks To Brian

This only fixes the mob database, the item database is still yet to fix.

Edited June 1, 2012 by lilcooldude69

[Brian]

$col  = 'ID as monster_id, Sprite AS sprite, kName AS kro_name, iName AS iro_name, LV AS level, HP AS hp, ';
$col .= 'EXP AS base_exp, JEXP as job_exp, Range1 AS range1, Range2 AS range2, Range3 AS range3, ';
$col .= 'DEF AS defense, MDEF AS magic_defense, ATK1 AS attack1, ATK2 AS attack2, DEF AS defense, MDEF AS magic_defense, ';
$col .= 'STR AS strength, AGI AS agility, VIT AS vitality, `INT` AS intelligence, DEX AS dexterity, LUK AS luck, ';
$col .= 'Scale AS scale, Race AS race, (Element%10) AS element_type, (Element/20) AS element_level, Mode AS mode, ';
$col .= 'Speed AS speed, aDelay AS attack_delay, aMotion AS attack_motion, dMotion AS delay_motion, ';
$col .= 'MEXP AS mvp_exp, ExpPer AS mvp_exp_chance, ';

rAthena dropped the ExpPer column (r15531), this is probably what's causing the SQL query to fail.

I submitted a pull request to CalciumKid: https://github.com/calciumkid/fluxcp-renewal/pull/5/files

[Rabbit]

Special thanks for both of you, lilcooldude69 and also Brain! Again, i repeat the solution.

Your FluxCP > Modules > Monster > View.php :

Line 25 :

$col .= 'MEXP AS mvp_exp, ExpPer AS mvp_exp_chance, ';

Delete

ExpPer AS mvp_exp_chance,

Your code on Line 25 should be like this :

$col .= 'MEXP AS mvp_exp, ';

Save, and your monster database should work properly. Thats all for now.

Edited June 1, 2012 by Rabbit

[Lelouch vi Britannia]

Thanks guys for the info .But hey does anyone know how to fix the item_db.sql ? it also says

An error occurred while trying to process your request.
Please try contacting an administrator: admin@localhost

Nah Fixed i just forgot to add the item_db2.sql hehe my bad

Edited June 1, 2012 by Lelouch