Jump to content
  • 0
Tupac

Help addon fluxcp

Question

Addon: https://github.com/darrensapalo/FluxCP_Addons-VoteForPoints

Fluxcp: rAthena

Error log:

[2019-03-01 20:25:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist
[2019-03-01 20:25:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist
[2019-03-01 20:25:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist
[2019-03-01 20:25:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist
[2019-03-01 20:25:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist
[2019-03-01 20:25:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist
[2019-03-01 20:25:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist
[2019-03-01 20:25:00] [SQLSTATE=42S02] Err 1146: Table 'ragnarok.ragnarok.cp_vfp_logs' doesn't exist

My tables "cp_vfp_logs, cp_vfp_sites" :

-- phpMyAdmin SQL Dump
-- version 4.6.6deb5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Tempo de geração: 01/03/2019 às 23:27
-- Versão do servidor: 10.1.37-MariaDB-0+deb9u1
-- Versão do PHP: 7.0.33-0+deb9u1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;
/*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;
/*!40101 SET @[email protected]@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Banco de dados: `ragnarok`
--

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_vfp_logs`
--

CREATE TABLE `cp_vfp_logs` (
  `id` int(11) NOT NULL,
  `sites_id` int(11) NOT NULL,
  `timestamp_expire` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `timestamp_voted` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ipaddress` varchar(155) NOT NULL,
  `account_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Fazendo dump de dados para tabela `cp_vfp_logs`
--

INSERT INTO `cp_vfp_logs` (`id`, `sites_id`, `timestamp_expire`, `timestamp_voted`, `ipaddress`, `account_id`) VALUES
(8, 4, '2019-03-02 08:23:53', '2019-03-01 20:23:53', '189.21.164.155', 2000000);

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_vfp_sites`
--

CREATE TABLE `cp_vfp_sites` (
  `id` int(11) NOT NULL,
  `votename` varchar(25) NOT NULL,
  `voteurl` varchar(255) NOT NULL,
  `voteinterval` int(11) NOT NULL,
  `votepoints` int(11) NOT NULL,
  `imgname` varchar(255) DEFAULT NULL,
  `imgurl` varchar(255) DEFAULT NULL,
  `datetime_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Fazendo dump de dados para tabela `cp_vfp_sites`
--

INSERT INTO `cp_vfp_sites` (`id`, `votename`, `voteurl`, `voteinterval`, `votepoints`, `imgname`, `imgurl`, `datetime_created`) VALUES
(4, 'Topragnarok', 'https://topragnarok.com.br/vote/22420', 12, 1, NULL, 'https://topragnarok.com.br/topragnarokbrasil.gif', '2019-03-01 20:10:04');

--
-- Índices de tabelas apagadas
--

--
-- Índices de tabela `cp_vfp_logs`
--
ALTER TABLE `cp_vfp_logs`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `cp_vfp_sites`
--
ALTER TABLE `cp_vfp_sites`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de tabelas apagadas
--

--
-- AUTO_INCREMENT de tabela `cp_vfp_logs`
--
ALTER TABLE `cp_vfp_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT de tabela `cp_vfp_sites`
--
ALTER TABLE `cp_vfp_sites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
/*!40101 SET [email protected]_CHARACTER_SET_CLIENT */;
/*!40101 SET [email protected]_CHARACTER_SET_RESULTS */;
/*!40101 SET [email protected]_COLLATION_CONNECTION */;

 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

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.



×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.