· 9 years ago · May 22, 2017, 03:16 PM
1
2login:
3#define HOST "bhs-panel.01.heavyhost.com.br"
4#define USUARIO "heavyhos_NatanM"
5#define SENHA "1n&eKK3(Os~N"
6#define DATABASE "heavyhos_NatanM"
7
8Erros:
9[10:25:08 05/21/17] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'heavyhos_NatanM'@'ca01.heavyhost.com.br' (using password: YES)
10[10:25:08 05/21/17] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away (Query: "SELECT id,novas_mensagens,email FROM mp_contas WHERE user='Onibus_NPC1' LIMIT 1")
11[10:25:08 05/21/17] [WARNING] cache_get_row_count - no active cache
12[10:25:08 05/21/17] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away (Query: "INSERT INTO mp_contas (user) VALUES ('Onibus_NPC1')")
13[10:25:08 05/21/17] [WARNING] cache_insert_id - no active cache
14[10:25:08 05/21/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
15[10:25:08 05/21/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
16[10:25:08 05/21/17] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away (Query: "SELECT id,novas_mensagens,email FROM mp_contas WHERE user='Onibus_NPC2' LIMIT 1")
17[10:25:08 05/21/17] [WARNING] cache_get_row_count - no active cache
18[10:25:08 05/21/17] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away (Query: "INSERT INTO mp_contas (user) VALUES ('Onibus_NPC2')")
19[10:25:08 05/21/17] [WARNING] cache_insert_id - no active cache
20[10:25:08 05/21/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
21[10:25:08 05/21/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
22[10:25:08 05/21/17] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'heavyhos_NatanM'@'ca01.heavyhost.com.br' (using password: YES)
23[10:25:08 05/21/17] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'heavyhos_NatanM'@'ca01.heavyhost.com.br' (using password: YES)
24[10:25:08 05/21/17] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'heavyhos_NatanM'@'ca01.heavyhost.com.br' (using password: YES)
25
26E Preciso que criem essas tabelas:
27```
28-- --------------------------------------------------------
29
30--
31-- Estrutura da tabela `mp_contas`
32--
33
34CREATE TABLE IF NOT EXISTS `mp_contas` (
35 `id` int(11) NOT NULL,
36 `user` varchar(24) NOT NULL,
37 `novas_mensagens` int(11) NOT NULL,
38 `email` varchar(128) NOT NULL
39) ENGINE=MyISAM DEFAULT CHARSET=utf8;
40
41-- --------------------------------------------------------
42
43--
44-- Estrutura da tabela `mp_msgs`
45--
46
47CREATE TABLE IF NOT EXISTS `mp_msgs` (
48 `id` int(11) NOT NULL,
49 `de_contaid` int(11) NOT NULL,
50 `para_contaid` int(11) NOT NULL,
51 `horario` int(11) NOT NULL,
52 `data` varchar(20) NOT NULL,
53 `lida` int(11) NOT NULL,
54 `Mensagem` varchar(128) NOT NULL
55) ENGINE=MyISAM DEFAULT CHARSET=utf8;
56
57--
58-- Indexes for dumped tables
59--
60
61--
62-- Indexes for table `mp_contas`
63--
64ALTER TABLE `mp_contas`
65 ADD PRIMARY KEY (`id`);
66
67--
68-- Indexes for table `mp_msgs`
69--
70ALTER TABLE `mp_msgs`
71 ADD PRIMARY KEY (`id`);
72
73--
74-- AUTO_INCREMENT for dumped tables
75--
76
77--
78-- AUTO_INCREMENT for table `mp_contas`
79--
80ALTER TABLE `mp_contas`
81 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
82--
83-- AUTO_INCREMENT for table `mp_msgs`
84--
85ALTER TABLE `mp_msgs`
86 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
87/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
88/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
89/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
90```
91
92E To com esse erros no server_log:
93[10:23:07] [sampgdk:error] Too many callback arguments (at most 32 allowed)
94[10:23:07] [debug] Run time error 19: "File or function is not found"
95[10:23:07] [debug] mysql_connect
96[10:23:07] [debug] mysql_errno
97[10:23:07] [debug] mysql_query
98[10:23:07] [debug] mysql_close
99[10:23:07] [debug] mysql_format
100[10:23:07] [debug] cache_get_row_count
101[10:23:07] [debug] cache_get_field_content_int
102[10:23:07] [debug] cache_get_field_content
103[10:23:07] [debug] cache_insert_id
104[10:23:07] [debug] cache_delete
105
106Eles ficam repetindo sem parar ja mudei a versão do MYSQL testei o servidor no meu próprio PC modo LAN e não da so o que não conecta na database nem sei qual problema é e o TCAdmin o painel ta meio lento demora pra carregar ja olhei na minha net e nem é nela.