Vincent 4 Posted November 22, 2013 (edited) ALTER TABLE item_db ADD COLUMN `bindonequip` tinyint(1) unsigned DEFAULT NULL AFTER `view`;ALTER TABLE item_db_re ADD COLUMN `bindonequip` tinyint(1) unsigned DEFAULT NULL AFTER `view`; MySQL-ERROR MySQL meldet: Duplicate column name 'bindonequip' ALTER TABLE item_db ADD COLUMN `bindonequip` tinyint(1) unsigned DEFAULT NULL AFTER `view`; Duplicate column name 'bindonequip' ALTER TABLE item_db2 ADD COLUMN `bindonequip` tinyint(1) unsigned DEFAULT NULL AFTER `view`; I had used lastest hercules sql files and this allready there. But the error came also up.... Edited November 22, 2013 by Vincent Quote Share this post Link to post Share on other sites
SSky 2 Posted November 23, 2013 Same problem, I had the problem because of Hercules' new item_db structure Quote Share this post Link to post Share on other sites
Zezicla 2 Posted November 23, 2013 we need a upgraded indeed i hope some1 is on the job Quote Share this post Link to post Share on other sites
Mumbles 193 Posted November 25, 2013 Updated FluxCP for compatibility with the latest build. Commits: Compatibilized item module. @6628ce9 Minor bug fix and corrections. @6ac6a7f Issues: 'bindonequip' missing from item module 2 JulioCF and Uzieal reacted to this Quote Share this post Link to post Share on other sites
Zezicla 2 Posted November 25, 2013 very nice job sir THNX +1 Quote Share this post Link to post Share on other sites
Vincent 4 Posted November 26, 2013 Updated FluxCP for compatibility with the latest build. Commits: Compatibilized item module. @6628ce9 Minor bug fix and corrections. @6ac6a7f Issues: 'bindonequip' missing from item module Nice. But for some reason if you loggin at open "my acc" it say Storage Items of PlayerThere are no storage items on this account. But there are items at the storage. Quote Share this post Link to post Share on other sites
Mumbles 193 Posted November 26, 2013 Nice. But for some reason if you loggin at open "my acc" it say Storage Items of PlayerThere are no storage items on this account. But there are items at the storage. Hi Vincent, Are you sure you've updated all of the files from the first commit? I've tested both stock themes on both pre-renewal and renewal modes of FluxCP on the latest version, and the Jellopy I've stored appears properly. If you have a custom theme, you will have to update your theme manually; the differentiation in most FluxCP theme infrastructures are minimal in most cases, so you shouldn't have much of an issue doing this. Quote Share this post Link to post Share on other sites
Vincent 4 Posted November 26, 2013 Thanks it works now. Found the issue. Quote Share this post Link to post Share on other sites
Mumbles 193 Posted November 26, 2013 Thanks it works now. Found the issue. Would you mind sharing the the issue you found and your solution (in case others come across it as well)? Quote Share this post Link to post Share on other sites
Vincent 4 Posted November 27, 2013 i thought i dont need to Import itemdb_re because i run a pre renewal Server. but cp need all 3 dbs in sql to work. Quote Share this post Link to post Share on other sites
Mumbles 193 Posted November 27, 2013 i thought i dont need to Import itemdb_re because i run a pre renewal Server. but cp need all 3 dbs in sql to work. That doesn't sound right at all. If you're using a pre-renewal server, make sure 'Renewal' is set to false in config/servers.php. Quote Share this post Link to post Share on other sites
mybitch 9 Posted December 3, 2013 Does this panel includes paid add-ons? Such as gametime. Hercules supported it. Quote Share this post Link to post Share on other sites
Mumbles 193 Posted December 3, 2013 Does this panel includes paid add-ons? Such as gametime. Hercules supported it. To my knowledge, there is currently no functionality for paid accounts with FluxCP. The most that can be done is selling some sort of voucher through the item shop, but that's not really native support for the pay-to-play functionality. Quote Share this post Link to post Share on other sites
Shatowolf 9 Posted December 4, 2013 Getting this error. Message: Failed to import/replace rows from table 'ragnarok.item_db2' Any fix? thanks Help me with this error. Thank you! Untitled.jpg Same here. Quote Share this post Link to post Share on other sites
Vincent 4 Posted December 4, 2013 Help me with this error. Thank you! Untitled.jpg Same here. Please set the DebugMode in application.php to 'DebugMode' => true, And post the errror that came up. Quote Share this post Link to post Share on other sites
Cranel 1 Posted December 4, 2013 how to change the theme witdh to fixed ? (reduce the width) Quote Share this post Link to post Share on other sites
Mumbles 193 Posted December 4, 2013 Getting this error. Message: Failed to import/replace rows from table 'ragnarok.item_db2' Any fix? thanks Check config/servers.php and verify that the database and user information there are correct. If they are, additionally check to see if you have an SQL version of item_db2 imported into your database (Flux looks for this). You can either use a blank item_db2, or import your existing one. Read this article about db2sql to find out how to do so: http://herc.ws/wiki/index.php?title=Db2sql how to change the theme witdh to fixed ? (reduce the width) You can modify the page container in your theme's css/style.css file. Look for the ID #page and adjust settings for the container there. Quote Share this post Link to post Share on other sites
Cranel 1 Posted December 5, 2013 sorry for the question i know this is made for hercules fluxcp but can i use this with fluxcp-re without problems Quote Share this post Link to post Share on other sites
Shatowolf 9 Posted December 5, 2013 Please set the DebugMode in application.php to 'DebugMode' => true, And post the errror that came up. Hi, This is the error i got. after i debug it., any solution? will appreciate. thanks. Error: Flux_ErrorMessage: MySQL error (SQLSTATE: 21S01, ERROR: 1136): Column count doesn't match value count at row 1File: /home/playragn/public_html/cp1/lib/Flux/Connection/Statement.php:27 Quote Share this post Link to post Share on other sites
Vincent 4 Posted December 5, 2013 Hi, This is the error i got. after i debug it., any solution? will appreciate. thanks. Error: Flux_ErrorMessage: MySQL error (SQLSTATE: 21S01, ERROR: 1136): Column count doesn't match value count at row 1File: /home/playragn/public_html/cp1/lib/Flux/Connection/Statement.php:27 Then you are not using lastest Hercules Flux CP or you use the wrong itemdb.sql/itemdb_2.sql. 1 Mumbles reacted to this Quote Share this post Link to post Share on other sites
Shatowolf 9 Posted December 5, 2013 Then you are not using lastest Hercules Flux CP or you use the wrong itemdb.sql/itemdb_2.sql. ohh yeah, i just forgot i'm using rathena itemdb.sql / itemdb_2.sql, i just gonna convert it. thanks man. Quote Share this post Link to post Share on other sites
Mumbles 193 Posted December 6, 2013 sorry for the question i know this is made for hercules fluxcp but can i use this with fluxcp-re without problems Use what with fluxcp-re? 1 bleachftl reacted to this Quote Share this post Link to post Share on other sites
Zezicla 2 Posted December 15, 2013 new job for our fluxcp team http://herc.ws/board/topic/3479-update-our-fluxcp-with-this-new-rev/#entry22967 Quote Share this post Link to post Share on other sites
pr3p 39 Posted December 15, 2013 Yes please update xantara's release new security update 5 days ago https://github.com/missxantara/fluxcp-ra Quote Share this post Link to post Share on other sites
Mumbles 193 Posted December 16, 2013 new job for our fluxcp team http://herc.ws/board/topic/3479-update-our-fluxcp-with-this-new-rev/#entry22967 Yes please update xantara's release new security update 5 days ago https://github.com/missxantara/fluxcp-ra Merged in c546cc9. 1 pr3p reacted to this Quote Share this post Link to post Share on other sites