• 0
spawnn

Addon VoteForPoints

Question

fluxcp rathena

addon: 

vote.png

Click vote site error.

[pt-BR]

Quando clico para votar.

 

 

Share this post


Link to post
Share on other sites

17 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites
  • 0
2 hours ago, 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

Share this post


Link to post
Share on other sites
  • 0

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

 

Edited by spawnn

Share this post


Link to post
Share on other sites
  • 0
[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'

  • Upvote 1

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0

has been double  ragnarok  ?

'ragnarok.ragnarok.cp_vfp_logs'

Share this post


Link to post
Share on other sites
  • 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

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
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

 

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
On 3/6/2019 at 11:19 AM, Haikenz said:

Have you been able to find the solution yet?

Infelizmente não 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...