Jump to content
  • 0

Vote for Point Error


M4karov

Question


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  149
  • Reputation:   36
  • Joined:  04/01/13
  • Last Seen:  

 

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.

 


 

post-16224-0-74711900-1478175475_thumb.png

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 1

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  30
  • Reputation:   4
  • Joined:  11/20/11
  • Last Seen:  

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

Screenshot_1.jpg

Link to comment
Share on other sites

  • 0

  • Group:  Forum Manager
  • Topic Count:  282
  • Topics Per Day:  0.06
  • Content Count:  3122
  • Reputation:   1614
  • Joined:  03/26/12
  • Last Seen:  

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.

  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  12
  • Topics Per Day:  0.00
  • Content Count:  51
  • Reputation:   23
  • Joined:  04/28/12
  • Last Seen:  

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

Screenshot_1.jpg

 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

  • -2

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  1137
  • Reputation:   290
  • Joined:  04/29/13
  • Last Seen:  

Reinstall your MySQL tables for vote for points! 

Link to comment
Share on other sites

×
×
  • Create New...