M4karov Posted November 3, 2016 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 149 Reputation: 37 Joined: 04/01/13 Last Seen: June 18, 2024 Share Posted November 3, 2016 Hello everybody, I would like to ask your help so that I can use that system vote for points, with the current fluxcp. Can someone help me? Here the image of the error. Vote for point used: https://rathena.org/board/topic/80121-vote-for-points-for-fluxcp-free/ Link to comment Share on other sites More sharing options...
1 Rahul Dev Posted November 12, 2016 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 30 Reputation: 4 Joined: 11/20/11 Last Seen: November 3, 2022 Share Posted November 12, 2016 Looks like the key is being treated as reserved keyword of MySQL. Please change all key to `key` (add tilt before and after) and try again. eg; https://github.com/Feefty/FluxCP_Addons-VoteForPoints/blob/master/modules/voteforpoints/index.php Link to comment Share on other sites More sharing options...
0 Akkarin Posted November 10, 2016 Group: Forum Manager Topic Count: 282 Topics Per Day: 0.06 Content Count: 3144 Reputation: 1632 Joined: 03/26/12 Last Seen: April 15 Share Posted November 10, 2016 It's likely that reinstalling won't help as older FluxCP addons are accessing player variables in the wrong location. It's looking for data that doesn't exist in a table that isn't used anymore. Change the SQL query in modules\vote4points\function.php to point to current tables instead. 1 Link to comment Share on other sites More sharing options...
0 iwillnot Posted December 19, 2018 Group: Members Topic Count: 12 Topics Per Day: 0.00 Content Count: 51 Reputation: 23 Joined: 04/28/12 Last Seen: April 22, 2022 Share Posted December 19, 2018 On 11/13/2016 at 4:33 AM, Rahul Dev said: Looks like the key is being treated as reserved keyword of MySQL. Please change all key to `key` (add tilt before and after) and try again. eg; https://github.com/Feefty/FluxCP_Addons-VoteForPoints/blob/master/modules/voteforpoints/index.php Agreed. I applied that exact fix on a fork of the code, should anyone need a copy of an updated Flux CP Vote for points addon that is tried and tested as of 2018. Either do the fix manually, or install your plugin from scratch and use the updated one I linked above. Note Not sure if this is worth noting, but my RO server runs on Hercules. The $cp_tbl which is the mapreg is still designed the same way whether rAthena or Hercules though, so that should not be a problem. Link to comment Share on other sites More sharing options...
-2 Cyro Posted November 10, 2016 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 1138 Reputation: 290 Joined: 04/29/13 Last Seen: July 20, 2024 Share Posted November 10, 2016 Reinstall your MySQL tables for vote for points! Link to comment Share on other sites More sharing options...
Question
M4karov
Link to comment
Share on other sites
4 answers to this question
Recommended Posts