Bin4ry Posted September 6, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Share Posted September 6, 2012 (edited) 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 Link to comment Share on other sites More sharing options...
jhonix Posted September 6, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 57 Reputation: 0 Joined: 05/20/12 Last Seen: November 23, 2012 Share Posted September 6, 2012 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... Link to comment Share on other sites More sharing options...
Xantara Posted September 7, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share Posted September 7, 2012 Does your user have 'replace' and 'insert' permissions for the item_db_re table? Link to comment Share on other sites More sharing options...
Bin4ry Posted September 7, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Author Share Posted September 7, 2012 If not mistaken I think it has every privileges. Link to comment Share on other sites More sharing options...
Xantara Posted September 7, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share Posted September 7, 2012 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... Link to comment Share on other sites More sharing options...
Bin4ry Posted September 7, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Author Share Posted September 7, 2012 (edited) I could upload my whole webdocs + flux sql for you if you need to troubleshoot. Edited September 7, 2012 by darristan Link to comment Share on other sites More sharing options...
Xantara Posted September 7, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share Posted September 7, 2012 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. Link to comment Share on other sites More sharing options...
Bin4ry Posted September 7, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Author Share Posted September 7, 2012 (edited) 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 Link to comment Share on other sites More sharing options...
Xantara Posted September 7, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share Posted September 7, 2012 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. Link to comment Share on other sites More sharing options...
Bin4ry Posted September 7, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Author Share Posted September 7, 2012 (edited) <?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 Link to comment Share on other sites More sharing options...
Xantara Posted September 7, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share Posted September 7, 2012 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! Link to comment Share on other sites More sharing options...
Bin4ry Posted September 7, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Author Share Posted September 7, 2012 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. Link to comment Share on other sites More sharing options...
Xantara Posted September 7, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share Posted September 7, 2012 (edited) 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 Link to comment Share on other sites More sharing options...
Bin4ry Posted September 7, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Author Share Posted September 7, 2012 (edited) 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 Link to comment Share on other sites More sharing options...
Question
Bin4ry
my RO schema
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 by darristanLink to comment
Share on other sites
13 answers to this question
Recommended Posts