What's new

Problem z odpaleniem OTS'a

Status
Not open for further replies.

henasek

Advanced User
Joined
Aug 17, 2011
Messages
161
Reaction score
0
Witam!
Robi? OTS'a , a hosting mam netshoot.pl
Ale gdy go w??czam wyskakuj? takie b??dy :
Code:
[17:56:38.152] mysql_real_query(): CREATE TRIGGER `ondelete_players`  BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE  `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE  `owner` = OLD.`id`; END; - MYSQL ERROR: TRIGGER command denied to user  'baza_6055'@'localhost' for table 'players' (1142)
 [17:56:38.152] > Trigger: ondelete_players does not exist, creating it...
 [17:56:38.149] mysql_real_query(): CREATE TRIGGER `oncreate_players`  AFTER INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills`  (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10); INSERT INTO  `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1,  10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`)  VALUES (NEW.`id`, 2, 10); INSERT INTO `player_skills` (`player_id`,  `skillid`, `value`) VALUES (NEW.`id`, 3, 10); INSERT INTO  `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4,  10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`)  VALUES (NEW.`id`, 5, 10); INSERT INTO `player_skills` (`player_id`,  `skillid`, `value`) VALUES (NEW.`id`, 6, 10); END; - MYSQL ERROR:  TRIGGER command denied to user 'baza_6055'@'localhost' for table  'players' (1142)
 [17:56:38.148] > Trigger: oncreate_players does not exist, creating it...
 [17:56:38.145] mysql_real_query(): CREATE TRIGGER `ondelete_guilds`  BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN UPDATE `players` SET  `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM  `guild_ranks` WHERE `guild_id` = OLD.`id`); END; - MYSQL ERROR: TRIGGER  command denied to user 'baza_6055'@'localhost' for table 'guilds' (1142)
 [17:56:38.145] > Trigger: ondelete_guilds does not exist, creating it...
 [17:56:38.142] mysql_real_query(): CREATE TRIGGER `oncreate_guilds`  AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks`  (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`); INSERT  INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader',  2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`)  VALUES ('Member', 1, NEW.`id`); END; - MYSQL ERROR: TRIGGER command  denied to user 'baza_6055'@'localhost' for table 'guilds' (1142)
 [17:56:38.141] > Trigger: oncreate_guilds does not exist, creating it...
 [17:56:38.138] mysql_real_query(): CREATE TRIGGER `ondelete_accounts`  BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE  `type` NOT IN(1, 2) AND `value` = OLD.`id`; END; - MYSQL ERROR: TRIGGER  command denied to user 'baza_6055'@'localhost' for table 'accounts'  (1142)
 [17:56:38.138] > Trigger: ondelete_accounts does not exist, creating it...
I nie mog? zalogowa? si? na posta?;/
Prosz? o pomoc !
 

luzak123

Banned
Joined
Apr 14, 2011
Messages
529
Reaction score
41
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Powinna pomoc optymalizacja tabel...
 

henasek

Advanced User
Joined
Aug 17, 2011
Messages
161
Reaction score
0
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

#UP:
M?g?by? pom?c , bo nie znam si? a? tak :)
 

luzak123

Banned
Joined
Apr 14, 2011
Messages
529
Reaction score
41
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

w config.lua:

Code:
startupDatabaseOptimization = true

albo w phpmyadmin
 

henasek

Advanced User
Joined
Aug 17, 2011
Messages
161
Reaction score
0
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

#UP:
Mam ju? na true ale nie pomaga ;/
 

luzak123

Banned
Joined
Apr 14, 2011
Messages
529
Reaction score
41
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Proponuje ci zrobi? baz? od nowa...
Je?eli masz u?ytkownik?w w bazie to ja najpierw zaimportuj, wgraj schemat i p??niej backup...
 

henasek

Advanced User
Joined
Aug 17, 2011
Messages
161
Reaction score
0
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

ju? robi?em pare razy ;/
 

luzak123

Banned
Joined
Apr 14, 2011
Messages
529
Reaction score
41
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Code:
TRIGGER command denied to user 'baza_6055'@'localhost' for table  'players' (1142)

Hmm... czy?by? nie mia? uprawnie??
 

henasek

Advanced User
Joined
Aug 17, 2011
Messages
161
Reaction score
0
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Jestem subuzytkownikiem.
 

luzak123

Banned
Joined
Apr 14, 2011
Messages
529
Reaction score
41
Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Odp: Pomocy !!!!!!!!!!!!!!! <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

scaled.php


Upewnij si? ?e u?ytkownik z jakiego korzysta silnik ma uprawnienia zaznaczone wy?ej :)
 

henasek

Advanced User
Joined
Aug 17, 2011
Messages
161
Reaction score
0
Odp: Problem z odpaleniem OTS'a

Mo?na zamkn?? netshoot ma chwilowe problemy
 
Status
Not open for further replies.
Top