Xantara's Flux Renewal setting issue

[Bin4ry]

my RO schema

'CharMapServers' => array(
array(
'ServerName'	  => 'Flarism RO',
'Renewal'		 => true,
'MaxCharSlots'	=> 9,
'DateTimezone'	=> 'Asia/Kuala_Lumpur', // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)

If I use turn 'Renewal' => false it wouldn't show any error, my server is definitely the latest SVN with renewal enabled. Any solution?

Thanks in advance.

Edit: Updated more images.

Edited September 6, 2012 by darristan

[jhonix]

try to check those files in the directories given in the exception..and look for the function that has been declared, you need some error tracking,maybe those functions will not be working once you've change "Renewal" into true since its working on the opposite condition...

[Xantara]

Does your user have 'replace' and 'insert' permissions for the item_db_re table?

[Bin4ry]

If not mistaken I think it has every privileges.

[Xantara]

Ah, it's the CP code. It seems like rAthena doesn't read item_db anymore when renewal is updated (since r16523) causing a conflict with the temporary tables. I'll commit a fix soon. Thanks! =)

EDIT: Well, its true that the code doesn't need to read item_db anymore for renewal anymore.. But that doesn't seem like the solution for this problem since I can't reproduce your error with the current code...

[Bin4ry]

I could upload my whole webdocs + flux sql for you if you need to troubleshoot.

Edited September 7, 2012 by darristan

[Xantara]

I could upload my whole webdocs + flux sql for you if you need to troubleshoot.

How about using TeamViewer instead?

Anyways, I've updated the code: r1146 / 2ad4a01569. Please update and see if that fixes things.

[Bin4ry]

I guess it is basicly solved but since I manually diffed the update, the old sql query fetched still remain? Where did Flux store the caches?

Edit: Tried to use [Add Item] to add a dummy item, it works -> did send new query to item_db_re but the fetched cache file is my problem

Edited September 7, 2012 by darristan

[Xantara]

It doesn't.

I wonder why I can't reproduce. Please check your cp/data/logs/mysql/errors/ and cp/data/logs/errors/exceptions/ for any error print outs. Also set 'DebugMode' to true in cp/config/applications.php and $showExceptions to true in cp/config/error.php.

[Bin4ry]

<?php exit('Forbidden'); ?>
[2012-09-07 10:09:35] [sqlSTATE=01000] Err 1265: Data truncated for column 'attack' at row 565
[2012-09-07 10:09:36] [sqlSTATE=01000] Err 1265: Data truncated for column 'attack' at row 565
[2012-09-07 12:43:26] [sqlSTATE=01000] Err 1265: Data truncated for column 'attack' at row 565
[2012-09-07 12:55:22] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:55:24] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:55:24] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:55:28] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:55:28] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:12] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:12] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:14] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:17] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:20] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:59:33] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 13:00:05] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 13:00:09] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 13:01:33] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'

Guess is the RE update with attack:matk in the same column

Edited September 7, 2012 by darristan

[Xantara]

Hmm.. Yea, I had a feeling that was it. I don't know why mine doesn't complain tho =s

Trying to figure out if there is a way to do operations (>, =, <) on atk:matk because of the delimiter. I might have to scrap that from the search otherwise =( I'll also have to update elv. But that has a delimiter now too! Meh, lol. Anyways, I'll commit a fix for this soon - might not be today tho but it is on my TODO list. Thanks for posting this!

[Bin4ry]

Thank you for the awesome script too! Would also like to ask how the 'DropRates' => array( works in your original idea if you don't mind answering.

[Xantara]

I'm not sure what you mean by "original idea". But, the values in the DropRates array should match with whatever you put in svn/conf/battle/drops.conf

For example, if you used the following settings in your (SVN) drops.conf:

// The rate at which cards are dropped
// Cards drop at 25x and Boss cards drop at 5x
item_rate_card: 2500
item_rate_card_boss: 500

Then you would do the same in the (CP) servers.php:

// The rate at which cards are dropped
'Card'		=> 2500,
'CardBoss'	=> 500,

This will allow your CP to show the same rates as if you did @mobinfo in-game. It currently does not support Renewal Drop (RENEWAL_DROP in svn/src/config/renewal.h) yet.

EDIT:

Should be fixed in r1147 / 717fea7285

Edited October 1, 2012 by Xantara

[Bin4ry]

Hmmm... I use the Min/Max value also that's why it doesn't work for me. If you do mind adding a little TODO for ur next update which is array of Min/Max value

Edited September 7, 2012 by darristan