Vote for Point Error

[M4karov]

 

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/

 

[Rahul Dev]

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

[Akkarin]

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.

[iwillnot]

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.

 

[Cyro]

Reinstall your MySQL tables for vote for points!