Tupac Posted February 28, 2019 Share Posted February 28, 2019 fluxcp rathena addon: Click vote site error. [pt-BR] Quando clico para votar. Quote Link to comment Share on other sites More sharing options...
0 hendra814 Posted February 28, 2019 Share Posted February 28, 2019 4 hours ago, spawnn said: fluxcp rathena addon: Click vote site error. [pt-BR] Quando clico para votar. Try this one https://rathena.org/board/topic/60686-fluxcp-voteforpoints-npc/ Quote Link to comment Share on other sites More sharing options...
0 Tupac Posted February 28, 2019 Author Share Posted February 28, 2019 4 hours ago, hendra814 said: Try this one https://rathena.org/board/topic/60686-fluxcp-voteforpoints-npc/ same problem Quote Link to comment Share on other sites More sharing options...
0 Mael Posted February 28, 2019 Share Posted February 28, 2019 Use this. https://github.com/darrensapalo/FluxCP_Addons-VoteForPoints Quote Link to comment Share on other sites More sharing options...
0 Tupac Posted February 28, 2019 Author Share Posted February 28, 2019 3 hours ago, Mael said: Use this. https://github.com/darrensapalo/FluxCP_Addons-VoteForPoints Its been tested and the same erro occurred Quote Link to comment Share on other sites More sharing options...
0 Haikenz Posted February 28, 2019 Share Posted February 28, 2019 I just looked at the error logs in the cpanel, and it is repeating the table name, thus stating that the table does not exist. [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist This table "cp_vfp_logs" has in the database. Quote Link to comment Share on other sites More sharing options...
0 Tupac Posted February 28, 2019 Author Share Posted February 28, 2019 On 3/1/2019 at 4:02 AM, Haikenz said: I just looked at the error logs in the cpanel, and it is repeating the table name, thus stating that the table does not exist. [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist This table "cp_vfp_logs" has in the database. i have only one table cp_vfp_logs and cp_vfp_sites in mysql View log: [2019-02-28 22:25:36] [SQLSTATE=42000] Err 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = '#CASHPOINTS' AND account_id = '2000000'' at line 1 edit: <?php exit('Forbidden'); ?> [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.acc_reg_num_db' doesn't exist [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42000] Err 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = '#CASHPOINTS' AND account_id = '2000000'' at line 1 [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.acc_reg_num_db' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.acc_reg_num_db' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:25:36] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:04] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:04] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:04] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:04] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:04] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:04] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:04] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:04] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:05] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:05] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:05] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:05] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:05] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:05] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:05] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 22:29:05] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist Quote Link to comment Share on other sites More sharing options...
0 Haikenz Posted March 1, 2019 Share Posted March 1, 2019 [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.acc_reg_num_db' doesn't exist config/addon.php#L41 'cashpoints' => 'acc_reg_num_db' to 'cashpoints' => 'acc_reg_num' 1 Quote Link to comment Share on other sites More sharing options...
0 Tupac Posted March 1, 2019 Author Share Posted March 1, 2019 1 hour ago, Haikenz said: [2019-02-28 22:25:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.acc_reg_num_db' doesn't exist config/addon.php#L41 'cashpoints' => 'acc_reg_num_db' to 'cashpoints' => 'acc_reg_num' <?php exit('Forbidden'); ?> [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist I have table Quote Link to comment Share on other sites More sharing options...
0 Haikenz Posted March 1, 2019 Share Posted March 1, 2019 8 minutes ago, spawnn said: <?php exit('Forbidden'); ?> [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:47:58] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist [2019-02-28 19:48:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist I have table I also have the same problem Quote Link to comment Share on other sites More sharing options...
0 Tupac Posted March 1, 2019 Author Share Posted March 1, 2019 has been double ragnarok ? 'ragnarok.ragnarok.cp_vfp_logs' Quote Link to comment Share on other sites More sharing options...
0 hendra814 Posted March 1, 2019 Share Posted March 1, 2019 (edited) 11 hours ago, spawnn said: Its been tested and the same erro occurred when you use vfp form the link i gave. are you already import the sql files on this folder schemas\logindb - cp_v4p_sites.sql - cp_v4p_votelogs.sql - cp_v4p_voters.sql Edited March 1, 2019 by hendra814 Quote Link to comment Share on other sites More sharing options...
0 Haikenz Posted March 1, 2019 Share Posted March 1, 2019 5 hours ago, hendra814 said: when you use vfp form the link i gave. are you already import the sql files on this folder schemas\logindb - cp_v4p_sites.sql - cp_v4p_votelogs.sql - cp_v4p_voters.sql I use them all, but still the error continues [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist Quote Link to comment Share on other sites More sharing options...
0 hendra814 Posted March 1, 2019 Share Posted March 1, 2019 24 minutes ago, Haikenz said: I use them all, but still the error continues [2019-02-28 20:01:34] [SQLSTATE=42S02] Err 1146: Table 'ragnarok_main.ragnarok_main.cp_vfp_logs' doesn't exist i think rathena flux cp have some modification, because on my flux vfp error too. but with the different problem Quote [Fri Mar 01 16:02:13.397411 2019] [php7:notice] [pid 6624:tid 1836] [client ::1:52912] PHP Notice: Undefined index: HTTP_X_FORWARDED_FOR in C:\\xampp\\htdocs\\Rathena\\addons\\voteforpoints\\modules\\voteforpoints\\vote.php on line 16, referer: http://www.localhost/Rathena/?module=voteforpoints Quote Link to comment Share on other sites More sharing options...
0 Tupac Posted March 1, 2019 Author Share Posted March 1, 2019 8 hours ago, hendra814 said: when you use vfp form the link i gave. are you already import the sql files on this folder schemas\logindb - cp_v4p_sites.sql - cp_v4p_votelogs.sql - cp_v4p_voters.sql edit names in filles addon ? vfp_sites_sql => cp_v4p_sites.sql vfp_sites_sql => cp_v4p_votelogs.sql acc_reg_num => cp_v4p_voters.sql Quote Link to comment Share on other sites More sharing options...
0 Haikenz Posted March 6, 2019 Share Posted March 6, 2019 Have you been able to find the solution yet? Quote Link to comment Share on other sites More sharing options...
0 Tupac Posted March 14, 2019 Author Share Posted March 14, 2019 On 3/6/2019 at 11:19 AM, Haikenz said: Have you been able to find the solution yet? Infelizmente não Quote Link to comment Share on other sites More sharing options...
0 Sanasol Posted April 15, 2019 Share Posted April 15, 2019 Applied some fixes, should work now Yet another fork: https://github.com/S-anasol/FluxCP_Addons-VoteForPoints 1 Quote Link to comment Share on other sites More sharing options...
0 Hakahay Posted May 3, 2019 Share Posted May 3, 2019 On 4/15/2019 at 6:43 PM, Sanasol said: Applied some fixes, should work now Yet another fork: https://github.com/S-anasol/FluxCP_Addons-VoteForPoints Unable to vote for the server. Err no. 3 'PointsType' => "vote", // credit, vote, cash Quote Link to comment Share on other sites More sharing options...
0 Tupac Posted May 3, 2019 Author Share Posted May 3, 2019 21 hours ago, Hakahay said: Unable to vote for the server. Err no. 3 'PointsType' => "vote", // credit, vote, cash @edit No solved. Not working, 'PointsType' => "vote", // credit, vote, cash Quote Link to comment Share on other sites More sharing options...
0 Sanasol Posted May 5, 2019 Share Posted May 5, 2019 @spawnn, @Hakahay Check "data/logs" for mysql errors and post it here or on my github fork. Checked on local fluxcp 'PointsType' => "vote" No errors, works good. Did you apply sql schema changes? https://github.com/S-anasol/FluxCP_Addons-VoteForPoints/tree/master/schemas/logindb Quote Link to comment Share on other sites More sharing options...
0 M a p l e Posted May 7, 2019 Share Posted May 7, 2019 PHP version 5.6, 7.0 ~ 7.1 error working in 7.3 for me Quote Link to comment Share on other sites More sharing options...
0 Sanasol Posted May 8, 2019 Share Posted May 8, 2019 5 hours ago, KeyMaster said: PHP version 5.6, 7.0 ~ 7.1 error working in 7.3 for me weird, what error you get on 5.6-7.1? Could you check data/logs/mysql/errors or data/logs/errors/exception? Quote Link to comment Share on other sites More sharing options...
0 leeroy Posted June 28, 2020 Share Posted June 28, 2020 v4p not work user make first vote the become the point if 12h vote again vote not work i must delete the vote log per hand than work its can every body help me sorry for my bad eng Quote Link to comment Share on other sites More sharing options...
0 DoomSlayer Posted November 17, 2020 Share Posted November 17, 2020 (edited) tested it, but after 12h when you click again to vote he just adds the points to the player but don't open the voting page, if you delete the logs it works but after he have a log of one account he doesn't work for a second time. Edited November 17, 2020 by DoomSlayer Quote Link to comment Share on other sites More sharing options...
0 Trafalgar13 Posted January 25, 2021 Share Posted January 25, 2021 solved ? Quote Link to comment Share on other sites More sharing options...
fluxcp rathena
addon:
Click vote site error.
[pt-BR]
Quando clico para votar.
Link to comment
Share on other sites