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