Jump to content
  • 0

Addon VoteForPoints


Question

Recommended Posts

  • 0
Posted

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.

  • 0
Posted
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

 

  • 0
Posted
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

  • 0
Posted
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

  • 0
Posted (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 by hendra814
  • 0
Posted
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

Sem-t-tulo.png

  • 0
Posted
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

Sem-t-tulo.png

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

 

  • 0
Posted
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

  • 0
Posted
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

  • 0
Posted
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?

  • 0
Posted

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

  • 0
Posted (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 by DoomSlayer
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...