Trigger Denegado

[moro666]

Buenas, estoy intentando poner el galaxytool de ogame en 000webhost, el problema es que me sale esto al intalar:

Código:

TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtplayers'
Table: gtplayers (Trigger 2)	failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtplayers'
Table: gtalliances (Trigger 1)	failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtalliances'
Table: gtalliances (Trigger 2)	failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtalliances'
Table: gtreports (Trigger 1)	failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtreports'
Table: gtreports (Trigger 2)	failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtreports'
Installation failed

Pongo solo el trozo que falla...
Como que command denied? que passa aqui?
El instalador esasi, por si ayuda mas:

Código PHP:

  $query ="CREATE TRIGGER alliances_au AFTER UPDATE ON $allytable 
  FOR EACH ROW BEGIN 
    INSERT INTO $allyhistory SET 
        year = DATE_FORMAT(NOW(),'%Y'), 
        month = DATE_FORMAT(NOW(),'%m'), 
        day = DATE_FORMAT(NOW(),'%e'), 
        alliance_id = NEW.id, 
        members = NEW.members, 
        rank = NEW.rank, 
        points = NEW.points, 
        frank = NEW.frank, 
        fpoints = NEW.fpoints, 
        rrank = NEW.rrank, 
        rpoints = NEW.rpoints 
    ON DUPLICATE KEY UPDATE 
        rank=values(rank), points=values(points), 
        frank=values(frank), fpoints=values(fpoints), 
        rrank=values(rrank), rpoints=values(rpoints); 
  END"; 
    if (!mysql_query($query)) { 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $allytable (Trigger 2)</td><td class=\"failure\">failure</td></tr>\n"; 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\" class=\"failure\" colspan=\"2\">".mysql_error()."</td></tr>\n"; 
        $error_occured = true; 
    } else { 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $allytable (Trigger 2)</td><td class=\"success\">success</td></tr>\n"; 
    } 
 
    $query ="CREATE TRIGGER reports_ai AFTER INSERT ON $reporttable 
 FOR EACH ROW BEGIN 
     IF NEW.scanned = 'research' OR NEW.computech > 0 OR NEW.energytech > 0 THEN 
        UPDATE $playertable SET 
         spiolvl = NEW.spiolvl, 
         computech = NEW.computech, 
         waffentech = NEW.waffentech, 
         schildtech = NEW.schildtech, 
         rpz = NEW.rpz, 
         energytech = NEW.energytech, 
         hypertech = NEW.hypertech, 
         vbt = NEW.vbt, 
         impulse = NEW.impulse, 
         hra = NEW.hra, 
         lasertech = NEW.lasertech, 
         iontech = NEW.iontech, 
         plasmatech = NEW.plasmatech, 
         forschungsnetz = NEW.forschungsnetz, 
         expedition = NEW.expedition, 
         gravi = NEW.gravi, 
         last_tech_update = NOW() 
         WHERE id = (SELECT g.player_id FROM $reporttable r, $dbtablename g WHERE r.galaxy = g.galaxy AND r.system = g.system AND r.planet = g.planet AND r.planetname = g.planetname AND r.galaxy=NEW.galaxy AND r.system=NEW.system and r.planet=NEW.planet AND r.planetname=NEW.planetname LIMIT 1); 
     END IF; 
  END"; 
    if (!mysql_query($query)) { 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $reporttable (Trigger 1)</td><td class=\"failure\">failure</td></tr>\n"; 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\" class=\"failure\" colspan=\"2\">".mysql_error()."</td></tr>\n"; 
        $error_occured = true; 
    } else { 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $reporttable (Trigger 1)</td><td class=\"success\">success</td></tr>\n"; 
    } 
 
    $query ="CREATE TRIGGER reports_au AFTER UPDATE ON $reporttable 
 FOR EACH ROW BEGIN 
     IF NEW.scanned = 'research' OR NEW.computech > 0 OR NEW.energytech > 0 THEN 
        UPDATE $playertable SET 
         spiolvl = NEW.spiolvl, 
         computech = NEW.computech, 
         waffentech = NEW.waffentech, 
         schildtech = NEW.schildtech, 
         rpz = NEW.rpz, 
         energytech = NEW.energytech, 
         hypertech = NEW.hypertech, 
         vbt = NEW.vbt, 
         impulse = NEW.impulse, 
         hra = NEW.hra, 
         lasertech = NEW.lasertech, 
         iontech = NEW.iontech, 
         plasmatech = NEW.plasmatech, 
         forschungsnetz = NEW.forschungsnetz, 
         expedition = NEW.expedition, 
         gravi = NEW.gravi, 
         last_tech_update = NOW() 
         WHERE id = (SELECT g.player_id FROM $reporttable r, $dbtablename g WHERE r.galaxy = g.galaxy AND r.system = g.system AND r.planet = g.planet AND r.planetname = g.planetname AND r.galaxy=NEW.galaxy AND r.system=NEW.system and r.planet=NEW.planet AND r.planetname=NEW.planetname  LIMIT 1); 
    END IF; 
  END"; 
    if (!mysql_query($query)) { 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $reporttable (Trigger 2)</td><td class=\"failure\">failure</td></tr>\n"; 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\" class=\"failure\" colspan=\"2\">".mysql_error()."</td></tr>\n"; 
        $error_occured = true; 
    } else { 
        echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $reporttable (Trigger 2)</td><td class=\"success\">success</td></tr>\n"; 
    }  
   

[stramin]

el servidor '10.1.1.27' es tuyo?

[moro666]

Si, ws justo el mio, el problema es que si el processo es crear una tabla, esa se crea, pero al llegar al proceso trigger dice que no tengo acceso:

CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)

Esto si funciona, pero el codigo antenrior:

$query ="CREATE TRIGGER reports_au AFTER UPDATE ON $reporttable
FOR EACH ROW BEGIN
IF NEW.scanned = 'research' OR NEW.computech > 0 OR NEW.energytech > 0 THEN
UPDATE $playertable SET
spiolvl = NEW.spiolvl,
computech = NEW.computech,
waffentech = NEW.waffentech,
schildtech = NEW.schildtech,
rpz = NEW.rpz,
energytech = NEW.energytech,
hypertech = NEW.hypertech,
vbt = NEW.vbt,
impulse = NEW.impulse,
hra = NEW.hra,
lasertech = NEW.lasertech,
iontech = NEW.iontech,
plasmatech = NEW.plasmatech,
forschungsnetz = NEW.forschungsnetz,
expedition = NEW.expedition,
gravi = NEW.gravi,
last_tech_update = NOW()
WHERE id = (SELECT g.player_id FROM $reporttable r, $dbtablename g WHERE r.galaxy = g.galaxy AND r.system = g.system AND r.planet = g.planet AND r.planetname = g.planetname AND r.galaxy=NEW.galaxy AND r.system=NEW.system and r.planet=NEW.planet AND r.planetname=NEW.planetname LIMIT 1);
END IF;
END";

Esto me denega el acceso